Here, give this a shot (this is just a pseudocode) using System; using System.Data; using System.Data.SqlClient; public class PullDataTest { // your data table private DataTable dataTable = new DataTable(); // your method to pull data from database to datatable public void PullData() { string connString = @"your connection string here"; string query = "select * from table"; SqlConnection conn ...

Better if you not use the DataReader.Load() method for read all type of SQL Select Query. I used it for read out a complex SELECT with some LEFT JOIN and I got "Failed to enable constraints.

Jan 31, 2012 · //best way to deal with this is sqlbulkcopy //but if you dont like it you can do it like this //read current sql table in an adapter //add rows of datatable , I have mentioned a simple way of it //and finally updating changes Dim cnn As New SqlConnection("connection string") cnn.Open() Dim cmd As New SqlCommand("select * from sql_server_table ...

If using SQL Server, SqlBulkCopy.WriteToServer(DataTable) SqlBulkCopy.WriteToServer Method (DataTable) Or also with SQL Server, you can write it to a .csv and use BULK INSERT. BULK INSERT (Transact-SQL) If using MySQL, you could write it to a .csv and use LOAD DATA INFILE. LOAD DATA INFILE Syntax

Jul 24, 2013 · I have a DataTable, filled with data. It has a replicated structure to my SQL table. ID - NAME. The SQL table currently has a bit of data, but I need to now update it with all the data of my DataTable. It needs to UPDATE the SQl Table if …

_Context.Database.SqlQuery<DataTable>(sql, parameters).FirstOrDefault(); This is my solution. It returns a DataTable that is fetched using an ADO.NET SqlDataReader - which I believe is faster than a SqlDataAdapter on read-only data.

public async Task<DataTable> CallDb(string connStr, string sql) { var dt = new DataTable(); var connection = new SqlConnection(connStr); var reader = await connection.CreateCommand().ExecuteReaderAsync(); dt.Load(reader); return dt; } Of course, some changes like using statements should be made. However, here you …

Apr 8, 2015 · Define a table type in SQL Server. You need to create a user-defined table type in SQL Server that matches the structure of your DataTable: CREATE TYPE dbo.MyTableType AS TABLE ( Name NVARCHAR(50), Age INT ); Note the READONLY keyword, which is required for table-valued parameters. Pass the DataTable to the stored procedure from .NET.

May 16, 2014 · I am using entity framework. There is one particular situation in my application where I have to use a stored procedure. Since there are a lot of SQL statements written in the SP, I don't want to re-

Oct 18, 2012 · What is the code with the smallest number of lines that will generate a DataTable from this SQL query? SELECT * FROM [Table1] WHERE ([Date] BETWEEN @Date1 AND @Date2) AND ([Field1] IS NULL OR [Field2] IS NULL)