使用访问数据库程序.pdf

///summary

///用于Northwind数据库中Employee表的数据适配器

////summary

privateSqlDataAdapterdaEmployees;

///summary

///包含Northwind数据库中的表的数据集对象

////summary

privateDataSetdsNorthwind;

///summary

///与Employees表相关联的绑定管理器

////summary

privateCurrencyManagercm;

///summary

///创建数据适配器对象

////summary

privatevoidCreateDataAdapter()

{

daEmployees=newSqlDataAdapter();

SqlConnectionconn=newSqlConnection(datasource=SUN;

+initialcatalog=Northwind;+

integratedsecurity=SSPI;+

persistsecurityinfo=True;+

workstationid=SUN;+

packetsize=4096);

//设置数据适配器的选择命令

daEmployees.SelectCommand=

newSqlCommand(SELECT*FROMEmployees,conn);

//为数据适配器创建表映射

daEmployees.TableMappings.AddRange(newDataTableMapping[]

{

newDataTableMapping(Table,Employees,

newDataColumnMapping[]{

newDataColumnMapping(EmployeeID,EmployeeID),

newDataColumnMapping(LastName,LastName),

newDataColumnMapping(FirstName,FirstName),

newDataColumnMapping(Title,Title),

newDataColumnMapping(TitleOfCourtesy,TitleOf

Courtesy),

newDataColumnMapping(BirthDate,BirthDate),

newDataColumnMapping(HireDate,HireDate),

newDataColumnMapping(Address,Address),

newDataColumnMapping(City,City),