If I have a stored procedure that returns two separate non related data result sets can I bind the second result set to a separate controls in ASP.net?
I know the first result set can be bound.
For example, if I have a stored procedure that basically returned to SQL queries like this?
SELECT uid, Name, Price FROM PRODUCTS
SELECT COUNT(*) AS VENDORCOUNT FROM VENDORS
Returns something like:
uid Name Price
1 Product1 5
2 Product2 6
3 Product3 7
If I bind
Repeater1.DataSource = objCommand.ExecuteReader()
Then on my asp page and asp:repeater control I can access that data with something like:
That gives me the data from the first query.
Can I bind the VENDORCOUNT data to a label? If so, how do I get that data exactly?