How change Connection name for Dataset

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

VB Programmer - 06 Sep 2007 15:24 GMT

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=|DataDirectory|\ASPNETDB.MDF;Integrated
Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>

Reply to this Message

Cowboy (Gregory A. Beamer) - 06 Sep 2007 20:21 GMT

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?

Signature

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

*************************************************

| Think outside the box!

*************************************************

> Using ASP.NET 2.0
>
[quoted text clipped - 16 lines]
> providerName="System.Data.SqlClient" />
> </connectionStrings>

Reply to this Message

VB Programmer - 07 Sep 2007 19:45 GMT

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.

> 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
[quoted text clipped - 24 lines]
>> providerName="System.Data.SqlClient" />
>> </connectionStrings>

Reply to this Message

How change Connection name for Dataset

Free Magazines