Using 2003 Data Adapters in 2005

[Paul Craig]

Hi everyone,
I have recently upgraded several of my projects from Visual Studio 2003 to
2005 and everything went across quite smoothly. The main problem that I am
having is I have used SQL Data Adapters on many of the forms. These forms
function fine in 2005 however I appear to be unable to configure the data
adapters. In 2003 right clicking on the data adapter and selecting
"Configure data adapter" allowed me to restructure the sql query and then
regenerate the dataset. In 2005 the only option available is Generate
Dataset, which means that I am now unable to alter the structure of any of
the queries on all the these forms.

I understand that in VS 2005 data access is handled differently but to go
through and move all the forms I have already created to the new 2005 way is
currently unfeasible so I am now stuck with not being able to modify any
data side features of all these forms created in 2003.

Any help is greatly appreciated.
Paul

[Chris]

Paul Craig wrote:

Hi everyone,
I have recently upgraded several of my projects from Visual Studio 2003 to
2005 and everything went across quite smoothly. The main problem that I am
having is I have used SQL Data Adapters on many of the forms. These forms
function fine in 2005 however I appear to be unable to configure the data
adapters. In 2003 right clicking on the data adapter and selecting
"Configure data adapter" allowed me to restructure the sql query and then
regenerate the dataset. In 2005 the only option available is Generate
Dataset, which means that I am now unable to alter the structure of any of
the queries on all the these forms.

I understand that in VS 2005 data access is handled differently but to go
through and move all the forms I have already created to the new 2005 way is
currently unfeasible so I am now stuck with not being able to modify any
data side features of all these forms created in 2003.

Any help is greatly appreciated.
Paul

Just do your modification in code. The configuration of the data
through the wizard just writes code in the designer generated section.
Go there and change it yourself.

Chris

[Cor Ligthert [MVP]]

Paul,

Di you alreayd try to insert the SQL DataAdapter etc to your 2005 toolbox
and tried what means for you?

Cor

"Paul Craig" <sd***@ozemail.com.au> schreef in bericht
news:uF**************@TK2MSFTNGP03.phx.gbl...

Hi everyone,
I have recently upgraded several of my projects from Visual Studio 2003 to
2005 and everything went across quite smoothly. The main problem that I am
having is I have used SQL Data Adapters on many of the forms. These forms
function fine in 2005 however I appear to be unable to configure the data
adapters. In 2003 right clicking on the data adapter and selecting
"Configure data adapter" allowed me to restructure the sql query and then
regenerate the dataset. In 2005 the only option available is Generate
Dataset, which means that I am now unable to alter the structure of any of
the queries on all the these forms.

I understand that in VS 2005 data access is handled differently but to go
through and move all the forms I have already created to the new 2005 way
is currently unfeasible so I am now stuck with not being able to modify
any data side features of all these forms created in 2003.

Any help is greatly appreciated.
Paul