读取数据库表中数据并将数据转化成json格式输出 在线等候啊

Question

比如数据库中的表：text
字段： name  sex  age
       张山   男   21
               .
               .等很多这样的数据 现在要读取这些数据并将数据转化成json格式输出   不懂json格式  高手们可以给个详细点的例子给我吗？在线等候啊！

Answer 1

如果返回DataTable 示例DataTable转Json方法

Answer 2

今天刚做了个，给你参考下
  StringBuilder sb = new StringBuilder();
        string sql = "select * from users";
        DataTable dt = DbHelperSQL.Query(sql).Tables[0];
        sb.Append("{data:[");
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            sb.Append("{\"id\":\"" + dt.Rows[i]["id"].ToString() + "\",\"name\":\"" + dt.Rows[i]["name"].ToString() + "\",\"tel\":\"" + dt.Rows[i]["tel"].ToString() + "\",\"mail\":\"" + dt.Rows[i]["mail"].ToString() + "\",\"qq\":\"" + dt.Rows[i]["qq"].ToString() + "\",\"datetime\":\"" + dt.Rows[i]["addtime"].ToString() + "\"}");
            if (i != dt.Rows.Count - 1)
            {
                sb.Append(",");
            }
        }
        sb.Append("]}");
        Response.Write(sb.ToString());
这是输出了json格式数据
{data:[{"id":"15","name":"admin","tel":"13544332232","mail":"[email protected]","qq":"654322221","datetime":"2012/8/31 16:13:49"},{"id":"16","name":"admin1","tel":"13544332232","mail":"[email protected]","qq":"654322221","datetime":"2012/8/31 16:13:49"},{"id":"17","name":"admin2","tel":"13544332232","mail":"[email protected]","qq":"654322221","datetime":"2012/8/31 16:13:49"},{"id":"18","name":"admin3","tel":"13544332232","mail":"[email protected]","qq":"654322221","datetime":"2012/8/31 16:13:49"},{"id":"19","name":"admin4","tel":"13544332232","mail":"[email protected]","qq":"654322221","datetime":"2012/8/31 16:13:49"},{"id":"20","name":"admin5","tel":"13544332232","mail":"[email protected]","qq":"654322221","datetime":"2012/8/31 16:13:49"},{"id":"21","name":"admin6","tel":"13544332232","mail":"[email protected]","qq":"654322221","datetime":"2012/8/31 16:13:49"},{"id":"22","name":"admin7","tel":"13544332232","mail":"[email protected]","qq":"654322221","datetime":"2012/8/31 16:13:49"},{"id":"23","name":"admin8","tel":"13544332232","mail":"[email protected]","qq":"654322221","datetime":"2012/8/31 16:13:49"},{"id":"24","name":"admin9","tel":"13544332232","mail":"[email protected]","qq":"654322221","datetime":"2012/8/31 16:13:49"},{"id":"25","name":"admin10","tel":"13544332232","mail":"[email protected]","qq":"654322221","datetime":"2012/8/31 16:13:49"},{"id":"26","name":"admin11","tel":"13544332232","mail":"[email protected]","qq":"654322221","datetime":"2012/8/31 16:13:49"},{"id":"27","name":"admin22","tel":"13544332232","mail":"[email protected]","qq":"654322221","datetime":"2012/8/31 16:13:49"},{"id":"28","name":"admin32","tel":"13544332232","mail":"[email protected]","qq":"654322221","datetime":"2012/8/31 16:13:49"},{"id":"29","name":"admin42","tel":"13544332232","mail":"[email protected]","qq":"654322221","datetime":"2012/8/31 16:13:49"},{"id":"30","name":"admin52","tel":"13544332232","mail":"[email protected]","qq":"654322221","datetime":"2012/8/31 16:13:49"},{"id":"31","name":"admin62","tel":"13544332232","mail":"[email protected]","qq":"654322221","datetime":"2012/8/31 16:13:49"},{"id":"32","name":"admin72","tel":"13544332232","mail":"[email protected]","qq":"654322221","datetime":"2012/8/31 16:13:49"},{"id":"33","name":"admin82","tel":"13544332232","mail":"[email protected]","qq":"654322221","datetime":"2012/8/31 16:13:49"},{"id":"34","name":"admin92","tel":"13544332232","mail":"[email protected]","qq":"654322221","datetime":"2012/8/31 16:13:49"}]}