心影(LM)

导航

如何 DataTable格式转换json格式

1.序列化啊  宝贝!!

public string DataTableToJsonWithJsonNet(DataTable table)
{
   string jsonString=string.Empty;
   jsonString = JsonConvert.SerializeObject(table);
   return jsonString;
}

  

额  

 

2.还有一个恶心点的方法

 

public string DataTableToJson(DataTable table) 
{ 
var JsonString = new StringBuilder(); 
if (table.Rows.Count > 0) 
{ 
JsonString.Append("["); 
for (int i = 0; i < table.Rows.Count; i++) 
{ 
JsonString.Append("{"); 
for (int j = 0; j < table.Columns.Count; j++) 
{ 
if (j < table.Columns.Count - 1) 
{ 
JsonString.Append("\"" + table.Columns[j].ColumnName.ToString()
+ "\":" + "\"" + table.Rows[i][j].ToString() + "\","); 
} 
else if (j == table.Columns.Count - 1) 
{ 
JsonString.Append("\"" + table.Columns[j].ColumnName.ToString()
+ "\":" + "\"" + table.Rows[i][j].ToString() + "\""); 
} 
} 
if (i == table.Rows.Count - 1) 
{ 
JsonString.Append("}"); 
} 
else 
{ 
JsonString.Append("},"); 
} 
} 
JsonString.Append("]"); 
} 
return JsonString.ToString(); 
}
自定义格式化

 



 

posted on 2019-04-02 14:51  心影(LM)  阅读(851)  评论(0编辑  收藏  举报