Convert DataTable to Json string

Question

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

Raja T · Answer

Hi Vishnu, You are most welcome..

Vishnu Vachhani · Answer

Thanks a lot...

Raja T · Answer

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 Patel · Answer

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

Convert DataTable to Json string

Answers (4)