SqlDataAdapter具體用法和意義？數(shù)據(jù)集函數(shù)：數(shù)據(jù)集，數(shù)據(jù)適配器讀取數(shù)據(jù)。問：什么是數(shù)據(jù)適配器？答：DataAdapter對象充當(dāng)數(shù)據(jù)集和數(shù)據(jù)字符串strconn=“uid=account

SqlDataAdapter具體用法和意義？

數(shù)據(jù)集函數(shù)：數(shù)據(jù)集，數(shù)據(jù)適配器讀取數(shù)據(jù)。問：什么是數(shù)據(jù)適配器？答：DataAdapter對象充當(dāng)數(shù)據(jù)集和數(shù)據(jù)字符串strconn=“uid=account PWD=password database=database server=server”//SQL server鏈接字符串SqlConnection connsql=new SqlConnection（strconn）//SQL鏈接類的實(shí)例化之間的橋梁連接SQL。打開（）//打開數(shù)據(jù)庫字符串strSql=“select*from tablename1”“//要執(zhí)行的SQL語句SqlDataAdapter Da=new SqlDataAdapter（strSql，connssql）//create DataAdapter instance dataset DS=new dataset（）//create dataset instanceda.填充（DS，“custom virtual table name”//使用DataAdapter的fill方法調(diào)用select命令連接SQL。關(guān)閉（）//關(guān)閉數(shù)據(jù)庫