‘visual basic
dim da as sqldataadapter = new sqldataadapter(“select * from customers;select * from orders;”,myconnection)
dim ds as dataset = new dataset()
da.fill(ds,”customers”)
‘c#
sqldataadapter da = new sqldataadapter(“select * from customers;select * from orders;”,myconnection);
dataset ds = new dataset();
da.fill(ds,”customers”);
如上面代码所示，customers表数据将会存放在一个命名为customers的datatable中，而orders表数据将会放在一个命名为customers1的datatable中。当然你也可以在数据填充结束后很容易地修改customers1表属性（tablename）为orders。然而，在以后的数据填充时，只会影响customers表中数据，而orders表将会忽略并同时创建一个新的命名为customers1的表。要解决这个问题，你就要在customers1和orders之间建立一个datatablemapping映射。其他表也如此。举例说明：
‘visual basic
dim da as sqldataadapter = new sqldataadapter("select * from customers; select * from orders;", myconnection)
da.tablemappings.add("customers1", "orders")
dim ds as dataset = new dataset()
da.fill(ds, "customers")
‘c#
sqldataadapter da = new sqldataadapter("select * from customers; select * from orders;", myconnection);
da.tablemappings.add("customers1", "orders");
