Asp.net中Json格式转换为DataTable
来源:互联网 发布:淘宝商户消失 编辑:程序博客网 时间:2024/05/21 18:35
最近在做项目,有一个功能需要后台接收前端传输过来的json格式数据,然后保存到数据库。由于前端过来的数据可能会比较多,所以打算用Update方法,传入DataTable进行数据的保存,所以就需要把前端json数据转化为DataTable格式。好了,闲话不多说啦,下面是json个数转化为DataTable的代码:
//项目中用到的json格式如下:
[{"id":"29","name":"AMOI15s-DVB","filesize":"8578064","duration":"15080",
"bitrate":"4500000","video_stream_type1":"2","audio_stream_type1":"4","active":"1"},
{"id":"28","name":"BENQ30s-DVB",,"filesize":"17012308","duration":"30080",
"bitrate":"4500000","video_stream_type1":"2","audio_stream_type1":"4","active":"1"},{"id":"1","name":"zhongqiu","filesize":"69341168","duration":"94680",
"bitrate":"5856128","video_stream_type1":"2","audio_stream_type1":"4","active":"1"}]
要保存的DataTable格式:
public DataTable getDataTable() { DataTable dt = new DataTable(); dt.Columns.Add("channelid", typeof(System.Int32)); dt.Columns.Add("name", typeof(System.String)); dt.Columns.Add("filesize", typeof(System.Int32)); dt.Columns.Add("duration", typeof(System.Int32)); dt.Columns.Add("bitrate", typeof(System.Int32)); dt.Columns.Add("video_stream_type1", typeof(System.Int32)); dt.Columns.Add("audio_stream_type1", typeof(System.Int32)); dt.Columns.Add("active", typeof(System.Int32)); return dt; } /// <summary> /// json转换为DataTable /// </summary> /// <param name="json">需要转化的json格式字符串</param> /// <returns></returns> public DataTable updateInfo(string json) { System.Web.Script.Serialization.JavaScriptSerializer jss =new System.Web.Script.Serialization.JavaScriptSerializer(); object[] obj = (object[])jss.DeserializeObject(json); Dictionary<string, object> dic; DataRow dr; DataTable dt = getDataTable(); foreach (object _obj in obj) { dr = dt.NewRow(); dt.Rows.Add(dr); dic = (Dictionary<string, object>)_obj; dr["channelid"] = dic["channelid"]; dr["name"] = dic["name"]; dr["filesize"] = dic["filesize"]; dr["duration"] = dic["duration"]; dr["bitrate"] = dic["bitrate"]; dr["video_stream_type1"] = dic["video_stream_type1"]; dr["audio_stream_type1"] = dic["audio_stream_type1"]; dr["active"] = dic["active"]; } return dt; }
- Asp.net中Json格式转换为DataTable
- DataTable(DataSet)转换为JSON格式
- .NET DataTable转化为json格式
- asp.net将类实例转换为JSON格式
- JS转为json数据、.NET DataTable转化为json格式
- json转换为DataTable
- DataTable转换为JSON
- json转换为datatable
- JSON转换为DataTable
- json 转换 为 DataTable
- asp.net中gridview中数据保存为cvs格式,datatable中
- .net DataTable转换json
- asp.net DataTable和Dataset序列化成Json格式
- dataTable转换成Json格式
- DataSet、DataTable转换为Json
- 将datatable转换为json
- 将DataTable转换为Json
- java中数组转换为json格式
- Linux/Windows下通过Console发送EOF
- Java正则表达式获取匹配结果
- SQL1072C异常
- DSG realsync BUG 之ORA-00001: unique constraint
- Blocks编程
- Asp.net中Json格式转换为DataTable
- android 解锁
- OSI七层模型概括,简单明了
- 各种图表控件推荐和对比评测
- -bash: wget: command not found 解决方法
- ibatis的SqlMap.xml中传递多参数
- load_sysfile;CreateService
- 根据《IEEE Std 1003.1-2008》生成VIM使用的TAGS文件的过程
- 概述CentOS Memcached安装及运行检测