Frankie,
If the values are not returned through output parameters, then you could
use a DataReader instead. This is much lighter weight, and you can access
the values (you iterate through the reader for each row in the result set
returned) through the GetInt32, GetBoolean, etc, etc methods.
Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
-
mv*@spam.guard.caspershouse.com
"Frankie" <A@B.COM> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl...
What would be an efficient way to retrieve two values from a stored
procedure via ADO.NET? I understand ADO.NET's ExecuteScalar() method
returns one value.
I need two values returned, and didn't want to .Fill() a DataTable just to
get two values (I am wanting fewer lines of code and something more
efficient than that if possible).
Any suggestions?
Thanks!