Putting a REAL in SQLCE

Hi,

Here I aam with another stupid question to which I can't find an answer:

I have to insert a simple float into a SQLCE database.

I do something like:

INSERT INTO table (data) VALUES ('XXXXX').

Which should be the format of XXXX ????
I am trying everything, but I can't get my numbers in it.

I program in CSharp and I use the method float.ToString(format).

Does anyone know a right format string ? (I have also to cope with the
regional settings! So i need a universal format).

Thanks very much.


Dario

Arun
Thu Jan 18 13:42:21 CST 2007

See if this is helpful in converting float to string
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdoubleclasstostringtopic4.asp

Cheers,
Arun
www.innasite.com


Dario Salvi wrote:
> Hi,
>
> Here I aam with another stupid question to which I can't find an answer:
>
> I have to insert a simple float into a SQLCE database.
>
> I do something like:
>
> INSERT INTO table (data) VALUES ('XXXXX').
>
> Which should be the format of XXXX ????
> I am trying everything, but I can't get my numbers in it.
>
> I program in CSharp and I use the method float.ToString(format).
>
> Does anyone know a right format string ? (I have also to cope with the
> regional settings! So i need a universal format).
>
> Thanks very much.
>
>
> Dario