Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

usig dataset

Using Dataset

we can return dataset and can stored it in dataset and can fetch data from different table using DataSet ds= ds.Tables[0] ,ds.Tables[1]

hi , Please look at below link this will help you https://chsakell.com/2013/06/22/ado-net-working-with-dataset-datatable-datacolumn-datarow-and-datarelations/

Use Dataset to get value from stored procedure Use below code to retrieve the data from each table Datatable A=ds.Tables[0] Datatable B=ds.Tables[1]