c# datatable 转 json

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Web.Script.Serialization;
using System.Collections;

namespace WindowsFormsApplication10
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //zkhisEntities db = new zkhisEntities();
            //List<doctor> list=  db.doctor.Where(u => true).ToList();
            //JavaScriptSerializer jss = new JavaScriptSerializer();
            // MessageBox.Show( jss.Serialize(list));
            DataTable dt = new DataTable();
            dt.Columns.Add("id", System.Type.GetType("System.Int32"));
            dt.Columns.Add("zwj");
            dt.Columns.Add("zsf");

            for (int i = 0; i < 10; i++)
            {

                DataRow dr = dt.NewRow();
                dr[0] = 1;

                dr[1] = "ddd";
                dr[2] = "ddd";
                dt.Rows.Add(dr);
                dt.Rows.Add(i, "ddd", "ddd");
            }
            MessageBox.Show(converJson(dt));


        }

        string converJson(DataTable dt)
        {


            ArrayList list = new ArrayList();

            JavaScriptSerializer js = new JavaScriptSerializer();
            foreach (DataRow item in dt.Rows)
            {

                Dictionary<String, Object> drow = new Dictionary<string, object>();
                foreach (DataColumn col in dt.Columns)
                {
                    drow.Add(col.ColumnName, item[col.ColumnName]);
                }
                list.Add(drow);
            }




            return js.Serialize(list);
        }



    }
}

 

posted @ 2016-11-09 16:45  刀小爱  阅读(150)  评论(0)    收藏  举报