方法一
public string DataTableJson(DataTable dt)
{
StringBuilder sb = new StringBuilder();
sb.Append("[");
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("{");
for (int j = 0; j < dt.Columns.Count; j++)
{
sb.Append("\"");
sb.Append(dt.Columns[j].ColumnName);
sb.Append("\":\"");
sb.Append(dt.Rows[i][j].ToString());
sb.Append("\",");
}
sb.Remove(sb.Length - 1, 1);
sb.Append("},");
}
sb.Remove(sb.Length - 1, 1);
sb.Append("]");
return sb.ToString();
}
}
方法二:引用using Newtonsoft.Json;
public string allUserH(DataTable dt)
{
string JsonString = string.Empty;
if (dt.Rows.Count > 0)
{
JsonString = JsonConvert.SerializeObject(dt);
}
}