手动创建DataTable

最新推荐文章于 2022-03-13 13:32:10 发布

anmu1361

最新推荐文章于 2022-03-13 13:32:10 发布

阅读量121

点赞数

原文链接：http://www.cnblogs.com/px7034/archive/2010/09/10/1823321.html

版权

public void createTable()
    {
        DataSet ds = new DataSet();
        using (DataTable dt = new DataTable("students"))
        {
            //创建列
            DataColumn dtc = new DataColumn("姓名",typeof(string));
            dt.Columns.Add(dtc);

dtc = new DataColumn("性别",typeof(string));
dt.Columns.Add(dtc);

dtc = new DataColumn("电话",typeof(Int32));
dt.Columns.Add(dtc);

            //添加数据到DataTable
            DataRow dr = dt.NewRow();
            dr["姓名"] = "张三";
            dr["性别"] = "男";
            dr["电话"] = 54531;
            dt.Rows.Add(dr);

            dr = dt.NewRow();

            dr["姓名"] = "李四";
            dr["性别"] = "男";
            dr["电话"] = 5731;
            dt.Rows.Add(dr);

            dr = dt.NewRow();

            dr["姓名"] = "王五";
            dr["电话"] = 5868451;
            dr["性别"] = "女";
            dt.Rows.Add(dr);
            ds.Tables.Add(dt);
        }
    }

转载于:https://www.cnblogs.com/px7034/archive/2010/09/10/1823321.html