updating the dataset.xsd file

Hi,

I have created a data table within the IDE Database explorer, and added it to the solution explorer using the Add new datasource menu option. All works fine, the problem is: When I add a new column to the table within database explorer the changes made are not reflected in the dataset.xsd file within solution explorer.

The only way the changes take effect is by deleteing the DataSet.xsd file from the solution explorer and then re-adding in the datasource. This however causes me a big issue as I have defined my SQL statements using the view desingner option on the Dataset.xsd file, I loose these statements and I have to re-create them.

Is there an answer to this problem?

Ron

[717 byte] By [ronnash] at [2007-12-22]

«« Background/Start Menu
»» Replication problem with stored procedure

# 1

After you add the column to the table, right-click the table in the XSD designer and choose Configure. You'll see the SQL statement that selects the data, edit it by hand or use the Query Builder. Click Finish and all the designer generated files will be updated.

nobugz at 2007-8-30 >

top of Msdn Tech,Visual Studio Express Editions,Visual Basic 2005 Express Edition...

# 2

Thanks for the reply,

I was hoping there was a simpler way of doing this.

I have to manualy add the new columns to the table within the XSD designer
Configure each columns properties
Update all the SQL statements configured within the XSD designer

Ron

ronnash at 2007-8-30 >

Visual Studio Express Editions Hot Topic

Visual Studio Express Editions New Topic

Visual Studio Express Editions

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech