DataTable转json

public string GetLigerUIJson(DataTable dt)

{

  List<Dictionary<string, string>> list = new List<Dictionary<string, string>>();

  foreach (DataRow row in dt.Rows)

  {

    Dictionary<string, string> dic = new Dictionary<string, string>();

    foreach (DataColumn column in dt.Columns)

    {

        dic.Add(column.ColumnName, row[column].ToString());

    }

    list.Add(dic);

}

  string result = JavaScriptConvert.SerializeObject(list);

  return "{Rows:" + result + ",Total:" + dt.Rows.Count + "}";

}