--------網(wǎng)絡(luò)摘取--------

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data;
using System.Text.RegularExpressions;
using System.Collections;
using System.Text;

namespace Public
{
/// <summary>
/// JsonAndDateTable 的摘要說明
/// </summary>
public static class JsonAndDateTable
{

/// <summary>
/// 根據(jù)Json返回DateTable,JSON數(shù)據(jù)格式如:
/// {table:[{column1:1,column2:2,column3:3},{column1:1,column2:2,column3:3}]}
/// </summary>
/// <param name="strJson">Json字符串</param>
/// <returns></returns>
public static DataTable JsonToDataTable(string strJson)
{
//取出表名
Regex rg = new Regex(@"(?<={)[^:]+(?=:\[)", RegexOptions.IgnoreCase);
string strName = rg.Match(strJson).Value;
DataTable tb = null;
//去除表名
strJson = strJson.Substring(strJson.IndexOf("[") + 1);
strJson =strJson.Substring(0, strJson.IndexOf("]"));

//獲取數(shù)據(jù)
rg = new Regex(@"(?<={)[^}]+(?=})");
MatchCollection mc = rg.Matches(strJson);
for (int i = 0; i < mc.Count; i++)
{
string strRow = mc[i].Value;
string[] strRows = strRow.Split(',');

//創(chuàng)建表
if (tb == null)
{
tb = new DataTable();
tb.TableName = strName;
foreach (string str in strRows)
{
DataColumn dc = new DataColumn();
string[] strCell = str.Split(':');
dc.ColumnName = strCell[0].ToString();
tb.Columns.Add(dc);
}
tb.AcceptChanges();
}

//增加內(nèi)容
DataRow dr = tb.NewRow();
for (int r = 0; r < strRows.Length; r++)
{
dr[r] = strRows[r].Split(':')[1].Trim().Replace("，", ",").Replace("：", ":").Replace("\"", "");
}
tb.Rows.Add(dr);
tb.AcceptChanges();
}

return tb;
}

/// <summary>
/// 根據(jù)DataTable返回JSON數(shù)據(jù)格式如:
/// {table:[{column1:1,column2:2,column3:3},{column1:1,column2:2,column3:3}]}
/// </summary>
/// <param name="tb">需要轉(zhuǎn)換的表</param>
/// <returns></returns>
public static string DateTableToJson(DataTable tb)
{
if (tb == null || tb.Rows.Count == 0)
{
return "";
}

string strName = "table";
/*
string strName = tb.TableName;
if (strName.Trim().Length == 0)
{
strName = "table";
}*/
StringBuilder sbJson = new StringBuilder();
sbJson.Append("{");
sbJson.Append("\"" + strName + "\":[");
Hashtable htColumns = new Hashtable();
for (int i = 0; i < tb.Columns.Count; i++)
{
htColumns.Add(i, tb.Columns[i].ColumnName.Trim());
}

for (int j = 0; j < tb.Rows.Count; j++)
{
if (j != 0)
{
sbJson.Append(",");
}
sbJson.Append("{");
for (int c = 0; c < tb.Columns.Count; c++)
{
sbJson.Append(htColumns[c].ToString() + ":\"" + tb.Rows[j][c].ToString().Replace(",", "，").Replace(":", "：").Replace("\r\n", " ") + "\",");
}
sbJson.Append("index:" + j.ToString()); //序號(hào)
sbJson.Append("}");
}
sbJson.Append("]}");
return sbJson.ToString();
}
}