DataTable 创建

最新推荐文章于 2023-10-23 10:32:58 发布

aowuaowuwuwu

最新推荐文章于 2023-10-23 10:32:58 发布

阅读量106

点赞数

分类专栏： C#

本文链接：https://blog.csdn.net/shabihundan/article/details/108301264

版权

C# 专栏收录该内容

20 篇文章 0 订阅

订阅专栏

记录下new一个Table

private DataTable CreateTreeListTable()
        {
            DataTable dt = new DataTable();

            DataColumn dcOID = new DataColumn("KeyFieldName", Type.GetType("System.Int32"));
            DataColumn dcParentOID = new DataColumn("ParentFieldName", Type.GetType("System.Int32"));
            DataColumn dcNodeName = new DataColumn("NodeName", Type.GetType("System.String"));
            DataColumn dcNodeCode = new DataColumn("NodeCode", Type.GetType("System.String"));
            DataColumn dcOthers = new DataColumn("Others", Type.GetType("System.String"));

            dt.Columns.Add(dcOID);
            dt.Columns.Add(dcParentOID);
            dt.Columns.Add(dcNodeName);
            dt.Columns.Add(dcNodeCode);
            dt.Columns.Add(dcOthers);

            //以上代码完成了DataTable的构架，但是里面是没有任何数据的
            DataRow dr1 = dt.NewRow();
            dr1["KeyFieldName"] = 1;
            dr1["ParentFieldName"] = DBNull.Value;
            dr1["NodeName"] = "根节点名称";
            dr1["NodeCode"] = "根节点编码";
            dr1["Others"] = "其他";
            dt.Rows.Add(dr1);
            DataRow dr2 = dt.NewRow();
            dr2["KeyFieldName"] = 2;
            dr2["ParentFieldName"] = 1;
            dr2["NodeName"] = "节点子节点名称";
            dr2["NodeCode"] = "节点子节点编码";
            dr2["Others"] = "其他";
            dt.Rows.Add(dr2);
            DataRow dr3 = dt.NewRow();
            dr3["KeyFieldName"] = 3;
            dr3["ParentFieldName"] = 1;
            dr3["NodeName"] = "节点子节点名称";
            dr3["NodeCode"] = "节点子节点编码";
            dr3["Others"] = "其他";
            dt.Rows.Add(dr3);
            DataRow dr4 = dt.NewRow();
            dr4["KeyFieldName"] = 4;
            dr4["ParentFieldName"] = DBNull.Value;
            dr4["NodeName"] = "根节点名称";
            dr4["NodeCode"] = "根节点编码";
            dr4["Others"] = "其他";
            dt.Rows.Add(dr4);
            DataRow dr5 = dt.NewRow();
            dr5["KeyFieldName"] = 5;
            dr5["ParentFieldName"] = 4;
            dr5["NodeName"] = "节点子节点名称";
            dr5["NodeCode"] = "节点子节点编码";
            dr5["Others"] = "其他";
            dt.Rows.Add(dr5);
            DataRow dr6 = dt.NewRow();
            dr6["KeyFieldName"] = 6;
            dr6["ParentFieldName"] = 5;
            dr6["NodeName"] = "节点子节点名称";
            dr6["NodeCode"] = "节点子节点编码";
            dr6["Others"] = "其他";
            dt.Rows.Add(dr6);
            return dt;
        }