呵呵 table直接转换json格式字符串啊!!
public string CreateJsonParameters(DataTable dt)
{
StringBuilder JsonString = new StringBuilder();
if (null != dt && 0 < dt.Rows.Count)
{
string[] ColumnName = new String[dt.Columns.Count];
for (int j = 0; j < dt.Columns.Count; j++)
{
ColumnName[j] = "\"" + dt.Columns[j].ColumnName.ToString().Replace("\"", "\\\"") + "\":\"";
}
JsonString.Append("[");
for (int i = 0; i < dt.Rows.Count; i++)
{
JsonString.Append("{");
for (int j = 0; j < dt.Columns.Count; j++)
{
JsonString.Append(ColumnName[j]);
JsonString.Append(dt.Rows[i][j].ToString().Replace("\"", "\\\""));
JsonString.Append("\",");
}
JsonString.Remove(JsonString.Length - 1, 1);
JsonString.Append("},");
}
JsonString.Remove(JsonString.Length - 1, 1);
JsonString.Append("]");
return JsonString.ToString();
}
else
{
return null;
}
}