ASP读取SQL数据表 生成多记录JSON 具体代码如何写 求教大神

数据表是user 主键是m_Name

 <%
response.ContentType="text/json" 
response.write request("jsoncallback")%>
([{"m_Name":"*依旧","n_Name":"汉子","IsGuard":false},{"m_Name":"*壹壹","n_Name":"女子","IsGuard":false}])

 循环拼接字符串，比如
(<%
for i = 1 to 10
%>
[{"m_Name":"*依旧","n_Name":"汉子","IsGuard":false},{"m_Name":"*壹壹","n_Name":"女子","IsGuard":false}]
<%
next
%>)
这样输出10条

去对象，放到list集合，
1. list list=new list();
list=//从数据库查出来
2. 序列化list 集合 转换JSON 字符串
2.JSON.Parse(json);

//例子是对DataTable 进行JSON 转换

    /// <summary>
    /// 
    /// <summary>
    /// DDataTable 转 JSon
    /// </summary>
    /// <param name="dt"></param>
    /// <returns></returns>
    public static string ToJson(DataTable dt)
    {
        List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
        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]);
            }
            list.Add(result);
        }

        return SerializeToJson(list);
    }