The fastest way to convert DataTable into JSON string

C Sharp:


public string GetJson(DataTable dt)
{

System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();

List> rows = new List>();

Dictionary row = null;

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);

}


Vb.Net

Public Function GetJson(ByVal dt As DataTable) As String

    Dim serializer As System.Web.Script.Serialization.JavaScriptSerializer = 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 Function