Customize TableAdapter

[Guest]

Hi all, i am using ASP.NET 2.0. I created a dataset using the designer and
added a couple of table adapters to the dataset. The connection string was
stored in the web.config for now. But, i want to pass a connection object at
run time. Is this possible?

Thanks