{"id":553,"date":"2014-01-01T03:06:58","date_gmt":"2014-01-01T03:06:58","guid":{"rendered":"http:\/\/a1webdesignteam.com\/blog\/?p=553"},"modified":"2014-01-01T03:06:58","modified_gmt":"2014-01-01T03:06:58","slug":"create-data-table-from-sql-query-in-c","status":"publish","type":"post","link":"https:\/\/a1webdesignteam.com\/blog\/create-data-table-from-sql-query-in-c\/","title":{"rendered":"Create Data Table From SQL Query in C#"},"content":{"rendered":"

Namespaces required for methods<\/p>\n

<\/div>\n
\n
<\/div>\n
\n\n\n\n
\n
\n
1<\/div>\n
2<\/div>\n<\/div>\n<\/td>\n
\n
\n
using System.Data;<\/div>\n
using System.Data.SqlClient;<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Namesapce System.Data \u00a0is required for DataTable, and System.Data.SqlClient is required for SqlDataAdapter<\/p>\n

Get DataTable from SQL Query.<\/p>\n

\n
<\/div>\n
\n\n\n\n
\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n<\/div>\n<\/td>\n
\n
\n
public DataTable getDataTable(string query)<\/div>\n
{<\/div>\n
\u00a0\u00a0\u00a0\u00a0string connection= “server=Sharp-Coders\\SQLEXPRESS;UID=sa;password=sa;database=MyDatabase”;<\/div>\n
\u00a0\u00a0\u00a0\u00a0DataTable dataTable1 = new DataTable();<\/div>\n
\u00a0\u00a0\u00a0\u00a0using (SqlDataAdapter dAdapter = new SqlDataAdapter(query, connection))<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 dAdapter.Fill(dataTable1);<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}<\/div>\n
\u00a0\u00a0\u00a0\u00a0return dataTable1;<\/div>\n
}<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

You need to pass query in parameter and it returns DataTable<\/p>\n

Demo<\/strong><\/p>\n

\n
<\/div>\n
<\/div>\n
\n\n\n\n
\n
\n
1<\/div>\n<\/div>\n<\/td>\n
\n
\n
DataTable dtSales = getDataTable(“Select * from Sales”);<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

or<\/p>\n

\n
<\/div>\n
\n\n\n\n
\n
\n
1<\/div>\n
2<\/div>\n<\/div>\n<\/td>\n
\n
\n
string query = “Select * from Sales”;<\/div>\n
DataTable dtSales = getDataTable( query );<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Namespaces required for methods 1 2 using System.Data; using System.Data.SqlClient; Namesapce System.Data \u00a0is required for DataTable, and System.Data.SqlClient is required for SqlDataAdapter Get DataTable from SQL Query. 1 2 3 4 5 6 7 8 9 10 public DataTable getDataTable(string query) { \u00a0\u00a0\u00a0\u00a0string connection= “server=Sharp-Coders\\SQLEXPRESS;UID=sa;password=sa;database=MyDatabase”; \u00a0\u00a0\u00a0\u00a0DataTable dataTable1 = new DataTable(); \u00a0\u00a0\u00a0\u00a0using (SqlDataAdapter dAdapter = new […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/posts\/553"}],"collection":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/comments?post=553"}],"version-history":[{"count":0,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/posts\/553\/revisions"}],"wp:attachment":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/media?parent=553"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/categories?post=553"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/tags?post=553"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}