附 DbDataAdapter.Update 方法的所有重载版本
n Overloads Public Function Update(ByVal dataRows () As DataRow ) As Integer
n Overrides Overloads Public Function Update(ByVal dataSet As DataSet ) As Integer Implements IDataAdapter.Update
n Overloads Public Function Update(ByVal dataTable As DataTable ) As Integer
n Overloads Protected Overridable Function Update(ByVal dataRows () As DataRow ,ByVal tableMapping As DataTableMapping ) As Integer
n Overloads Public Function Update(ByVal dataSet As DataSet ,ByVal srcTable As String ) As Integer
示例
Public Function CreateCmdsAndUpdate(myDataSet As DataSet, myConnection As String, mySelectQuery As String, myTableName As String) As DataSet
Dim myConn As New OleDbConnection(myConnection)
Dim myDataAdapter As New OleDbDataAdapter()
myDataAdapter.SelectCommand = New OleDbCommand(mySelectQuery, myConn)
Dim custCB As OleDbCommandBuilder = New OleDbCommandBuilder(MyDataAdapter)
myConn.Open()
Dim custDS As DataSet = New DataSet
myDataAdapter.Fill(custDS)
' Code to modify data in DataSet here
myDataAdapter.Update(custDS)
' Code to modify data in DataSet here
myDataAdapter.Update(custDS, myTableName)
' Insert new records from DataSet
Dim myDataRowArray() As DataRow = custDS.Tables(0).Select(Nothing, Nothing, DataViewRowState.Added)
myDataAdapter.Update(myDataRowArray)
Dim custDT As DataTable = New DataTable
myDataAdapter.Fill(custDT)
' Code to modify data in DataTable here
myDataAdapter.Update(custDT)
myConn.Close()
Return custDS
End Function 'SelectOleDbSrvRows
附 DbDataAdapter. Fill 方法的所有重载版本
n Overloads Public Function Fill(ByVal dataTable As DataTable , ByVal ADODBRecordSet As Object ) As Integer
n Overloads Public Function Fill(ByVal dataSet As DataSet ,ByVal ADODBRecordSet As Object ,ByVal srcTable As String ) As Integer
n Overrides Overloads Public Function Fill(ByVal dataSet As DataSet ) As Integer Implements IDataAdapter.Fill
n Overloads Public Function Fill(ByVal dataTable As DataTable ) As Integer
n Overloads Public Function Fill(ByVal dataSet As DataSet ,ByVal srcTable As String ) As Integer
n Overloads Protected Overridable Function Fill(ByVal dataTable As DataTable ,ByVal dataReader As IDataReader ) As Integer
n Overloads Protected Overridable Function Fill(ByVal dataTable As DataTable ,ByVal command As IDbCommand ,ByVal behavior As CommandBehavior ) As Integer
n Overloads Public Function Fill(ByVal dataSet As DataSet ,ByVal startRecord As Integer ,ByVal maxRecords As Integer ,ByVal srcTable As String ) As Integer
n Overloads Protected Overridable Function Fill(ByVal dataSet As DataSet , ByVal srcTable As String ,ByVal dataReader As IDataReader ,ByVal startRecord As Integer ,ByVal maxRecords As Integer ) As Integer
n Overloads Protected Overridable Function Fill(ByVal dataSet As DataSet , ByVal startRecord As Integer ,ByVal maxRecords As Integer ,ByVal srcTable As String ,ByVal command As IDbCommand ,ByVal behavior As CommandBehavior ) As Integer
( 信息整理来自 MSDN)