Mike,
They can, but you have to set that in code. But you can't set it until it's
already on the page. Really the only way to get the default behaviour you
want is to create your own control. That's why it's great that .NET utilizes
inheritance, you can access all the prewritten behaviours of the control
with a single line of code:
Inherits System.Data.SqlClient.SqlDataAdapter
And then customize it to do what you want.
--
Sincerely,
S. Justin Gengo, MCP
Web Developer / Programmer
www.aboutfortunate.com
"Out of chaos comes order."
Nietzsche
"Mike Moore" <Mi*******@discussions.microsoft.com> wrote in message
news:10**********************************@microsof t.com...
Why can't the data adapters use the same sql connection string object?
"S. Justin Gengo" wrote:
Mike,
You can't stop the built in Adpapter from doing that. But you could make
your own Adapter control that doesn't do that. Just create a new control
and
inherit the Adapter control. Then find and override the method that calls
and creates the new SQL Connection object and do nothing or hook up your
connection automatically via code.
--
Sincerely,
S. Justin Gengo, MCP
Web Developer / Programmer
www.aboutfortunate.com
"Out of chaos comes order."
Nietzsche
"Mike Moore" <Mi*******@discussions.microsoft.com> wrote in message
news:80**********************************@microsof t.com... > 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
> visual
> studio automatically creates a new connection sql string object. Why?
> and
> how
> to fix?
>