>>>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);

Thank you very much.