database数据表转成JSON

<!--<br /> <br /> Code highlighting produced by Actipro CodeHighlighter (freeware)<br /> http://www.CodeHighlighter.com/<br /> <br /> --> ///   <summary>  
     ///  将一个数据表转换成一个JSON字符串，在客户端可以直接转换成二维数组。 
     ///   </summary>  
     ///   <param name="source"> 需要转换的表。 </param>  
     ///   <returns></returns>  
     public   static   string  DataTableToJson(DataTable source) 
    { 
         if  (source.Rows.Count  ==   0 ) 
             return   "" ; 
        StringBuilder sb  =   new  StringBuilder( " [ " ); 
         foreach  (DataRow row  in  source.Rows) 
        { 
            sb.Append( " [ " ); 
             for  ( int  i  =   0 ; i  <  source.Columns.Count; i ++ ) 
            { 
                sb.Append( ' " '   +  row.ToString()  +   " \ " , " ); 
            } 
            sb.Remove(sb.Length  -   1 ,  1 ); 
            sb.Append( " ], " ); 
        } 
        sb.Remove(sb.Length  -   1 ,  1 ); 
        sb.Append( " ] " ); 
         return  sb.ToString(); 
    } 

<!--<br /> <br /> Code highlighting produced by Actipro CodeHighlighter (freeware)<br /> http://www.CodeHighlighter.com/<br /> <br /> --> ///   <summary>  
     ///  反回JSON数据到前台 
     ///   </summary>  
     ///   <param name="dt"> 数据表 </param>  
     ///   <returns> JSON字符串 </returns>  
     public   string  CreateJsonParameters(DataTable dt) 
    { 
        StringBuilder JsonString  =   new  StringBuilder(); 
         // Exception Handling         
         if  (dt  !=   null   &&  dt.Rows.Count  >   0 ) 
        { 
            JsonString.Append( " {  " ); 
            JsonString.Append( " \ " TableInfo\ " :[  " ); 
             for  ( int  i  =   0 ; i  <  dt.Rows.Count; i ++ ) 
            { 
                JsonString.Append( " {  " ); 
                 for  ( int  j  =   0 ; j  <  dt.Columns.Count; j ++ ) 
                { 
                     if  (j  <  dt.Columns.Count  -   1 ) 
                    { 
                        JsonString.Append( " \ ""  + dt.Columns[j].ColumnName.ToString() +  " \ " : "   +   " \ ""  + dt.Rows[j].ToString() +  " \ " , " ); 
                    } 
                     else   if  (j  ==  dt.Columns.Count  -   1 ) 
                    { 
                        JsonString.Append( " \ ""  + dt.Columns[j].ColumnName.ToString() +  " \ " : "   +   " \ ""  + dt.Rows[j].ToString() +  " \ "" ); 
                    } 
                } 
                 /**/  
                 /* end Of String */  
                 if  (i  ==  dt.Rows.Count  -   1 ) 
                { 
                    JsonString.Append( " }  " ); 
                } 
                 else  
                { 
                    JsonString.Append( " },  " ); 
                } 
            } 
            JsonString.Append( " ]} " ); 
             return  JsonString.ToString(); 
        } 
         else  
        { 
             return   null ; 
        } 
    } 

<!--<br /><br />Code highlighting produced by Actipro CodeHighlighter (freeware)<br />http://www.CodeHighlighter.com/<br /><br />--> /**/ /// <summary> 
    ///JsonHelp 的摘要说明 
    /// </summary> 
     public   static   class  JsonHelp 
     { 
        /**//// <summary> 
        /// 返回对象序列化 
        /// </summary> 
        /// <param name="obj">源对象</param> 
        /// <returns>json数据</returns> 
        public static string ToJson(this object obj) 
        { 
            JavaScriptSerializer serialize = new JavaScriptSerializer(); 
            return serialize.Serialize(obj); 
        } 
        /**//// <summary> 
        /// 控制深度 
        /// </summary> 
        /// <param name="obj">源对象</param> 
        /// <param name="recursionDepth">深度</param> 
        /// <returns>json数据</returns> 
        public static string ToJson(this object obj, int recursionDepth) 
        { 
            JavaScriptSerializer serialize = new JavaScriptSerializer(); 
            serialize.RecursionLimit = recursionDepth; 
            return serialize.Serialize(obj); 
        } 
        /**//// <summary> 
        /// DataTable转为json 
        /// </summary> 
        /// <param name="dt">DataTable</param> 
        /// <returns>json数据</returns> 
        public static string ToJson(DataTable dt) 
        { 
            Dictionary<string, object> dic = new Dictionary<string, object>(); 
            int index = 0; 
            foreach (DataRow dr in dt.Rows) 
            { 
                Dictionary<string, object> result = new Dictionary<string, object>(); 
                foreach (DataColumn dc in dt.Columns) 
                { 
                    result.Add(dc.ColumnName, dr[dc].ToString()); 
                } 
                dic.Add(index.ToString(), result); 
                index++; 
            } 
            return dic.ToJson(); 
        } 
    }