转换后的格式如下:
[{"EMPLOYEE_CN_NAME":"王赋","EMPLOYEE_ID":"57","JOB_CN_NAME":".Net程序员"}, {"EMPLOYEE_CN_NAME":"周于","EMPLOYEE_ID":"59","JOB_CN_NAME":"Delphi程序员"}]
如果没有记录则显示
[]
public abstract class DT2JSON
{
#region dataTable转换成Json格式
/// <summary>
/// dataTable转换成Json格式
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public static string DataTable2Json(DataTable dt)
{
StringBuilder jsonBuilder = new StringBuilder();
jsonBuilder.Append("[");
for (int i = 0; i < dt.Rows.Count; i++)
{
jsonBuilder.Append("{");
for (int j = 0; j < dt.Columns.Count; j++)
{
jsonBuilder.Append("/"");
jsonBuilder.Append(dt.Columns[j].ColumnName);
jsonBuilder.Append("/":/"");
jsonBuilder.Append(dt.Rows[i][j].ToString().Replace("/"", ///");
jsonBuilder.Append("/",");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("},");
}
if (jsonBuilder.ToString().EndsWith(","))
{
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
}
jsonBuilder.Append("]");
return jsonBuilder.ToString();
}
//dataset 2 json
public static string Dataset2Json(DataSet ds)
{
StringBuilder json = new StringBuilder();
foreach (DataTable dt in ds.Tables)
{
json.Append("{/"");
json.Append(dt.TableName);
json.Append("/":");
json.Append(DataTable2Json(dt));
json.Append("}");
}
return json.ToString();
}
#endregion
}
[{"EMPLOYEE_CN_NAME":"王赋","EMPLOYEE_ID":"57","JOB_CN_NAME":".Net程序员"}, {"EMPLOYEE_CN_NAME":"周于","EMPLOYEE_ID":"59","JOB_CN_NAME":"Delphi程序员"}]
如果没有记录则显示
[]
public abstract class DT2JSON
{
#region dataTable转换成Json格式
/// <summary>
/// dataTable转换成Json格式
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public static string DataTable2Json(DataTable dt)
{
StringBuilder jsonBuilder = new StringBuilder();
jsonBuilder.Append("[");
for (int i = 0; i < dt.Rows.Count; i++)
{
jsonBuilder.Append("{");
for (int j = 0; j < dt.Columns.Count; j++)
{
jsonBuilder.Append("/"");
jsonBuilder.Append(dt.Columns[j].ColumnName);
jsonBuilder.Append("/":/"");
jsonBuilder.Append(dt.Rows[i][j].ToString().Replace("/"", ///");
jsonBuilder.Append("/",");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("},");
}
if (jsonBuilder.ToString().EndsWith(","))
{
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
}
jsonBuilder.Append("]");
return jsonBuilder.ToString();
}
//dataset 2 json
public static string Dataset2Json(DataSet ds)
{
StringBuilder json = new StringBuilder();
foreach (DataTable dt in ds.Tables)
{
json.Append("{/"");
json.Append(dt.TableName);
json.Append("/":");
json.Append(DataTable2Json(dt));
json.Append("}");
}
return json.ToString();
}
#endregion
}