Using 2003 Data Adapters in 2005

21 May 2006 11:32 PM

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

22 May 2006 1:05 AM

Chris

Paul Craig wrote:
Show quoteHide quote

> 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

22 May 2006 6:26 AM

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

Show quoteHide quote

"Paul Craig" <sd***@ozemail.com.au> schreef in bericht
news:uF$9T7SfGHA.5040@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
>