Cannot make changes to dataset

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tore - 06 Feb 2006 14:46 GMT

I develop a C# application in VS 2005, a distrbuted application with a
windows client and web services communicating with SQL Server 2000 database.
The solution has recently been successfully deployed, using click once plus
publish of a web site. I have a problem with the development platform running
on my lwindows xp professional laptop

It seems that the VS 2005 IDE does not allow me to change existing datasets
any more. I have a number of asmx files and open one of them in the design
mode.I want to make a change to a dataset so I right-click on one of the sql
data adapters and select 'Generate dataset'. In the following dialogue box
none of the datasats of the solution can be selected, the pull-down menu for
'existing datasets' is empty. The datasets still exist in the solution as the
application (including datasets) run ok in debug mode.

When I try to create a new dataset in stead of selecting an existing one, it
is created but I get an error message: 'Could not get type information for
Dataset1'. Dataset 1 is still created and is visible in the solution
explorer. When I try to change dataset1 by right-clicking a sql data adapter
(same procedure as explained above) Dataset1 is not available as an
"existing dataset".

What could be wrong here? I have looked through the settings of IIS and
enabled about everything I can think of.

Regards

Tore

Reply to this Message

"Gary Chang[MSFT]" - 07 Feb 2006 06:48 GMT

Hi Tore,

>It seems that the VS 2005 IDE does not allow me to change
>existing datasets any more. I have a number of asmx files
>and open one of them in the design mode.I want to make a
>change to a dataset so I right-click on one of the sql
>data adapters and select 'Generate dataset'.

In order to isolate this problem, we may need more details about this issue.

How did you create the datasets you want to change? Are they generated by
the specified SQL data adapters you mentioned above?

Does this problem occur to any other projects--web projects or windows form
projects. We haven't experienced such an issue on our side. If you delete
the exisiting datasets, and generate a new one, is it OK?

By the way, you mentioned opening one asmx file in the design mode, since
the VS2005 doesn't provide a user interface to a web service, how did you
open it in VS2005's design view.

Thanks for your understanding!

Best regards,

Gary Chang
Microsoft Community Support
======================================================
PLEASE NOTE the newsgroup SECURE CODE and PASSWORD will be updated at 9:00
AM PST, February 14, 2006. Please complete a re-registration process by
entering the secure code mmpng2006 when prompted. Once you have entered the
secure code mmpng2006, you will be able to update your profile and access
the partner newsgroups.
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

Reply to this Message

Tore - 07 Feb 2006 22:59 GMT

What i called "design mode" is the following procedure: I select the
asmx.cs-file in solution explorer. I right-click the file and select "view
designer". This opens a page with my sql data adapters and my sql connection.
This page is what I have called "design mode".

In this page I right-click on one of the sql data-adapters. I select
"generate dataset" in the drop-down menu. This opens a form "generate datset"
where I could previously select "existing dataset" to generate changes to it.
This is no longer possible as the "existing dataset" drop down list is always
empty.

The datasets were originally created in VS 2003. I converted the project to
VS 2005 some time ago. The datasets were created in VS 2003 from the sql
data-adapters by right-clicking and selecting "generate dataset".

If I create a new project with new dataadapters and create datasets from the
dataadapters, I am not able to make changes to the the dataadapters
afterwards. This seems to be the same problem as I have described in this
post and my previous post.

If I delete the dataset completely I am able to recreate it as the wizard
allows me to create a new dataset. But I have to recreate it completely on
the first attempt. The wizard started by right-clicking the data adapters
does not allow me to make changes to an existing dataset. I have realized
that there are other ways to change datasets, but they take a lot more of
work than using the wizard.

Regards

Tore

Reply to this Message

"Gary Chang[MSFT]" - 08 Feb 2006 05:47 GMT

Hi Tore,

>If I create a new project with new dataadapters and create
>datasets from the dataadapters, I am not able to make
>changes to the the dataadapters afterwards. This seems
>to be the same problem as I have described in this
>post and my previous post.

Do you mean you cannot change the SQL dataadapter via "Configure Data
Adapter..." in VS2005, if so, would you please tell me which the error
message about it?

I haven't expereniced a such issue on our side, I am able to use the
"Configure Data Adapter..." command to invoke the Data Adapter
Configuration Wizard to change the dataadapter, and then call the "Generate
Dataset" to refresh the current one(you may need to delete the existing
dataset in its design view first) or generate a new dataset.

Thanks!

Best regards,

Gary Chang
Microsoft Community Support
======================================================
PLEASE NOTE the newsgroup SECURE CODE and PASSWORD will be updated at 9:00
AM PST, February 14, 2006. Please complete a re-registration process by
entering the secure code mmpng2006 when prompted. Once you have entered the
secure code mmpng2006, you will be able to update your profile and access
the partner newsgroups.
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

Reply to this Message

Tore - 08 Feb 2006 22:42 GMT

There is no problem in changing the sql data-adapter, that is ok. The problem
is that VS 2005 does not allow me to change an existing dataset. After som
minor change to the data-adapter I would like to update the dataset.
Right-clicking on a data-adapter, then selecting 'generate dataset' in the
context-menu, then selecting 'existing dataset' does not work. None of the
existing datasets are available for update (not visible in the drop-down
menu), that is my problem.

So I end up with deleting the dataset and recreating it from scratch, just
because I need to do som minor change.

Tore

Reply to this Message

"Gary Chang[MSFT]" - 09 Feb 2006 03:15 GMT

Hi Tore,

>There is no problem in changing the sql data-adapter, that is ok.
>The problem is that VS 2005 does not allow me to change an
>existing dataset.

This problem would not happen in VS2003. Visual Studio 2005 should use a
TableAdapter to generate dataset, I think this is why the SQL Dataadapter
cannot refresh the datasets in VS2005.

I am afraid this behavior is by design in VS2005. I will forward this issue
to our product team for review. Meantime, I suggest you can also submit
this feedback to our product feedback center:

http://lab.msdn.microsoft.com/productfeedback/default.aspx

Thanks for your understanding!

Best regards,

Gary Chang
Microsoft Community Support
======================================================
PLEASE NOTE the newsgroup SECURE CODE and PASSWORD will be updated at 9:00
AM PST, February 14, 2006. Please complete a re-registration process by
entering the secure code mmpng2006 when prompted. Once you have entered the
secure code mmpng2006, you will be able to update your profile and access
the partner newsgroups.
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

Reply to this Message

Tore - 08 Feb 2006 22:55 GMT

> If I create a new project with new dataadapters and create datasets from the
> dataadapters, I am not able to make changes to the the dataadapters
> afterwards. This seems to be the same problem as I have described in this
> post and my previous post.

One sentence above (in my previous post) was wrong. It should have been:

If I create a new project with new dataadapters and create datasets from the
dataadapters, I am not able to make changes to the the DATASETS afterwards.

Tore

Reply to this Message

MultiParadigm - 09 Feb 2006 04:49 GMT

Did you install the C# 3.0 LINQ Preview?

The Visual Studio IDE Support feature of the preview seems to cause this
problem.

Uninstalling the IDE Support (by running Program Files\LINQ
Preview\Bin>"Uninstall Visual Studio IDE Support.cmd") cleared up the problem
for me.

I can use the C# 3.0 LINQ Preview by just reinstalling IDE support when
needed.

> I develop a C# application in VS 2005, a distrbuted application with a
> windows client and web services communicating with SQL Server 2000 database.
[quoted text clipped - 23 lines]
>
> Tore

Reply to this Message

Tore - 09 Feb 2006 09:10 GMT

Sorry, I have not installed this program, at least not as I am aware of.
Thank you for your suggestion.

Tore

Reply to this Message

Cannot make changes to dataset

Free Magazines