Loading

Convert DataTable to Json string

Convert DataTable to Json string

Vishnu Vachhani

10y1.1kVisual Basic .NET

I have a datatable dt and i want to convert this DataTable to Json string for Ajax Webmethod....

Thanks in advance...

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Raja T10y ago
Hi Vishnu, You are most welcome..
Vishnu Vachhani10y ago
Thanks a lot...
Raja T10y ago
Hi Vishnu, Try like

Public string ConvertDataTabletoString()
{
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection("Data Source=SureshDasari;Initial Catalog=master;Integrated Security=true"))
{
using (SqlCommand cmd = new SqlCommand("select title=City,lat=latitude,lng=longitude,description from LocationDetails", con))
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
List> rows = new List>();
Dictionary row;
foreach (DataRow dr in dt.Rows)
{
row = new Dictionary();
foreach (DataColumn col in dt.Columns)
{
row.Add(col.ColumnName, dr[col]);
}
rows.Add(row);
}
return serializer.Serialize(rows);
}
}
}
More details check out below links

http://www.c-sharpcorner.com/UploadFile/9bff34/3-ways-to-convert-datatable-to-json-string-in-Asp-Net-C-Sharp/

http://codepedia.info/2015/07/convert-datatable-to-json-in-asp-net-c-sharp/

http://stackoverflow.com/questions/17398019/how-to-convert-datatable-to-json-in-c-sharp
Ravi Patel10y ago
Hi,

go through following link
http://www.c-sharpcorner.com/UploadFile/9bff34/3-ways-to-convert-datatable-to-json-string-in-Asp-Net-C-Sharp/
http://www.aspdotnet-suresh.com/2013/05/c-convert-datatable-to-json-string-in-c.html