DataTable或Ilist转换 JSON格式

using System;

using System.Data;

using System.Text;

using System.Collections.Generic;

using System.Reflection;

/// <summary>

/// 将DataTable或Ilist<>转换成JSON格式

/// </summary>

public class ToJson

{

public ToJson()

{

}

//DataTable转成Json

public static string DataTableToJson( string jsonName, DataTable dt)

{

StringBuilder Json = new StringBuilder();

Json.Append( "{\"" + jsonName + "\":[" );

if (dt.Rows.Count > 0)

{

for ( int i = 0; i < dt.Rows.Count; i++)

{

Json.Append( "{" );

for ( int j = 0; j < dt.Columns.Count; j++)

{

Json.Append( "\"" + dt.Columns[j].ColumnName.ToString() + "\":\"" + dt.Rows[i][j].ToString() + "\"" );

if (j < dt.Columns.Count - 1)

{

Json.Append( "," );

}

}

Json.Append( "}" );

if (i < dt.Rows.Count - 1)

{

Json.Append( "," );

}

}

}

Json.Append( "]}" );

return Json.ToString();

}

//List转成json

public static string ObjectToJson<T>( string jsonName, IList<T> IL)

{

StringBuilder Json = new StringBuilder();

Json.Append( "{\"" + jsonName + "\":[" );

if (IL.Count > 0)

{

for ( int i = 0; i < IL.Count; i++)

{

T obj = Activator.CreateInstance<T>();

Type type = obj.GetType();

PropertyInfo[] pis = type.GetProperties();

Json.Append( "{" );

for ( int j = 0; j < pis.Length; j++)

{

Json.Append( "\"" + pis[j].Name.ToString() + "\":\"" + pis[j].GetValue(IL[i], null ) + "\"" );

if (j < pis.Length - 1)

{

Json.Append( "," );

}

}

Json.Append( "}" );

if (i < IL.Count - 1)

{

Json.Append( "," );

}

}

}

Json.Append( "]}" );

return Json.ToString();

}

}