There shouldn't be any need to pass in the connection. The connection can be opened and closed each time you retrieve data. This the default behavior for the dataadapter.
>The ideal situation is for all programmers in our company to use this generic class, passing in an active connection as well as table names so that the class would return a dataset.
>
>Does that make sense?
>
>I need some advice, hints...
>
>Thanks,
>Alvin