数据表转换成json(DatatableToJson)

#region 转换Table为JSON数据
/// <summary>
/// 转换Table为JSON数据
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public static string TableToJson(DataTable dt)
{
StringBuilder sb = new StringBuilder("[");
foreach (DataRow row in dt.Rows)
{
if (!row.Equals(dt.Rows[])) sb.Append(",");
sb.Append("{");
foreach (DataColumn col in dt.Columns)
{
if (!col.Equals(dt.Columns[])) sb.Append(",");
string value = GetText(row, col.ColumnName);
if (string.IsNullOrEmpty(value)) continue; //跳过为空的数据
sb.Append("\"").Append(col.ColumnName).Append("\":\"").Append(value).Append("\"");
}
sb.Append("}");
}
sb.Append("]");
return sb.ToString();
}
/// <summary>
/// 从datable中读取文本
/// </summary>
/// <param name="row"></param>
/// <param name="col"></param>
/// <returns></returns>
private static string GetText(DataRow row, string col)
{
return row.IsNull(col) ? string.Empty : row[col].ToString();
}
#endregion