前端用的jqueryUI框架获取json格式数据绑定显示表格。后端通过WebService获取的数据是DataTable。现将获取DataTable转Json,也支持将数据集合转Json。一。项目中引用:Newtonsoft.Json 二。功能代码,很简单:using System;using System.Data;namespace WebApplication1.Common{ public class DataTableToModel { public static DataTable GetData() { DataTable dt = new DataTable(); dt.Colu...
Datatable dt=new Datatable();StringBuilder JsonString = new StringBuilder(); //Exception Handling if (dt != null && dt.Rows.Count > 0) { JsonString.Append("{ "); JsonString.Append("\"T_blog\":[ "); for (int i = 0; i < dt.Rows.Count; i++) { JsonString.Append("{ "); for (int j = 0...
///<summary>/// 将json转换为DataTable///</summary>///<param name="strJson">得到的json</param>///<returns></returns>private DataTable JsonToDataTable(string strJson){//转换json格式strJson = strJson.Replace(",\"", "*\"").Replace("\":", "\"#").ToString();//取出表名 var rg = new Regex(@"(?<={)[^:]+(?=:\[)", RegexOptions.IgnoreCase);string strName = rg.Match(strJson).Value;DataTable tb = null;//去除表...
using System;
using System.Data;
using System.Linq;
using System.Collections;
using System.Collections.Generic;
using System.Web.Script.Serialization;namespace ***
{publicclass DatatableToJson{#region DataTable --> Json 字符串///<summary>/// DataTable 对象 转换为Json 字符串///</summary>///<param name="dt"></param>///<returns></returns>publicstaticstring ToJson(this DataTable dt){JavaScriptSerializ...
/// <summary> /// 将json转换为DataTable /// </summary> /// <param name="strJson">得到的json</param> /// <returns></returns> private DataTable JsonToDataTable(string strJson) { //转换json格式 strJson = strJson.Replace(",\"", "*\"").Replace("\":", "\"#").ToString(); //取出表名 var rg = new Regex(@"(?<={)[^:]+(?=...
1、将dt序列化成json,放到前台的隐藏控件【hidBoundary】中: 代码如下: string json = JsonConvert.SerializeObject(dtTemp); this.hidBoundary.Value = json; 需要引用Newtonsoft.Json.dll 2、从前台隐藏空间中取得dt中的数据 代码如下: var boundaryDiv = $(#hidBoundary); if (boundaryDiv != undefined && boundaryDiv.length != 0) { var jsonString = boundaryDiv.val(); _jsonBoundary = jQuery.parseJSON(jsonString)...
1、将dt序列化成json,放到前台的隐藏控件【hidBoundary】中: 代码如下:string json = JsonConvert.SerializeObject(dtTemp); this.hidBoundary.Value = json; 需要引用Newtonsoft.Json.dll 2、从前台隐藏空间中取得dt中的数据 代码如下:var boundaryDiv = $(#hidBoundary); if (boundaryDiv != undefined && boundaryDiv.length != 0) { var jsonString = boundaryDiv.val(); _jsonBoundary = jQuery.parseJSON(jsonString); ...
本文实例讲述了asp.net使用DataTable构造Json字符串的方法。分享给大家供大家参考,具体如下:
/// <summary>
/// 将datatable转换为json
/// </summary>
/// <param name="dtb"></param>
/// <returns></returns>
private string Dtb2Json(DataTable dtb) {JavaScriptSerializer jss = new JavaScriptSerializer();System.Collections.ArrayList dic = new System.Collections.ArrayList();foreach (DataRow dr in dtb.Rows){Syst...
Select * from parseJSON(‘{"Person":{"firstName": "John","lastName": "Smith","age": 25,"Address":{"streetAddress":"21 2nd Street","city":"New York","state":"NY","postalCode":"10021"},"PhoneNumbers":{"home":"212 555-1234","fax":"646 555-4567"}}
}
‘)结果展示:parseJSON源码:CREATE FUNCTION dbo.parseJSON( @JSON NVARCHAR(MAX))
RETURNS @hierarchy TABLE(element_id INT IDENTITY(1, 1) NOT NULL, /* intern...
看过Ext - EditGridPanel实现效果的朋友会很惊讶,一个Grid就能实现所有增删改查功能。在展示给客户看时,让你的表现得很风骚。而他们又怎么知道,我们在调试js时,是多么痛苦。 如何在js中调用后台业务逻辑类,在我前面的文章中已经讲述过,而本篇的重点在于看过Ext - EditGridPanel实现效果的朋友会很惊讶,一个Grid就能实现所有增删改查功能。在展示给客户看时,让你的表现得很风骚。而他们又怎么知道,我们在调试js时,是多么痛...
我有一个带有4列的DataTable. (ID,TestName,TestResult,IsValidRequest).我想转换TestName& Testresult成json.string json = Newtonsoft.Json.JsonConvert.SerializeObject(dt);变量’json’中的当前JSON:[ { "TestID":1,"TestName":"wifi_result","TestResult":"1","IsValidRequest":1},{ "TestID":7,"TestName":"mic_result","TestResult":"1","IsValidRequest":1},{ "TestID":8,"TestName":"video_result","TestResult":"1...
//对象转换为Json字符串 public static string ToJson(object jsonObject){object objectValue = string.Empty;string jsonString = "{";if (jsonObject==null){return jsonString + "}";}PropertyInfo[] propertyInfo = jsonObject.GetType().GetProperties();for (int i = 0; i < propertyInfo.Length; i++){try{objectValue = propertyInfo[i].GetGetMethod().Invoke(jsonObject, BindingFlags.InvokeMethod, null, new object[...
1.NewTonSoft.jsonpublic static string DataTableToJson(DataTable dt){if (dt == null && dt.Rows.Count <= 0){return "";}else{IsoDateTimeConverter convert = new IsoDateTimeConverter();convert.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";return JsonConvert.SerializeObject(dt, Formatting.None, convert);}}View Code
2.net frework 版本4.5以上public static string Dtb2Json(DataTable dtb){JavaScriptSerializer jss =...
public string JsonToTable(string json,string type) { string a = ""; DataTable dTb = new DataTable(); DataTable result;//处理json数据 if(type == "1") #region { try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); javaScriptSerializer...
/// <summary>
/// Table转json
/// </summary>
/// <param name="dt">DataTable</param>
/// <returns></returns>
public static string SerializeDataTableToJson(DataTable dt)
{
string rtn = "";
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter { DateTimeFormat = "yyyy-MM-dd HH:mm:ss" };
rtn = Newtonsoft.Json.J...