简述DbDataAdapter.Update 方法(续)

附 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)

Published At
Categories with Web编程
Tagged with
comments powered by Disqus