Return Value from Stored procedure

  • Thread starter Thread starter bbawa1
  • Start date Start date
B

bbawa1

I have a stored proceure whic is returning a table. Now I need ADO.Net
statement So that I can pass parameters to this stored procedure and
get Retuened table from stored procedure.

Could you please send me code how can I reterive a returen value of
type table from stroed procedure in ADO.Net

Thanks.
 
I think you mean to say a stored procedure that returns a resultset.
You can use the ExecuteReader method of the command object to return a
SqlDataReader, or you can use the SqlDataAdapter's Fill method to fill a
DataTable or a DataSet.
Peter
 
Back
Top