dataTable 转换json串
来源:互联网 发布:人工智能天使轮 编辑:程序博客网 时间:2024/05/24 04:35
namespace Net.String.ConsoleApplication
{
using System;
using System.Data;
using System.Collections;
using System.ComponentModel;
using System.Collections.Generic;
using System.Web.Script.Serialization;
public class JsonHelper
{
/// <summary>
/// 把json字符串转成对象
/// </summary>
/// <typeparam name="T">对象</typeparam>
/// <param name="data">json字符串</param>
public static T Deserialize<T>(string data)
{
System.Web.Script.Serialization.JavaScriptSerializer json = new System.Web.Script.Serialization.JavaScriptSerializer();
return json.Deserialize<T>(data);
}
/// <summary>
/// 把对象转成json字符串
/// </summary>
/// <param name="o">对象</param>
/// <returns>json字符串</returns>
public static string Serialize(object o)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
System.Web.Script.Serialization.JavaScriptSerializer json = new System.Web.Script.Serialization.JavaScriptSerializer();
json.Serialize(o, sb);
return sb.ToString();
}
/// <summary>
/// 把DataTable对象转成json字符串
/// </summary>
public string ToJson(DataTable dt)
{
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
ArrayList arrayList = new ArrayList();
foreach (DataRow dataRow in dt.Rows)
{
Dictionary<string, object> dictionary = new Dictionary<string, object>();
foreach (DataColumn dataColumn in dt.Columns)
{
dictionary.Add(dataColumn.ColumnName, dataRow[dataColumn.ColumnName]);
}
arrayList.Add(dictionary);
}
return javaScriptSerializer.Serialize(arrayList);
}
}
public static class EnumerableExtension
{
/// <summary>
/// 集合添加一个对象
/// </summary>
public static IEnumerable<T> Add<T>(this IEnumerable<T> e, T value)
{
foreach (var cur in e)
{ yield return cur; }
yield return value;
}
/// <summary>
/// 把集合转成DataTable
/// </summary>
public static DataTable ConvertToDataTable<T>(this IEnumerable<T> enumerable)
{
var dataTable = new DataTable();
foreach (PropertyDescriptor pd in TypeDescriptor.GetProperties(typeof(T)))
{
dataTable.Columns.Add(pd.Name, pd.PropertyType);
}
foreach (T item in enumerable)
{
var Row = dataTable.NewRow();
foreach (PropertyDescriptor dp in TypeDescriptor.GetProperties(typeof(T)))
{
Row[dp.Name] = dp.GetValue(item);
}
dataTable.Rows.Add(Row);
}
return dataTable;
}
}
}
- dataTable 转换json串
- DataTable转换成JSON
- DataTable 转换JSON
- json转换为DataTable
- .net DataTable转换json
- DataTable 转换 JSON
- json DataTable互相转换
- DataTable转换为JSON
- JSON转换DataTable
- DataTable转换Json
- json转换为datatable
- JSON转换为DataTable
- DataTable 转换成 Json
- json 转换 为 DataTable
- json与DataTable相互转换
- json ,dataTable的相互转换
- dataTable和json相互转换
- DataSet、DataTable转换为Json
- 2015 Multi-University Training Contest 1(HDOJ5288、5289)
- Carry Leetcode
- zedboard Boot from Flash(FLASH和SD卡启动)
- CF 124B
- java程序查询 当前星期 及往后推六天 显示一周的星期
- dataTable 转换json串
- VIM
- AWVS10_Acunetix_Web_Vulnerability_Scanner教程-扫描配合sql进行注入
- 多校第四场 1012 hdu 5338 ZZX and Permutations(线段树+树状数组+贪心)
- How Many Tables-并查集
- unity-Animation
- java中的sleep()和wait()的区别
- java 多线程--线程池
- recovery 字体大小修改