如何将vs中double类型写入sql中 大家帮帮忙～

Question

如何将vs中double类型写入sql中 或者如何在vs中将float类型转化为cstring类型

Answer 1

1 double类型写入sql

double value1 = 10.0f;
double value2 = 20.0f;

using (MySqlConnection con = new MySqlConnection("server=localhost;database=YourDatabase;uid=root;pwd=******")
 {
        con.Open();
                //insert语句根据具体情况输入参数，此例假设为两个字段
        using (MySqlCommand  cmd = new MySqlCommand("insert into Data values (@Parname1 , @Parname2);", con)
        {
            // change MySqlDbType.Double to reflect the real data type in the table.
            cmd.Parameters.Add("@Parname1", MySqlDbType.Double).Value = value1;
            cmd.Parameters.Add("@Parname2", MySqlDbType.Double).Value = value2;

            cmd.ExecuteNonQuery();
        }
 }

2 float类型转化为cstring类型

CString s;
s.Format(_T("%f"), myFloat);