C# - Convert Datatable to JSON String in C#, VB.NET

Introduction:

Here I will explain how to convert asp.net datatable to JSON string in C#, VB.NET or How to get JSON string from Datatable in in C#, VB.NET

Description:

In previous posts I explained convert datatable to xml in asp.net, Convert datatable/dataset to arraylist, convert xml string to datatable in c#, asp.net, C#, SQL Server Interview Questions, send gridview as email body, upload and download files from gridview and many articles relating to asp.net, C#, VB.NET code snippets. Now I will explain how to convert datatable to JSON string in asp.net using C#, VB.NET.

To convert datatable to JSON string we need to write the code like as shown below

C# Code

// This method is used to convert datatable to json string 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<Dictionary<string, object>> rows = new List<Dictionary<string, object>>(); Dictionary<string, object> row; foreach (DataRow dr in dt.Rows) { row = new Dictionary<string, object>(); foreach (DataColumn col in dt.Columns) { row.Add(col.ColumnName, dr[col]); } rows.Add(row); } return serializer.Serialize(rows); } } }

VB.NET Code

' This method is used to convert datatable to json string Public Function ConvertDataTabletoString() As String Dim dt As New DataTable() Using con As New SqlConnection("Data Source=SureshDasari;Initial Catalog=master;Integrated Security=true") Using cmd As New SqlCommand("select title=City,lat=latitude,lng=longitude,description from LocationDetails", con) con.Open() Dim da As New SqlDataAdapter(cmd) da.Fill(dt) Dim serializer As New System.Web.Script.Serialization.JavaScriptSerializer() Dim rows As New List(Of Dictionary(Of String, Object))() Dim row As Dictionary(Of String, Object) For Each dr As DataRow In dt.Rows row = New Dictionary(Of String, Object)() For Each col As DataColumn In dt.Columns row.Add(col.ColumnName, dr(col)) Next rows.Add(row) Next Return serializer.Serialize(rows) End Using End Using End Function

If want to see above code in complete example check below link

Add Multiple Markers to Google Map v3 from database in asp.net

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email