I wish to execute a stored procedure which would return a record in a database.
I have not been able to find an example of this where the return value is a recordset.
And when adding parameters to the stored proceedure there is no type of recordset to add as a output parameter.

Can anyone point me in the right direction to execute such a query with c#.

My intent is to have a method getPerson, which will accept the PersonID and return the values in the database for that person.

Any help would be very much appreciated.


======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

__________________
======================================
"They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad."
--Shakespeare
======================================

Hi Rod,

You can't return a record as an output parameter. Either output each value separately, or use a complete "recordset" as the result of the stored procedure.

You can use ExecuteReader to get a DataReader that holds your records. You can read individual columns from this Reader. The DataReader is an object that looks the most like a classic recordset in ADO.

Look here for an example:
http://msdn.microsoft.com/library/de...ithcommand.asp

But searching for ExecuteReader on Google should return loads of useful hits.

Instead of a DataReader, you can also use a DataSet. For a single record, a DataSet may cause too much overhead, though. A DataReader is usually the fastest way to get a record.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thanks Imar.

======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

And to just return the record(s) from a procedure, just select the record:

SELECT * FROM foo