Return Value from Stored procedure

[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.

 

[Guest]

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