DataTable转换成JSON字符串的函数

     private string DataTable2Json(DataTable dt)
     ... {
         StringBuilder jsonBuilder = new StringBuilder();
         jsonBuilder.Append( " {/" " );
         jsonBuilder.Append(dt.TableName);
         jsonBuilder.Append( "/ ":[ " );
        for ( int i = 0 ; i < dt.Rows.Count; i ++ )
         ... {
             jsonBuilder.Append( " { " );
            for ( int j = 0 ; j < dt.Columns.Count; j ++ )
             ... {
                 jsonBuilder.Append( "/ " " );
                 jsonBuilder.Append(dt.Columns[j].ColumnName);
                 jsonBuilder.Append( "/ ":/" " );
                 jsonBuilder.Append(dt.Rows[i][j].ToString());
                 jsonBuilder.Append( "/ ", " );
             }
             jsonBuilder.Remove(jsonBuilder.Length - 1 , 1 );
             jsonBuilder.Append( " }, " );
         }
         jsonBuilder.Remove(jsonBuilder.Length - 1 , 1 );
         jsonBuilder.Append( " ] " );
         jsonBuilder.Append( " } " );
        return jsonBuilder.ToString();
     }

这一行“jsonBuilder.Remove(jsonBuilder.Length - 1, 1);”是为了去掉最后一个多于的逗号，当然这个函数不能操作比较包含复杂数据类型的DataTable，不过对于现在的工作已经够用了。