OleDbDataAdapter Constructor ( )

System.Data.OleDb Namespace OleDbDataAdapter Class

Initializes a new instance of the OleDbDataAdapter class.

[ VB ]
Overloads Public Sub New ( )

[ C# ]
public OleDbDataAdapter ( );

[ C++ ]
public: OleDbDataAdapter ( );

[ JScript ]
public function OleDbDataAdapter ( );

When an instance of OleDbDataAdapter is created, the following read/write properties are set to initial values.

Properties	Initial Value
MissingMappingAction	MissingMappingAction.Passthrough
MissingSchemaAction	MissingSchemaAction.Add

You can change the value of any of these properties through a separate call to the property.

The following example initializes an OleDbDataAdapter using this constructor, then sets some of its properties.

// set up the connection
OleDbConnection myConn = new OleDbConnection (
   "Provider=Microsoft.Jet.OleDb.4.0; Data Source=" + 
   Server.MapPath ( "~/app_data/dbtutor.mdb" ) );

// set up the dataadapter
OleDbDataAdapter myAdapter = new OleDbDataAdapter ( );
myAdapter.SelectCommand.CommandText = "SELECT * FROM Products";
myAdapter.SelectCommand.Connection = myConn;

' set up the connection
dim myConn as new OleDbConnection (
   "Provider=Microsoft.Jet.OleDb.4.0; Data Source=" + 
   Server.MapPath ( "~/app_data/dbtutor.mdb" ) );

' set up the dataadapter
dim myAdapter as new OleDbDataAdapter ( )
myAdapter.SelectCommand.CommandText = "SELECT * FROM Products"
myAdapter.SelectCommand.Connection = myConn

OleDbDataAdapter Members OleDbDataAdapter Constructor Overload List MissingMappingAction MissingSchemaAction

Home Getting Started Web Forms Web Applications ADO.NET ASP/ADO Back to Basics

OleDbDataAdapter Constructor ( )

Remarks

Example

See Also