J
John
Hi all,
I'm calling a stored proc which does 4 "selects" and then I populate a
dataset looping through the dr using a dr.NextResult() but the stored proc
may not return any results for one or more Select stetments. When this
happens, a table is not returned so the dataset.Fill() does not populate
conatin 4 tables which then each bind to a grid - the nett result is that
the relevant gridview may not show the correct data.
Now when I do a dr.NextResult(), I don't know which table data is being
returned
How can I call a stored proc passing back a table for each Select
irrespective of whether there is data or not?
Regards
John.
I'm calling a stored proc which does 4 "selects" and then I populate a
dataset looping through the dr using a dr.NextResult() but the stored proc
may not return any results for one or more Select stetments. When this
happens, a table is not returned so the dataset.Fill() does not populate
conatin 4 tables which then each bind to a grid - the nett result is that
the relevant gridview may not show the correct data.
Now when I do a dr.NextResult(), I don't know which table data is being
returned
How can I call a stored proc passing back a table for each Select
irrespective of whether there is data or not?
Regards
John.