// Create the DataSet object
DataSet oDS = new DataSet();
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=orders.mdb");
conn.Open();// Create the DataTable "Orders" in the Dataset and the OrdersDataAdapter
OleDbDataAdapter oOrdersDataAdapter = new
OleDbDataAdapter(new OleDbCommand("SELECT * FROM Orders", conn));
OleDbCommandBuilder oOrdersCmdBuilder = new
OleDbCommandBuilder(oOrdersDataAdapter);
oOrdersDataAdapter.FillSchema(oDS, SchemaType.Source);DataTable pTable = oDS.Tables["Table"];
pTable.TableName = "Orders";// Create the DataTable "OrderDetails" in the Dataset
//and the OrderDetailsDataAdapter
OleDbDataAdapter oOrderDetailsDataAdapter = new
OleDbDataAdapter(new OleDbCommand("SELECT * FROM OrderDetails", conn));
OleDbCommandBuilder oOrderDetailsCmdBuilder = new
OleDbCommandBuilder(oOrderDetailsDataAdapter);
oOrderDetailsDataAdapter.FillSchema(oDS, SchemaType.Source);pTable = oDS.Tables["Table"];
pTable.TableName = "OrderDetails";
这个里面的pTable = oDS.Tables["Table"];
Table是什么意思?不会是表名吧?我怎么看着不像呢?
DataSet oDS = new DataSet();
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=orders.mdb");
conn.Open();// Create the DataTable "Orders" in the Dataset and the OrdersDataAdapter
OleDbDataAdapter oOrdersDataAdapter = new
OleDbDataAdapter(new OleDbCommand("SELECT * FROM Orders", conn));
OleDbCommandBuilder oOrdersCmdBuilder = new
OleDbCommandBuilder(oOrdersDataAdapter);
oOrdersDataAdapter.FillSchema(oDS, SchemaType.Source);DataTable pTable = oDS.Tables["Table"];
pTable.TableName = "Orders";// Create the DataTable "OrderDetails" in the Dataset
//and the OrderDetailsDataAdapter
OleDbDataAdapter oOrderDetailsDataAdapter = new
OleDbDataAdapter(new OleDbCommand("SELECT * FROM OrderDetails", conn));
OleDbCommandBuilder oOrderDetailsCmdBuilder = new
OleDbCommandBuilder(oOrderDetailsDataAdapter);
oOrderDetailsDataAdapter.FillSchema(oDS, SchemaType.Source);pTable = oDS.Tables["Table"];
pTable.TableName = "OrderDetails";
这个里面的pTable = oDS.Tables["Table"];
Table是什么意思?不会是表名吧?我怎么看着不像呢?
你可以创建一个表 DataTable table = new DataTable("Table");
ds.Tables.Add(table)
"Table"就是你创建的表的名字
pTable.TableName = "OrderDetails";"Table"如果是表的名字的话,那么"OrderDetails"是什么呢?"OrderDetails"是表的名字吧?
pTable.TableName = "OrderDetails";
这是将datatable的名字设置为orderdetails