在VB.net中使用SqlDataAdapter的多个表中插入数据

喜托尼，这是可能的。但是你要重新分配的选择，插入，更新和删除命令的数据适配器，每次代码应该是这样的东西codeprelang="vb"spanclass="code-keyword"Imports/spanSystem.Data.SqlClientspanclass="code-keyword"Public/spanspanclass="code-keyword"Class/spanForm1spanclass="code-keyword"Dim/spandsspanclass="code-keyword"As/spanDataSetspanclass="code-comment"'/spanspanclass="code-comment"whichcontainsyourtables./spanspanclass="code-keyword"Dim/spanadpspanclass="code-keyword"As/spanSqlDataAdapterspanclass="code-comment"'/spanspanclass="code-comment"createtheconnectionaccordingly/spanspanclass="code-keyword"Dim/spanconspanclass="code-keyword"As/spanSqlConnection spanclass="code-keyword"Private/spanspanclass="code-keyword"Sub/spanForm1_Load(spanclass="code-keyword"ByVal/spansenderspanclass="code-keyword"As/spanspanclass="code-keyword"Object/span,spanclass="code-keyword"ByVal/spanespanclass="code-keyword"As/spanSystem.EventArgs)spanclass="code-keyword"Handles/spanspanclass="code-keyword"Me/span.Loadspanclass="code-keyword"For/spanspanclass="code-keyword"Each/spantblspanclass="code-keyword"As/spanDataTablespanclass="code-keyword"In/spands.Tablesadp=spanclass="code-keyword"New/spanSqlDataAdapterspanclass="code-keyword"If/spantbl.TableName=spanclass="code-string""/spanspanclass="code-string"TransferMaster"/spanspanclass="code-keyword"Then/spanadp.SelectCommand=spanclass="code-keyword"New/spanSqlCommand(spanclass="code-string""/spanspanclass="code-string"yourselectcommand"/span,con)adp.InsertCommand=spanclass="code-keyword"New/spanSqlCommand(spanclass="code-string""/spanspanclass="code-string"Yourinsertcommand"/span,con)adp.UpdateCommand=spanclass="code-keyword"New/spanSqlCommand(spanclass="code-string""/spanspanclass="code-string"Yourupdatecommand"/span,con)adp.DeleteCommand=spanclass="code-keyword"New/spanSqlCommand(spanclass="code-string""/spanspanclass="code-string"Yourdeletecommand"/span,con)spanclass="code-keyword"ElseIf/spantbl.TableName=spanclass="code-string""/spanspanclass="code-string"TransferDetail"/spanspanclass="code-keyword"Then/spanadp.SelectCommand=spanclass="code-keyword"New/spanSqlCommand(spanclass="code-string""/spanspanclass="code-string"yourselectcommand"/span,con)adp.InsertCommand=spanclass="code-keyword"New/spanSqlCommand(spanclass="code-string""/spanspanclass="code-string"Yourinsertcommand"/span,con)adp.UpdateCommand=spanclass="code-keyword"New/spanSqlCommand(spanclass="code-string""/spanspanclass="code-string"Yourupdatecommand"/span,con)adp.DeleteCommand=spanclass="code-keyword"New/spanSqlCommand(spanclass="code-string""/spanspanclass="code-string"Yourdeletecommand"/span,con)spanclass="code-comment"'/spanspanclass="code-comment"esleif--continueasmanytablesyouhave/spanspanclass="code-keyword"End/spanspanclass="code-keyword"If/spanadp.Update(tbl)spanclass="code-keyword"Next/spanspanclass="code-keyword"End/spanspanclass="code-keyword"Sub/spanspanclass="code-keyword"End/spanspanclass="code-keyword"Class/span/pre/code
Jαved:喜托尼，
NBSP
我认为有可能。但ü甲肝打开和关闭连接每次
NBSP。
我不知道为什么你使用1 dataadpter的列印集。但它是良好的，使用多个查询多个数据集，n为dataadpter

嗨，
根据你的要求，应该也可以使用为UR SQL命令的交易，同时插入到多个表。下面是示例代码可能是有用的U

{C}
的问候，
santhosh库马尔G:Santhosh库马尔Gudise

Kiitos米卡！{S0的}