Modifications to dataset definition after changes made to SQL database table

[eljainc]

Hello,

I have a program written in C#.NET VS2005 that accesses a SQL
database/data table through a dataset. It was decided that a valued
defined as a smallint in SQL Server should be changed to a varchar. I
performed this change without problems. However, the C# program still
has the field defined as an integer type in VS2005. I cannot seem to
modify this property. How do I do this?

Thanks.

Mike McWhinney

 

[DeveloperX]

Hello,

I have a program written in C#.NET VS2005 that accesses a SQL
database/data table through a dataset. It was decided that a valued
defined as a smallint in SQL Server should be changed to a varchar. I
performed this change without problems. However, the C# program still
has the field defined as an integer type in VS2005. I cannot seem to
modify this property. How do I do this?

Thanks.

Mike McWhinney

Is it a typed dataset? If so you'll need to modify the XSD xml file to
the correct type and recompile it.