DataTable手动建立

来源:互联网 发布:采集文章的软件 编辑:程序博客网 时间:2024/06/11 15:12

DataTable表结构新增:

DataTable dt = new DataTable();                dt.Columns.AddRange(new DataColumn[] {                     new DataColumn("modelid", typeof(int)),                    new DataColumn("modelkey", typeof(string)),                    new DataColumn("modelcnname", typeof(string)),                    new DataColumn("menulevel", typeof(int)),                    new DataColumn("fatherid", typeof(int)),                    new DataColumn("defv", typeof(string)),                    new DataColumn("defo", typeof(string)),                    new DataColumn("modelsort", typeof(int))                });

DataTable表数据新增:

DataRow dr = dt.NewRow();                dr[0] = 1;                dr[1] = "m_butcher";                dr[2] = "屠宰管理(&A)";                dr[3] = 1;                dr[4] = -1;                dr[5] = "";                dr[6] = "";                dr[7] = 1;                dt.Rows.Add(dr);


0 0