怎样用c# ado.net 在内存中创建一个临时的Table

Question

怎样用c# ado.net 在内存中创建一个临时的Table

Answer 1

这还不简单
直接写个类继承自 datatable
然后 直接 add cloumn 就完事了

Answer 2

DataTable account = new DataTable("Account");
            DataTable datum = new DataTable("Datum");
            DataTable datumType = new DataTable("DatumType");            this.Tables.Add(account);
            this.Tables.Add(datum);
            this.Tables.Add(datumType);            account.Columns.Add(new DataColumn("AccountId", Type.GetType("System.String")));
            account.Columns.Add(new DataColumn("AccountName", Type.GetType("System.String")));
            account.Columns.Add(new DataColumn("Password", Type.GetType("System.String")));
            account.Columns.Add(new DataColumn("Department", Type.GetType("System.String")));
            account.Columns.Add(new DataColumn("M_Name", Type.GetType("System.String")));            datum.Columns.Add(new DataColumn("DatumId", Type.GetType("System.String")));
            datum.Columns.Add(new DataColumn("DatumName", Type.GetType("System.String")));
            datum.Columns.Add(new DataColumn("DatumType", Type.GetType("System.Char")));
            datum.Columns.Add(new DataColumn("Path", Type.GetType("System.String")));            datumType.Columns.Add(new DataColumn("TypeId", Type.GetType("System.String")));
            datumType.Columns.Add(new DataColumn("TypePath", Type.GetType("System.String")));
            datumType.Columns.Add(new DataColumn("TypeName", Type.GetType("System.String")));
            datumType.Columns.Add(new DataColumn("ParentId", Type.GetType("System.String")));

Answer 3

new table()
用完自己dispose

Answer 4

晕，楼主是要建TABLE还是DataTable，用ADO应该是DataTable吧

Answer 5

ADO.NET 中应该是Datatable吧。直接new一个就可以啦！用完就dispose就行了。

Answer 6

DataTable account = new DataTable("Account");
DataTable datum = new DataTable("Datum");
DataTable datumType = new DataTable("DatumType");
怎样把这３张表合并成一张表呢？
==============
Account
Datum
DatumType
这３张表是sql server里面建的３张表吗？
==============

Answer 7

DataTable account = new DataTable("Account");
            DataTable datum = new DataTable("Datum");
            DataTable datumType = new DataTable("DatumType");            this.Tables.Add(account);
            this.Tables.Add(datum);
            this.Tables.Add(datumType);            account.Columns.Add(new DataColumn("AccountId", Type.GetType("System.String")));
            account.Columns.Add(new DataColumn("AccountName", Type.GetType("System.String")));
            account.Columns.Add(new DataColumn("Password", Type.GetType("System.String")));
            account.Columns.Add(new DataColumn("Department", Type.GetType("System.String")));
            account.Columns.Add(new DataColumn("M_Name", Type.GetType("System.String")));            datum.Columns.Add(new DataColumn("DatumId", Type.GetType("System.String")));
            datum.Columns.Add(new DataColumn("DatumName", Type.GetType("System.String")));
            datum.Columns.Add(new DataColumn("DatumType", Type.GetType("System.Char")));
            datum.Columns.Add(new DataColumn("Path", Type.GetType("System.String")));            datumType.Columns.Add(new DataColumn("TypeId", Type.GetType("System.String")));
            datumType.Columns.Add(new DataColumn("TypePath", Type.GetType("System.String")));
            datumType.Columns.Add(new DataColumn("TypeName", Type.GetType("System.String")));
            datumType.Columns.Add(new DataColumn("ParentId", Type.GetType("System.String")));
========================================================
怎样给表中的每个列中添加数据呢？

Answer 8

1.添加数据: DataRow row = table[x].NewRow(); row[x] = x;把数据填完,然后table[x].Rows.Add(row);2.合并表.这几个表的columns完全不一样,不知道你所谓的"合并"是什么意思.如果列一样的话可以直接table[0].Rows.AddRange(table[1].Rows);

Answer 9

我的DataTable的Rows里面怎么没有AddRange函数，只有add函数