assuming you can't unglue your design, I wonder if you could use dynamic sql from within a table based user defined function. attach the user defined function inside your proc...

imagine moving all the data from your multiple datasets into one table

but adding a column with an enumerator with a value inserted to match each of your previous other datasets.

now...

Your best bet is Teo Lachev's forms authentication examples. Try a search for Teo and/or Proligika. His articles have appeared on DevX.

Of course the built in example from Microsoft is...

you will need to merge your datasets into one dataset.

RS doesn't support multiple datasets with a connection btw the datasets. However if you merge the data into one dataset and...