data access help

[Guest]

hey all,
i have a stored procedure that will always return one row.

can someone please show me the c# syntax (or direct me to a good reference
article) to take the 1 row resultset from my stored procedure and drop it
into an untyped DataRow?

thanks,
rodchar

 

[sloan]

If you always have 1 row returned, then using output parameters is the
fastest way to get the data.

.....

Here is an additional resource:
http://msdn2.microsoft.com/en-us/library/8fxztkff(VS.80).aspx

http://msdn2.microsoft.com/en-us/library/ms171918(VS.80).aspx

which pretty much has every permutation you can think of.

 

[Nicholas Paldino [.NET/C# MVP]]

rodchar,

As sloan said, the better way is to use output parameters.

If you need it in a data row though, then you can just attach the
command to a data adapter and then fill a data table, and then get the first
row.

 

[Guest]

thanks everyone for that refresher. man, where is my memory?