SqlDataAdapter Constructor (String^, SqlConnection^)
Initializes a new instance of the SqlDataAdapter class with a SelectCommand and a SqlConnection object.
Assembly: System.Data (in System.Data.dll)
Parameters
- selectCommandText
-
Type:
System::String^
A String that is a Transact-SQL SELECT statement or stored procedure to be used by the SelectCommand property of the SqlDataAdapter.
- selectConnection
-
Type:
System.Data.SqlClient::SqlConnection^
A SqlConnection that represents the connection. If your connection string does not use Integrated Security = true, you can use SqlCredential to pass the user ID and password more securely than by specifying the user ID and password as text in the connection string.
This implementation of the SqlDataAdapter opens and closes a SqlConnection if it is not already open. This can be useful in an application that must call the Fill method for two or more SqlDataAdapter objects. If the SqlConnection is already open, you must explicitly call Close or Dispose to close it.
When an instance of SqlDataAdapter is created, the following read/write properties are set to the following initial values.
Properties | Initial value |
|---|---|
MissingMappingAction.Passthrough | |
MissingSchemaAction.Add |
You can change the value of either of these properties through a separate call to the property.
The following example creates a SqlDataAdapter and sets some of its properties.
Available since 1.1