Read SQL Table into C# DataTable

Question

I've read a lot of posts about inserting a DataTable into a SQL table, but is there an easy way to pull a SQL table into a .NET DataTable?

Answer 1

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();      public PullDataTest()     {     }      // 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 = new SqlConnection(connString);                 SqlCommand cmd = new SqlCommand(query, conn);         conn.Open();          // create data adapter         SqlDataAdapter da = new SqlDataAdapter(cmd);         // this will query your database and return the result to your datatable         da.Fill(dataTable);         conn.Close();         da.Dispose();     } } 

Answer 2

var table = new DataTable();     using (var da = new SqlDataAdapter("SELECT * FROM mytable", "connection string")) {           da.Fill(table); }