C#数据之DataTable

时间：2025-03-08 18:02:50

C#创建DataTable的几种方式

第一种方式：直接添加数据对象

            DataTable table = new DataTable();

            table.Columns.Add("strName", Type.GetType("System.String"));

            table.Columns.Add("strSex", Type.GetType("System.String"));

            table.Columns.Add("strEmail", Type.GetType("System.String"));

            table.Rows.Add(new object[] { "Tom", "男", "Tom@atguigu.com" });

            table.Rows.Add(new object[] { "Lucy", "女", "Lucy@atguigu.com" });

            table.Rows.Add(new object[] { "Jack", "男", "Jack@atguigu.com" });

第二种方式：用DataColumn无参构造方法创建列，然后New每行列的数据  

　　　　　　  DataTable table = new DataTable();

            DataColumn strNameColumn = new DataColumn();//创建table的第一列

            strNameColumn.DataType = System.Type.GetType("System.String");//该列的数据类型

            strNameColumn.ColumnName = "strName";//该列得名称

            DataColumn strSexColumn = new DataColumn();

            strSexColumn.DataType = System.Type.GetType("System.String");

            strSexColumn.ColumnName = "strSex";

            DataColumn strEmailColumn = new DataColumn();

            strEmailColumn.DataType = System.Type.GetType("System.String");

            strEmailColumn.ColumnName = "strEmail";

            // 将所有的列添加到table上

            table.Columns.Add(strNameColumn);

            table.Columns.Add(strSexColumn);

            table.Columns.Add(strEmailColumn);

            //添加数据

            DataRow rowData = table.NewRow();

            rowData["strName"] = "Tom";

            rowData["strSex"] = "男";

            rowData["strEmail"] = "Tom@atguigu.com";

            table.Rows.Add(rowData);

            rowData = table.NewRow();

            rowData["strName"] = "Lucy";

            rowData["strSex"] = "女";

            rowData["strEmail"] = "Lucy@atguigu.com";

            table.Rows.Add(rowData);

            rowData = table.NewRow();

            rowData["strName"] = "Jack";

            rowData["strSex"] = "男";

            rowData["strEmail"] = "Jack@atguigu.com";

            table.Rows.Add(rowData);

第三种方式：用DataColumn有参构造方法创建列

            DataTable dt = new DataTable();

            DataColumn dc1 = new DataColumn("strName", Type.GetType("System.String"));

            DataColumn dc2 = new DataColumn("strSex", Type.GetType("System.String"));

            DataColumn dc3 = new DataColumn("strEmail", Type.GetType("System.String"));

            dt.Columns.Add(dc1);

            dt.Columns.Add(dc2);

            dt.Columns.Add(dc3);

            //添加三条数据　　　　

            DataRow row = dt.NewRow();

            row["strName"] = "Tom";

            row["strSex"] = "男";

            row["strEmail"] = "Tom@atguigu.com";

            dt.Rows.Add(row);

            row = dt.NewRow();

            row["strName"] = "Lucy";

            row["strSex"] = "女";

            row["strEmail"] = "Lucy@atguigu.com";

            dt.Rows.Add(row);

            row = dt.NewRow();

            row["strName"] = "Jack";

            row["strSex"] = "男";

            row["strEmail"] = "Jack@atguigu.com";

            dt.Rows.Add(row);

相关文章