I ended up finding the problem. It wasn't able to process it due to a calculated field it seems. Not sure why it didn't catch that when I tried to modify the relation.
Thanks. -----Original Message----- From: Discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Erick Thompson Sent: Thursday, January 26, 2006 13:18 To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM Subject: Re: DataSet Explosion - MSDataSetGenerator failed Greg, I don't have an exact answer for you, but I would try using the command line version of the tool, and see what happens there. It tends to give a little better output. Aside from that, I would carefully go over the xsd, as there is probably just a small problem in it. Erick > -----Original Message----- > From: Discussion of advanced .NET topics. > [mailto:[EMAIL PROTECTED] On Behalf Of Gregory > Miley > Sent: Thursday, January 26, 2006 7:24 AM > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM > Subject: [ADVANCED-DOTNET] DataSet Explosion - MSDataSetGenerator > failed > > I was working in a project that had been going well, until a user > pointed out a small bug. The short of the bug was that the relation > was only set as just that, a relation, and was not propagating and > data changes as it should have been. I modified the relation to > cascade changes to the child table. > This worked fine, then I realized that the data should not be removed, > only the field associated should be nulled, so I changed it to > SetNull, as soon as I accepted those changes in the designer VS.Net > 2005 crashed and told me there was a problem and it needed to restart > and that I should reload the project. > > Much to my dismay, when this happened the entire dataset was > corrupted. > I have tried several different ways of fixing this so far as to remove > the generated files (created by MSDataSetGenerator > tool) to no avail. > Every time I attempt to run the MSDataSetGenerator custom tool it > gives me an error stating: > > "The custom tool 'MSDataSetGenerator' failed. Unable to convert input > xml file content to a DataSet. Could not find column [value]." > > I have combed my .XSD file and all nodes appear to be present and > correct. I have backups of all of the generated files, but no backups > (yes, rip me a new one for this) of the last known good version of > this project. > > Before I carry on with further details that may not be needed, I just > wanted to run this by the list and see if what I am presenting has any > obvious solutions. > > Thanks for you help in advance. > > Greg > > =================================== > This list is hosted by DevelopMentor(r) http://www.develop.com > > View archives and manage your subscription(s) at > http://discuss.develop.com > =================================== This list is hosted by DevelopMentor(r) http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
