Got more questions? Find advice on: SQL | XML | Regular Expressions | Windows
in Search
Welcome to AspAdvice Sign in | Join | Help

StevenBarden

Old XSD Signature

I was using an XSD with a table adapter to fill controls in a form view one day when I found that my changes were not working. I needed to add a new column to my database. With that done I opened the XSD and updated the associated sql statements in the data table adapter. Next I opened the ascx controls page and moved to update the info in the ObjectDataSource. The problem is that no matter what I did I could not get access to my new sql table column. One suggestion was to manually add the parameters to the source view of the ascx, but this was not the trick. The more I worked it over I was left feeling that although the XSD was obviously updated, it did not seem to update the signature. I finally moved into the object browser and viewed the signature and it was not working, the signature was not updated. Multiple experiments finally lead to the visual step by step comparison of the XSD with another and the problem was discovered... while clicking on the XSD, and viewing the properties of the XSD, it became obvious that the Custom Tool setting was empty. The correct answer is "MSDataSetGenerator". Once this was added, and the project was recompiled, the solution was found.

Published Monday, February 11, 2008 2:53 PM by SteveB

Comments

No Comments
Anonymous comments are disabled