Hey Experts
Is there any way that through stored procedure can it return both enquiry result set and a value.
I created a stored procedure to retrieve product Info with prices between "Min" and "Max",these two parameters are provided by two textBox Control. then I wanna show the enquiry result in a listview and also product quantity in another textBox,How can I make it?

I think the programme only allows me to return either of them because either cmd.ExecuteReader() or cmd.ExecuteScalar() can be run at one time.any way to make it?

thanks for your help!

ERIC

__________________
ERIC

If you call the query using a stored procedure, you could use output parameters. You could also use the default return value parameter ("@Return").

What are you doing with the results of the query? If you are binding the query results to some control, then it's likely that you could use some property of the control to get the number of items bound to it.

-Peter

Thanks for your help,Peter. I did use output parameter to store number of items.I got it to work this way:
first step: cmd.ExecuteNonQuery() to get the number of items through an output parameter
second step: cmd.ExecuteReader() to return query results and display them in a listview.
I just need to run both of them one after another.LUCKY it worked.
I'm not so familiar with the usage of ListView so I dunno which property I should use to get the number of items.But I guess there must be one.You mind tip me again?
Thanks anyway,great appreciation.

ERIC

I'm not sure exactly what it is, but it's likely to be something like ListView.Items.Count.

-Peter

thanks,I'll check it out!

ERIC