"Cannot change DataType of a column once it has data" error in Visual Studio 2005 DataSet Designer

visual-studio dataset .net-2.0 dataset-designer
firedfly picture firedfly · Sep 6, 2008 · Viewed 20.1k times · Source

I've got a DataSet in VisualStudio 2005. I need to change the datatype of a column in one of the datatables from System.Int32 to System.Decimal. When I try to change the datatype in the DataSet Designer I receive the following error:

Property value is not valid. Cannot change DataType of a column once it has data.

From my understanding, this should be changing the datatype in the schema for the DataSet. I don't see how there can be any data to cause this error.

Does any one have any ideas?

Answer

Are picture Are · Dec 15, 2009

I get the same error but only for columns with its DefaultValue set to any value (except the default <DBNull>). So the way I got around this issue was:

  1. Column DefaultValue : Type in <DBNull>
  2. Save and reopen the dataset

Related questions

Update DataSet structure in Visual Studio to match new SQL Database Structure

After making some changes to my SQL database structure (using scripts in SQL Server Management Studio), how can I update my DataSet.xsd file in Visual Studio to match the new structure? Must I do this manually? I considered deleting …

Read More
Conflicting versions of MySql.Data.dll in .Net project not allowing me to add/edit TableAdapters in my DataSets

I have a WinForms / .Net 4.0 application in Visual Studio 2015 Update 3. When I try to add, or edit, a TableAdapter in any of my DataSets, I get this error: The wizard detected the following problems when configuring the TableAdapter: Details: Generated …

Read More
C# (Visual studio): Correlation between database, dataset, binding source

I am just learning C# through Visual Studio 2008? I was wondering what exactly is the correlation between dabases, datasets and binding sources? As well, what is the function of the table adapter?

Read More