I'm returning over 30 tables in a sql stored procedure which come back in a dataset.
I store this in session state and hold for 20 mins before refreshing.
My problem is, I need to be able to search the dataset for a particular table by name.
At the moment I am hard coding numbers e.g. dataset.Tables, where as I need to be able to say dataset.Tables["AgeRanges"].
I know that my tables are coming back from sql with default names of Table, Table1, Table2 etc.
Can someone help me out with this? Is there is a better way to do it?