Decimal point being changed ot decimal Comma by MySqlComman:Command text

[Guy Platt]

Hi,

I'm running 1.0.4 and have encountered something strange.

The following code crashes on the ExecuteQuery with a SQL error.

fundShare = Convert.ToDecimal(( (allocationPerc / 100) * oldSum ) / fundValue));
fundShare = Math.Round(fundShare,2);

myCmd.CommandText = "INSERT INTO performance_detail (FundNr, FundShare) VALUES ('"+ fundNr
+"','"+ fundShare +"')";
myCmd.ExecuteNonQuery();

Checking under debug fundShare contains the value "95.66" but the CommandText shows this
value as "95,66". I presume that it is a case of .NET storing the decimal with a
placeholder or a decimal point, but when it is given to the CommandText the value is
converted to show a decimal comma (which causes MySql to crash).

Can anyone tell me how to overcome this?

thanks
  Guy