M
Molon Labe
Context:
VS2008
SQL Server Compact 3.5 database
Problem:
I used the Dataset Designer to add a column to a table (right click on table
in designer, Add->Column).
How do I update the database to correspond with this change?
I tried locating the database in my Server Explorer and adding the identical
column by hand using the Table Properties.
Run the project and try to stuff some data in the newly modifed table...all
original columns get data but the new column only gets NULLs.
Try to use "Configure DataSet with Wizard" from Data Sources tab...get
warning that "The selected dataset contains objects that can only be viewed
with the Dataset Designer." Which I don't understand because I made what
seems a trivial modification to a table.
It seems there is no correspondence between the new column in the database
and the new column in the dataset. If I access the new column's DataColumn
properties in DataSet Designer, the entry for the "Source" property is empty,
and the dropdown selector only sees the original columns in the table, not
the new one.
VS2008
SQL Server Compact 3.5 database
Problem:
I used the Dataset Designer to add a column to a table (right click on table
in designer, Add->Column).
How do I update the database to correspond with this change?
I tried locating the database in my Server Explorer and adding the identical
column by hand using the Table Properties.
Run the project and try to stuff some data in the newly modifed table...all
original columns get data but the new column only gets NULLs.
Try to use "Configure DataSet with Wizard" from Data Sources tab...get
warning that "The selected dataset contains objects that can only be viewed
with the Dataset Designer." Which I don't understand because I made what
seems a trivial modification to a table.
It seems there is no correspondence between the new column in the database
and the new column in the dataset. If I access the new column's DataColumn
properties in DataSet Designer, the entry for the "Source" property is empty,
and the dropdown selector only sees the original columns in the table, not
the new one.