>>Hi,
>>
>>I am working on a case of replacing what the gurus call "programming to class" with "programming to interface" for the following code:
>>
>>First, the code the way it works currently (not with interface)
>>

>>OleDbCommand oCommand = new OleDbCommand();
>>// connectionString is valid string (not shown here)
>>OleDbConnection oConnection = new OleDbConnection(connectionString);
>>oConnection.Open();
>>oCommand.CommandText = "SP_MyProc";
>>oCommand.CommandType = CommandType.StoredProcedure;
>>oCommand.Parameters.AddWithValue( "@par1", cPar1 );
>>

>>
>>The following is my replacement code (simplified):
>>

>>IDbCommand oCommand;
>>idbCommand = new OleDbCommand();
>>// connectionString is valid string (not shown here)
>>OleDbConnection oConnection = new OleDbConnection(connectionString);
>>oConnection.Open();
>>oCommand.CommandText = "SP_MyProc";
>>oCommand.CommandType = CommandType.StoredProcedure;
>>oCommand.Parameters.AddWithValue( "@par1", cPar1 );
>>

>>
>>The problem is that in the lower case code the method .AddWithValue has an error:
>>

>>'System.Data.IDataParameterCollection' does not contain definition for 'AddWithValue'
>>

>>
>>What am I missing? TIA.
>
>I tried to replace method AddWithValue with Add() but Add() only takes one parameter. So I am not sure how to pass the parameter name and the value if I can't use AddWithValue(). Any suggesetions?

Something like:

          IDbCommand idbCommand = new OleDbCommand();
            IDbDataParameter param = idbCommand.CreateParameter();
            param.ParameterName = "@par1";
            param.Value = cPar1;
            idbCommand.Parameters.Add(param);