ADO question moved to .NET forum

[T2102]

Does anyone know how to execute a parameterized stored procedure that returns a recordset using ADO .NET? I noticed neither direct Parameter members on the DataAdapter nor Fill members on a db_Command. My workaround has been to use an Adapter to execute a query such as "EXECUTE Procedure 1, 2, 3". I would prefer not to execute a reader. --1st method System::Data::OleDb::OleDbCommand ^db_Command=gcnew System::Data::OleDb::OleDbCommand(gcnew System::String(Procedure_Name), db_Conn); db_Command->CommandType = System::Data::CommandType::StoredProcedure; db_Command->Parameters->Add("usr_id", System::Data::OleDb::OleDbType::Integer, 4); db_Command->Parameters[0]->Value=1; --2nd method --- I get an error about the parameter not being supplied. System::Data::OleDb::OleDbDataAdapter ^db_Adapter=gcnew System::Data::OleDb::OleDbDataAdapter( "exec "+gcnew System::String(Procedure_Name), db_Conn); db_Adapter->SelectCommand->Parameters->Add("usr_id", System::Data::OleDb::OleDbType::Integer, 4); db_Adapter->SelectCommand->Parameters[0]->Value=1; System::Data::DataSet ^db_DataSet=gcnew System::Data::DataSet; int const Fill_Result=db_Adapter->Fill( db_DataSet); //note that an error will be thrown if the query is invalid

modified on Thursday, November 26, 2009 3:13 AM

[dan sh]

You should have posted this in C++ forum.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!