Change datatype of column in dataset in designtime
-
Hi, thanks for looking Im trying to change the datatype of a column from a datatable in a dataset from smallmoney to money At first when i made the dataset the column in the DB was smallmoney then i changed the column in the DB to money, but in my dataset i have made some relations, set some default values, added custom queries.... I wouldnt like to redrop the table, besides it would be good to know how to do it :) Ive already tryed changing directly the dataset.designer.vb file, finding all occurrences of smallmoney and replacing them with money, but if i make any change to the dataset designer, all code is rewritten and the columns are smallmoney again The datatype of the money and smallmoney columns look the same in the dataset designer (decimal) Where is the datatype of columns saved?? The column in DB is already money type Thanks in advance
Alexei Rodriguez