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 at all is greatly appreciated.
Paul Craig

 

[Cowboy \(Gregory A. Beamer\)]

The normal data access is all encapsulated in one object in 2005 (overall,
yuck, but there are some reasons it can be useful). Not sure about the
DataAdapters. You may well have lost right click, but you can edit in the
background. Just go into the "Do not touch this code" Microsoft section and
find the set up for the DataAdapter. A pain? Sure, but it is a wonderful way
to get to understand how the system works. If you are not using source
control, save a copy before editing, just to be safe. You will find that
editing the code is not that serious once you play a bit.

--
Gregory A. Beamer

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