Dynamic connectionstring with Dataset Wizards ? (VS2005)

[Sagaert Johan]

Hi

The Dataset wizard in VS2005 generates a setting entry for the
connectionstring.
The connectionstring is in the settings file.
Setting the property to a dynamic value by writing to the settings does not
work since it is read only..

The get property is in the autogenerated settings.designer.cs , and thats
where i assign it a new value.
Problem is that after some project rebuilds, this autogenerated file gets
rebuild and my changes to it are gone.
I see no other solution then to write in this code.


Is there a solution to solve this in a proper way ?


J

 

[Galcho[MCSD.NET]]

there is elegant solutions to this. it is allowed by partial classes
in C# 2.0

http://blogs.msdn.com/alan_cameron_wills/archive/2005/11/03/483726.aspx



hope this helps
Galin Iliev[MCSD.NET]
www.galcho.com

 

[Galcho[MCSD.NET]]

I forgot to tell you...

you can change connection string on TableAdapter instance by using
ConnectionString property (as far as I remember)

hope this helps
Galin Iliev[MCSD.NET]
www.galcho.com