DataTable数据转成Json格式
//引用
using Newtonsoft.Json;
//带表名
public static string DataTableToJSON(DataTable dt, string dtName)
{
StringBuilder sb = new StringBuilder();
StringWriter sw = new StringWriter(sb);
using (JsonWriter jw = new JsonTextWriter(sw))
{
JsonSerializer ser = new JsonSerializer();
jw.WriteStartObject();
jw.WritePropertyName(dtName);
jw.WriteStartArray();
foreach (DataRow dr in dt.Rows)
{
jw.WriteStartObject();
foreach (DataColumn dc in dt.Columns)
{
jw.WritePropertyName(dc.ColumnName);
ser.Serialize(jw, dr[dc].ToString());
}
jw.WriteEndObject();
}
jw.WriteEndArray();
jw.WriteEndObject();
sw.Close();
jw.Close();
}
return sb.ToString();
}
//不带表名
public static string DataTableToJSON(DataTable table)
{
StringBuilder json = new StringBuilder();
json.Append("[");
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow row = table.Rows[i];
json.Append("{");
for (int j = 0; j < table.Columns.Count; j++)
{
string columnName = table.Columns[j].ColumnName;
string columnType = table.Columns[j].DataType.Name;
if (columnType == "Int32" || columnType == "Int16" || columnType == "Decimal")
{
json.AppendFormat("\"{0}\":\"{1}\"", columnName, row.IsNull(columnName) ? "" : row[columnName]);
}
else if (columnType == "Boolean")
{
json.AppendFormat("\"{0}\":{1}", columnName, row.IsNull(columnName) ? "" : row[columnName].ToString().ToLower());
}
else
{
json.AppendFormat("\"{0}\":\"{1}\"", columnName, row[columnName]);
}
if (j < table.Columns.Count - 1) json.Append(","); // add comma if not last column
}
json.Append("}");
if (i < table.Rows.Count - 1) json.Append(","); // add comma if not last row
}
json.Append("]");
return json.ToString();
}
Newtonsoft.Json DLL下载地址