G
Graeme SP
Guest
Hi all,
I have a SQL table which has a number of columns in it that are formatted as "float". I can happily put any decimal numbers directly in the table. eg 1.2345 works fine.
I then have a VB form with a datagridview of that table on it. It displays 1.2345 no problem. However if I type 1.2345 into the datagrid view and save it, 1.23 is saved in the SQL database.
Clearly the save process is rounding the field to 2 decimal places.
The datagrid columns are set to "no formatting", setting to N4 does not help - it just displays 4 decimal points.
If I go into the xsd of the project I can see the properties of the fields are system.decimal
Any ideas?
Thanks
Continue reading...
I have a SQL table which has a number of columns in it that are formatted as "float". I can happily put any decimal numbers directly in the table. eg 1.2345 works fine.
I then have a VB form with a datagridview of that table on it. It displays 1.2345 no problem. However if I type 1.2345 into the datagrid view and save it, 1.23 is saved in the SQL database.
Clearly the save process is rounding the field to 2 decimal places.
The datagrid columns are set to "no formatting", setting to N4 does not help - it just displays 4 decimal points.
If I go into the xsd of the project I can see the properties of the fields are system.decimal
Any ideas?
Thanks
Continue reading...