Feb 10, 2017 03:09 AM|AmtrCoder|LINK
I currently am doing this with 4 different stored procedures, which is very time consuming.
Select * from table1
Select * from table2
Select * from table3
Select * from table4
I just read that I could do this with ONE stored procedure and when the data is returned to my C# syntax (VS 2015 and SQL Server 2008 R2) - it would be stored in a DataSet. That leads to my question, how do I associate which select statement goes to which
Does it work like this
DataSet1 = Select * from table1
DataSet2 = Select * from table2
DataSet3 = Select * from table3
DataSet4 = Select * from table4
And to process the data for grid display etc I would just call the corresponding DataSet1 - DataSet4? Is that correct?