handle a double variable constructed in vb.net in an sql query
Posted on 2007-04-06
I'm strugling with the following issue:-
want to construct an sql query within a vb.net program.
this query contains a variable which is a double like
Dim MyDouble as Double = 0.75
so the query should become like:-
Dim query as string
query = "Update XYZ where myvariable = '0.75'"
How to construct this and how to prevent that it becomes like
Query = "Update XYZ where myvariable = '0,75'" (see the comma in stead of the point)
This is necessary because i want to run
Dim SpToRun As New Data.SqlClient.SqlCommand
SpToRun.CommandType = CommandType.Text
SpToRun.CommandText = Query
SpToRun.Connection = loConnection
and in one way or another the engine sees the 0,75 as a varchar ...