EXT如果大家不了解可以去http://www.extjs.com,    http://www.dojochina.com去补课,这里看下如何直接从表中的数据得到Json以提供给EXT调用,或者可以绑定到我们自己写的EXT控件上,如果使用.net framework3.5中的ToJSON方法结合LINQ有更好的实现:

using System.Data;
using System.Text;

namespace Netgod.EasyExt.ExtData
{
    public class JsonSerializer
    {
        public static string Serialize(DataTable table)
        {
            StringBuilder json = new StringBuilder();
            json.Append("[");
            for (int i = 0; i < table.Rows.Count; i++)
            {
                DataRow row = table.Rows[i];
                json.Append("{");
                for (int j = 0; j < table.Columns.Count; j++)
                {
                    string columnName = table.Columns[j].ColumnName;
                    string columnType = table.Columns[j].DataType.Name;
                    if (columnType == "Int32" || columnType == "Int16" || columnType == "Decimal")
                    {
                        json.AppendFormat("\"{0}\":\"{1}\"", columnName, row.IsNull(columnName) ? "" : row[columnName]);
                    }
                    else if (columnType == "Boolean")
                    {
                        json.AppendFormat("\"{0}\":{1}", columnName, row.IsNull(columnName) ? "" : row[columnName].ToString().ToLower());
                    }
                    else
                    {
                        json.AppendFormat("\"{0}\":\"{1}\"", columnName, row[columnName]);
                    }

                    if (j < table.Columns.Count - 1) json.Append(","); 
                }
                json.Append("}");

                if (i < table.Rows.Count - 1) json.Append(","); 
            }
            json.Append("]");
            return json.ToString();
        }
    }
}