How change Connection name for Dataset

[VB Programmer]

Using ASP.NET 2.0

Created DataSet1.xsd. It's using the Connection "ASPNETDBConnectionString
(Web.config)". I want to use a different one, LocalSqlServer. How do I
change it?

I tried to change the Connection/Name property of the adapter to
"LocalSqlServer (Web.config)", but it says "Property value is not valid."

Any ideas? Thanks!

Here's my connection strings in my web.config...

<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\ASPNETDB.MDF;Integrated
Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>

[Cowboy \(Gregory A. Beamer\)]

Open web config and look at teh connection strings portion. If you do not
have one for LocalSqlServer, you will never get anywhere with this approach.

I assume you are using table adapters?

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

*************************************************
| Think outside the box!
|
*************************************************
"VB Programmer" <do**********@somewhere.comwrote in message
news:OL**************@TK2MSFTNGP03.phx.gbl...

Using ASP.NET 2.0

Created DataSet1.xsd. It's using the Connection "ASPNETDBConnectionString
(Web.config)". I want to use a different one, LocalSqlServer. How do I
change it?

I tried to change the Connection/Name property of the adapter to
"LocalSqlServer (Web.config)", but it says "Property value is not valid."

Any ideas? Thanks!

Here's my connection strings in my web.config...

<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\ASPNETDB.MDF;Integrated
Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>

[VB Programmer]

Yes. I'm using LocalSqlServer throught the web project. It's in the
web.config and working fine.

I just want to know how I can make DataSet1.xsd use LocalSqlServer. It
keeps wanted to use the other one.

Thanks.

"Cowboy (Gregory A. Beamer)" <No************@comcast.netNoSpamMwrote in
message news:Ou**************@TK2MSFTNGP05.phx.gbl...

Open web config and look at teh connection strings portion. If you do not
have one for LocalSqlServer, you will never get anywhere with this
approach.

I assume you are using table adapters?

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

*************************************************
| Think outside the box! |
*************************************************
"VB Programmer" <do**********@somewhere.comwrote in message
news:OL**************@TK2MSFTNGP03.phx.gbl...

>Using ASP.NET 2.0

Created DataSet1.xsd. It's using the Connection
"ASPNETDBConnectionString (Web.config)". I want to use a different one,
LocalSqlServer. How do I change it?

I tried to change the Connection/Name property of the adapter to
"LocalSqlServer (Web.config)", but it says "Property value is not valid."

Any ideas? Thanks!

Here's my connection strings in my web.config...

<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirecto ry|\ASPNETDB.MDF;Integrated
Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>