Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / .NET Framework / New Users / March 2007

Tip: Looking for answers? Try searching our database.

Small problem with storing connection strings

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Simon Harvey - 15 Mar 2007 12:49 GMT
Hi all,

I have a data access library project within which I have created a
number of datasets.

In one of the datasets I've added a number of strongly typed
datatable/tableadapters and configured them to use a connection string
that has been stored in a settings file.

The problem I'm having is that wehn I open another dataset and try and
create a new table adapter (or modify an existing one) it won't let me
select the connection string that I've already added to the settings file.

It will add another connection string to the same settings file - but it
wont let me use the one I've already added.

Can anyone please tell me how I can get the damn thing to use only one
connection string as this is making deployment an absolute nightmare.

Thanks to anyone who can advise

Simon
Cowboy (Gregory A. Beamer) - MVP - 15 Mar 2007 17:46 GMT
Not sure, but you can add the file, let it add conn string and then open the
C# file for the DataSet and change to the first connection string.

I have done table adapters in the past and I believe I had it on a single
conn string, without the magic above, but it has been since VS 2005 beta
timeframe, so my memory has faded on how I did it. Apologies.

Signature

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

***************************
Think Outside the Box!
***************************

> Hi all,
>
[quoted text clipped - 18 lines]
>
> Simon
Simon Harvey - 16 Mar 2007 10:33 GMT
Hi there,

Thanks for your help.

I've actually tried to do this, but it really seems to piss the designer
off when I try it. Part of the problem is that it adds numerous
references to the dataset code and the xsd file - not to mention the
settings file and the application config file that its taken to adding
to my data access project.

Stupid arse thing. I know I'm prbably doing something wrong - but I
don't think I'm completely thick - so I dont think its self evident why
what I'm doing isn't working.

I'm giving up cos this is really getting on my tits now.

Thanks again for your suggestion though

Simon

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.