获取json串，根据datatable

 

 /// <summary>
        /// 获取json串，根据datatable
        /// </summary>
        /// <param name="dt"></param>
        /// <returns></returns>
        public static String GetJsonByTable(DataTable dt)
        {
            String rtn = String.Empty;
            String data = String.Empty;

            rtn += "[";
            foreach (DataRow dr in dt.Rows)
            {
                data = "{";
                foreach (DataColumn dc in dt.Columns)
                {
                    if (dt.Columns.IndexOf(dc) != dt.Columns.Count - 1)
                    {
                        data += "\"" + dc.ColumnName + "\":\"" + dr[dc].ToString() + "\",";
                    }
                    else
                    {
                        data += "\"" + dc.ColumnName + "\":\"" + dr[dc].ToString() + "\"";
                    }
                }
                if (dt.Rows.IndexOf(dr) != dt.Rows.Count - 1)
                {
                    data += "},";
                }
                else
                {
                    data += "}";
                }
                rtn += data;
            }

            rtn += "]";

            return rtn;
        }