C# 根据DataTable 转换成JSON 文本字符串数据
C# 根据 DataTable 转换为 JSON 字符串文本
public string DataTable2Json(DataTable data) { System.Collections.ArrayList dic = new System.Collections.ArrayList(); foreach (DataRow row in data.Rows) { System.Collections.Generic.Dictionary<string, object> drow = new System.Collections.Generic.Dictionary<string, object>(); foreach (DataColumn dc in data.Columns) { drow.Add(dc.ColumnName, row[dc.ColumnName]); } dic.Add(drow); } string json = Newtonsoft.Json.JsonConvert.SerializeObject(dic, Newtonsoft.Json.Formatting.Indented); return json; }
GarsonZhang www.yesdotnet.com
C# 根据List<DataRow> 转换为JSON数据
public string DataTable2Json(List<DataRow> data) { System.Collections.ArrayList dic = new System.Collections.ArrayList(); foreach (DataRow row in data.Rows) { System.Collections.Generic.Dictionary<string, object> drow = new System.Collections.Generic.Dictionary<string, object>(); foreach (DataColumn dc in data.Columns) { drow.Add(dc.ColumnName, row[dc.ColumnName]); } dic.Add(drow); } string json = Newtonsoft.Json.JsonConvert.SerializeObject(dic, Newtonsoft.Json.Formatting.Indented); return json; }
GarsonZhang www.yesdotnet.com
C# 获得 dataGridView 选择的行,并且转换为 JSON 文本数据
System.Collections.ArrayList dic = new System.Collections.ArrayList(); foreach (DataGridViewRow o in dataGridView1.SelectedRows) { DataRow row = (o.DataBoundItem as DataRowView).Row; System.Collections.Generic.Dictionary<string, object> drow = new System.Collections.Generic.Dictionary<string, object>(); foreach (DataColumn dc in row.Table.Columns) { drow.Add(dc.ColumnName, row[dc.ColumnName]); } dic.Add(drow); } string json = Newtonsoft.Json.JsonConvert.SerializeObject(dic, Newtonsoft.Json.Formatting.Indented);
GarsonZhang www.yesdotnet.com
版权声明:本文为YES开发框架网发布内容,转载请附上原文出处连接
post YES开发框架