I'm having trouble (again) with the DataSource Configuration Wizard.
VS2008 - vb.net project with SQL database.
I added a new view to the database, then ran the Data Source Configuration Wizard to add the view to my table.
The result was too many errors to list, they all seemed to be "duplicate class" errors.
On looking through "Solution Explorer" I found that under my xsd file a new designer file had appeared, so I had
Dataset.xsd --> Dataset.designer.xsd --> Dataset.designer4.xsd
The "designer4" file had a "newly added" flag on it.
I deleted designer4 & the errors disappeared & the project can be run again.
However, if I so much look at the xsd, the designer4 file is created again.
So, a couple of questions - it seems that somethings out of sync and "it" doesn't realise there's a designer file there already so is creating a new one. Any idea how I can fix this?
Alternatively I'm tempted to delete the original designer file & leave designer4 - is this safe to do?
Thanks - Changed TypeKira QianMSFT, ModeratorThursday, August 13, 2009 7:04 AM
- Changed TypeKira QianMSFT, ModeratorThursday, August 13, 2009 7:04 AM
-
|
| GraemeP Thursday, August 06, 2009 9:39 PM |
Make backup copies and then delete the affected .xsd and relatedfiles from the project. Actually delete -- don't just remove from the project.
Close Visual Studio and open the .vbproj file (it is XML) in notepad. Look throughit and make sure that everything related really is gone.
Copy only the .xsd back to your project's folder, start Visual Studio again,and the use Add Existing File to addthe .xsdback into the project.
|
| BinaryCoder Friday, August 07, 2009 12:03 AM |
Hi, I did all that.
Now when I start up I can see the xsd but there are no datasources.
If I use "add data source" it creates a new source - and presumably won't recognise all the queries etc I have in the original table adapters....
The Data Source configuration wizard can't be run unless I go through and add a new database first
As an update, I'm back to having dataset.designer.vb and dataset4.designer.vb
If I delete dataset4.designer.vb the project runs but this file is created again whenever I touch the datasource wizard.
I have also tried deleting dataset.designer.vb and leaving dataset4..... The project runs, however when i go into the data source configuration wizard - although I can see all the tables it won't do anything (I press "finish" and it just sits there) |
| GraemeP Friday, August 07, 2009 8:57 AM |
Well somehow or other I am up and running again - albeit with some messy files.
I ended up allowing it (MSDataSetGenerator) to generate the dataset4.designer.vb file.
Then I deleted the original dataset.designer.vb file & restarted.
It's now running fine but with the dataset4 file.
Would be nice to clean it up if anyone knows how but other than that it seems to be working.
Thanks |
| GraemeP Friday, August 07, 2009 2:24 PM |
Hi GraemeP,
It seems the project with the DataSet is some part corrupt. Did you make many changes to your DataSet? If it is not a complex work, you may think of delete the DataSet and create a new one.
Sincerely,
Kira Qian
Please mark the replies as answers if they help and unmark if they don't. |
| Kira Qian Monday, August 10, 2009 3:46 AM |
We are changing the issue type to “General Discussion�because you have not followed up with the necessary information. If you have more time to look at the issue and provide more information, please feel free to change the issue type back to “Question�by opening the Options list at the top of the post editor window, and changing the type. If the issue is resolved, we will appreciate it if you can share the solution so that the answer can be found and used by other community members having similar questions.
Please mark the replies as answers if they help and unmark if they don't. |
| Kira Qian Thursday, August 13, 2009 7:04 AM |
Hello, yes that's fine.
When I got the project running again with "designer4" I moved onto other problems! I agree the dataset must be corrept in some way, but it seems to work fine the way it is.
I cannot delete the dataset because I have a large number of queries attached to the table adapter.
For information, this problem is caused when changing the settings to use different database tables. |
| GraemeP Saturday, August 22, 2009 12:42 PM |
index > Windows Forms Data Controls and Databinding > Trouble with xsd