关键字:TableMapping
DataTableMappingCollection
DataColumnMappingCollection
其中DataTableMappingCollection和DataColumnMappingCollection属于System.Data.Common命名空间.
TableMapping
.......................
OleDbDataAdapter da=new OleDbDataAdapter(strSql,strCon);
da.TableMappings.Add("Table","Customers");
....................
DataTableMappingCollection
DataTableMappingCollection mc=da.TableMappings;
mc.Add("Table","Customers");
mc.Add("Table1","Oders");
..............
DataColumnMappingCollection
DataColumnMappingCollection mc=da.TableMappings[0].ColumnMappings;
mc.Add("CustomerID","ID");
mc.Add("Phone","tel");
DataTableMappingCollection和DataColumnMappingCollection的AddRange方法提供添加多个项目;
DataColumnMappingCollection cm=da.TableMapping[0].ColumnMappings;
cm.AddRange(
new DataColumnMapping[ ]
{
new DataColumnMapping(),
new DataColumnMapping(),
........................
}
);