Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SqlDataAdapter Constructor (String, SqlConnection)

SqlDataAdapter Constructor (String, SqlConnection)

Initializes a new instance of the SqlDataAdapter class with a SelectCommand and a SqlConnection object.

Namespace:  System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

public SqlDataAdapter(
	string selectCommandText,
	SqlConnection selectConnection


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.

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.


Initial value





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.

public static SqlDataAdapter CreateSqlDataAdapter(string commandText,
    SqlConnection connection)
    SqlDataAdapter adapter = new SqlDataAdapter(commandText, connection);

    adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

    // Create the other commands.
    adapter.InsertCommand = new SqlCommand(
        "INSERT INTO Customers (CustomerID, CompanyName) " +
        "VALUES (@CustomerID, @CompanyName)");

    adapter.UpdateCommand = new SqlCommand(
        "UPDATE Customers SET CustomerID = @CustomerID, CompanyName = @CompanyName " +
        "WHERE CustomerID = @oldCustomerID");

    adapter.DeleteCommand = new SqlCommand(
        "DELETE FROM Customers WHERE CustomerID = @CustomerID");

    // Create the parameters.
        SqlDbType.Char, 5, "CustomerID");
        SqlDbType.VarChar, 40, "CompanyName");

        SqlDbType.Char, 5, "CustomerID");
        SqlDbType.VarChar, 40, "CompanyName");
        SqlDbType.Char, 5, "CustomerID").SourceVersion = DataRowVersion.Original;

        SqlDbType.Char, 5, "CustomerID").SourceVersion = DataRowVersion.Original;

    return adapter;

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1

.NET Framework Client Profile

Supported in: 4, 3.5 SP1
© 2015 Microsoft