comma seperated values and access

Nov 12 2003 4:00 PM
hi guys, i have some weird problems with ms access + c# i have created a table with some columns in access, using the double datatype to allow comma seperated values. when i insert a value in access, the value is saved correctly. but when i insert a value in c#, it is displayed correctly in the datagrid, but it gets saved without the comma and all decimal places. for instance: i'm inserting 4,5 and 6,4 in the grid, and they are displayed correctly. after that i save the changes in the dataset and database. when i reload the form, all values except comma seperated numbers are indicated correctly in this case 4 and 6 are displayed :-( does anybody know how to fix that? i do not have a clue what i can do...