C# - How to copy rows from table in SQL server and insert into DataTable?

Question

I have a table in my Database to store Holidays. The Columns:

Holiday, Day, Date

I want to copy all the rows from this table into a DataTable in my C# application. Iv created the DataTable with the same Columns.

DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[3] {
            new DataColumn("Holiday", typeof(string)),
            new DataColumn("Day", typeof(string)),
            new DataColumn("Date", typeof(DateTime))
        });

How can I populate this DataTable with all of the rows from my SQL Server database?

with a SQL SELECT statement? You dont need to define the DataTable, the db Provider will do that for you — Ňɏssa Pøngjǣrdenlarp, Dec 31 '15 at 18:11
As always, you could read the [documentation](https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter(v=vs.110).aspx). — Michael McGriff, Dec 31 '15 at 18:11
The answer to this question must be easily available as Michael McGiff notes above. Please do your research first. Thank you. — Peter Smith, Dec 31 '15 at 18:15
Possible duplicate of [Read SQL Table into C# DataTable](http://stackoverflow.com/questions/6073382/read-sql-table-into-c-sharp-datatable) — Michael McGriff, Dec 31 '15 at 18:18

Jonathan Carroll · Accepted Answer · 2015-12-31T18:15:26.170

0

You can just use a Data Adapter to fill the datatable.

 DataTable dt = new DataTable();
 using (SqlConnection sqlConn = new SqlConnection(connectionString))
 {
     using (SqlCommand cmd = new SqlCommand("SELECT * FROM Holidays", sqlConn))
     {
         SqlDataAdapter da = new SqlDataAdapter(cmd);
         da.Fill(dt);
     }
 }

edited Dec 31 '15 at 18:15

answered Dec 31 '15 at 18:13

Jonathan Carroll

880
1
5
20

C# - How to copy rows from table in SQL server and insert into DataTable?

1 Answers1