How can I consume multiple result sets from a stored procedure and bind them into different datatables? Platform: C# ASP.NET 2.0
I have different controls on a page ( gridview, repeater, label so on ). In data layer I will call a stored procedure which will return multiple result sets. My plan is to place them in a different datatables and them bind data to different page asp.net controls for data display.