从DataTable获取Json数据

时间:2023-03-08 20:41:33
从DataTable获取Json数据

public string GetJson(DataTable dt){

  JavaScriptSerializer jss=new JavaScriptSerializer();

  jss.MaxJsonLength=Int32.MaxValue;

  System.Collections.Arraylist dic=new System.Collections.ArrayList();

  foreach(DataRow dr  in dt.Rows){

    System.Collections.Generic.Dictionary<string,string> drow=new System.Collections.Generic.Dictionary<string,string>();

    foreach(DataColumn dc in dt.Columns){

      drow.Add(dc.ColumnName,dr[dc.ColumnName]);

    }

  dic.Add(drow);

  }

  return jss.Serialize(dic);

}