Visual Studio 2005 vs 2003

[DanielaTm]

Hi,
I worked before in Visual Studio 2003, and I used strongly typed dataset to work with database. To use the connection string I set before in app.config, I have had an sqlConnection object , and every adaptor connected to them.

I just started to work with VS 2005 , and I can't see an sqlConnection object !!! What can I do to 'give' to every adaptor the same connection and keep it in app.config. What is the most appropriate way to deal with the 'database', to obtain at least the same advantages like in 2003?


Thanks a lot

[Athley]

When I created a typed DS in 2005 I had to create a Connection object, and later it asked me if I wanted to store the connectionstring for that connection in the application settings file, and I answered yes... That is not what is happeneing for you?

/Leyan

[DanielaTm]

Hi,
Yes, I passed that, but what confuses me is that I can't actually see the connection object like in 2003 and I have some questions about it:

1.When I'll deploy the application, is enough to change the connection string in app.config?Or I have to do something more regarding the adapters?
2.If I use the connection I created, another developer, from my team, would he be able to see it?

Sorry if it is a stupid question, but VS 2005 still has misteries for me...
Thanks a lot

[Athley]

As far as I know there is not an actual connection object, in the prebuilt class there should be a InitConnection method or something like that, that creates a connection from your connectionstring just then.

And yes, it should be enough to change the connection string in the settings file.

There is of course an actual connection, but not a graphical one, each tableadapter has a _connection member, if I remeber correctly.

/Leyan

[DanielaTm]

Thank you, it worked.
Daniela