/// <summary>
/// 数据行转Json
/// </summary>
/// <param name="dr">数据行</param>
/// <returns></returns>
public static string DataRowToJson(DataRow dr)
{
StringBuilder sb = new StringBuilder();
sb.Append("{");
foreach (DataColumn dc in dr.Table.Columns)
{
sb.Append("\"");
sb.Append(dc.ColumnName);
sb.Append("\":\"");
if (dr[dc] != null && dr[dc] != DBNull.Value && dr[dc].ToString() != "")
sb.Append(dr[dc]);
else
sb.Append(" ");
sb.Append("\",");
}
sb = sb.Remove(sb.Length - 1, 1);
sb.Append("},");
return sb.ToString();
}
C# 数据行转Json
最新推荐文章于 2024-04-07 08:36:31 发布