Dynamic Sql Connection String

[Guest]

We are developing an asp.net web application. When we drag and drop the sql
connection object to the form we set the in the dynamic properties connection
string to use the connection string in the web.config file. Works Great
except everytime we need drag and drop a new data adapter on the form we
automatically creates a new connection sql string object.

 

[Alex Passos]

Try and make one connection on your form and then code up your other command
objects to use that single connection.

 

[Guest]

I'm not sure why you would have to code up for this.....I would think that
each new data adapter that is added to the web form would use the existing
connection string from a data adapter that is already on the same form.

It doesn't make a lot of sense that a web form would have 10 data adapters
and 10 sql connection objects on the form.