How to store comma values in DB

[Wirloff]

--------------------------------------------------------------------------------

Hi,

I have a dataset filled with doubles(9,344 ; 0,543; ...)
When I trie to write it to an access database; It only stores them like integers (9; 0;...) I did have set the property of the field in the database to double, but it stil doesn't work. And even when i set the amount of numbers behind the comma to 3 in the database he stores (9,000 ; 0,000;...)

He obviously doesn't recognize the numbers behind the comma...

Anyone who knows how to solve this?

[Nebo_vb]

It doesn't recognize the numbers behind the comma, true. I had the sam problem a while ago. But you can solve it easily. Here is an example if the number is in the textbox:

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim change As String
        change = TextBox1.Text.Replace(",", ".")
        TextBox1.Text = change
    End Sub

Hope it helps!

Nebo

[Wirloff]

I'm afraid it still doesn't work.
I haven even tried to just place a fixed value 60.6 and it just doesn't matter =s

He always places 61,00.... in the database..But I have tried everything in the access database... I have defined the field as double, currency,.. and have set the numbers behind the come big enough... but he always places zero's behind the comma...

I'm 100% sure that it is possible to place double values in Access but I still don't manage to do it

[Nebo_vb]

And I am 100% sure you can solve the problem with the code I posted

Can you please attach the project or paste a code?

Nebo