public string DataTableToJson(DataTable dt)
{
string Json = "[";
int ColumnCount = dt.Columns.Count;
foreach (DataRow dr in dt.Rows)
{
Json += "{";
for (int i = 0; i < ColumnCount; i++)
Json += "\"" + dt.Columns[i] + "\":" + "\"" + dr[i].ToString().Trim() + "\",";
Json = Json.TrimEnd(',') + "},";
}
Json = Json.TrimEnd(',') + "]";
return Json;
}
05-06
1967
05-09
215