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]

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/