Return Value from Stored procedure

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bbawa1@yahoo.com - 18 Jun 2007 20:49 GMT

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.

Reply to this Message

Peter Bromberg [C# MVP] - 18 Jun 2007 21:09 GMT

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

Signature

Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net

> 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
[quoted text clipped - 4 lines]
>
> Thanks.

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...