getting dbnull from output parameter

  • Thread starter Thread starter roni
  • Start date Start date
R

roni

hi.
using sql server 2000 and ado.net

is there a way to return datatable and output parameter ?

if it's ok,i have a problem,
im getting dbnull in the output parameter,in sp that return also datatable.

any ideas ?
 
Yes, if you use the Fill method or ExecuteReader, both return rowset(s).
Once all of the rowsets have been returned, the OUTPUT and RETURN value
parameters are returned.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
This is quite straightforward, and I agree with the answer that Bill Vaughn
has already given. Can you paste your Stored Proc code if you are still
facing this problem?
 
Back
Top