How to use adapter when returned by the following function

[CPK_2011]

public static SqlDataAdapter CreateSqlDataAdapter(SqlConnection connection)
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

// Create the commands.
adapter.SelectCommand = new SqlCommand(
    "SELECT CustomerID, CompanyName FROM CUSTOMERS", connection);
adapter.InsertCommand = new SqlCommand(
    "INSERT INTO Customers (CustomerID, CompanyName) " +
    "VALUES (@CustomerID, @CompanyName)", connection);
adapter.UpdateCommand = new SqlCommand(
    "UPDATE Customers SET CustomerID = @CustomerID, CompanyName = @CompanyName " +
    "WHERE CustomerID = @oldCustomerID", connection);
adapter.DeleteCommand = new SqlCommand(
    "DELETE FROM Customers WHERE CustomerID = @CustomerID", connection);

// Create the parameters.
adapter.InsertCommand.Parameters.Add("@CustomerID", 
    SqlDbType.Char, 5, "CustomerID");
adapter.InsertCommand.Parameters.Add("@CompanyName", 
    SqlDbType.VarChar, 40, "CompanyName");

adapter.UpdateCommand.Parameters.Add("@CustomerID", 
    SqlDbType.Char, 5, "CustomerID");
adapter.UpdateCommand.Parameters.Add("@CompanyName", 
    SqlDbType.VarChar, 40, "CompanyName");
adapter.UpdateCommand.Parameters.Add("@oldCustomerID", 
    SqlDbType.Char, 5, "CustomerID").SourceVersion = DataRowVersion.Original;

adapter.DeleteCommand.Parameters.Add("@CustomerID", 
    SqlDbType.Char, 5, "CustomerID").SourceVersion = DataRowVersion.Original;

return adapter;

}

The above function returns adapter of SqlDataAdapter type. Could anyone suggest on how to use it for InsertCommand, UpdateCommand and DeleteCommand in some other place.

[N a v a n e e t h]

praveen.code999 wrote:

how to use it for InsertCommand, UpdateCommand and DeleteCommand in some other place.

Do you want an option to specify the command which has to be created instead of creating all three?

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions