DbDataAdapter.Update Method

asp.net.ph

System.Data.Common Namespace DbDataAdapter Class

Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the DataSet.

1. Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified array of DataRow objects.

[ VB ] Overloads Public Function Update ( DataRow ( ) ) As Integer

[ C# ] public int Update ( DataRow [ ] );

[ C++ ] public: int Update ( DataRow* [ ] );

[ JScript ] public function Update ( DataRow [ ] ) : int;

2. Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified DataSet.

[ VB ] Overloads Overrides Public Function Update ( DataSet ) As Integer

[ C# ] public override int Update ( DataSet );

[ C++ ] public: int Update ( DataSet* );

[ JScript ] public override function Update ( DataSet ) : int;

3. Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified DataTable.

[ VB ] Overloads Public Function Update ( DataTable ) As Integer

[ C# ] public int Update ( DataTable );

[ C++ ] public: int Update ( DataTable* );

[ JScript ] public function Update ( DataTable ) : int;

4. Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified array of DataRow objects.

[ VB ] Overloads Overridable Protected Function Update ( DataRow ( ), DataTableMapping ) As Integer

[ C# ] protected virtual int Update ( DataRow [ ], DataTableMapping );

[ C++ ] protected: virtual int Update ( DataRow* [ ], DataTableMapping* );

[ JScript ] protected function Update ( DataRow [ ], DataTableMapping ) : int;

5. Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the DataSet with the specified DataTable name.

[ VB ] Overloads Public Function Update ( DataSet, String ) As Integer

[ C# ] public int Update ( DataSet, string );

[ C++ ] public: int Update ( DataSet*, String* );

[ JScript ] public function Update ( DataSet, String ) : int;

NOTE:This example uses one of the overloaded versions of Update. For other examples that may be available, see the individual overload topics.

public DataSet UpdateDemo ( DataSet myDataSet, string connString, 
      string strQuery, string myTableName ) {

   OleDbConnection myConn = new OleDbConnection ( connString );
   OleDbDataAdapter myAdapter = new OleDbDataAdapter ( );
   myAdapter.SelectCommand = new OleDbCommand ( strQuery, myConn );
   OleDbCommandBuilder custCB = new OleDbCommandBuilder ( myAdapter );

   myConn.Open ( );
   DataSet myDataSet = new DataSet ( );
   myAdapter.Fill ( myDataSet );

   // ... code to modify data in DataSet here ...

   // without the OleDbCommandBuilder this line would fail
   myAdapter.Update ( myDataSet,"Categories" );

   myConn.Close ( );
   return myDataSet;
}

Public Function UpdateDemo ( myDataSet As DataSet, 
      connString As String, strQuery As String, myTableName As String )
      As DataSet
   Dim myConn As New OleDbConnection ( connString )
   Dim myAdapter As New OleDbDataAdapter ( )
   myAdapter.SelectCommand = New OleDbCommand ( strQuery, myConn )
   Dim custCB As OleDbCommandBuilder = New OleDbCommandBuilder ( myAdapter )

   myConn.Open ( )
   Dim myDataSet As DataSet = New DataSet
   myAdapter.Fill ( myDataSet )

   ' ... code to modify data in DataSet here ...

   ' Without the OleDbCommandBuilder this line would fail.
   myAdapter.Update ( myDataSet,"Categories" )

   myConn.Close ( )
   Return myDataSet
End Function

C#

VB

DbDataAdapter Members

Suggested Reading

© 2000-2010 Rey Nuñez All rights reserved.

If you have any question, comment or suggestion
about this site, please send us a note

You can help support asp.net.ph