程序如下:
conn = new SqlCeConnection(@"Data Source =\Program Files\sql_server_mobile_1\sqlmobile.sdf");
conn.Open();
String sql = "insert into fsdata(power) values (this.textbox.text)";此处如何写
SqlCeCommand cmd = new SqlCeCommand(sql, conn);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
要把textbox的内容添加到数据库中,添加一条记录。字段power是float类型,如何添加呢
conn = new SqlCeConnection(@"Data Source =\Program Files\sql_server_mobile_1\sqlmobile.sdf");
conn.Open();
String sql = "insert into fsdata(power) values (this.textbox.text)";此处如何写
SqlCeCommand cmd = new SqlCeCommand(sql, conn);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
要把textbox的内容添加到数据库中,添加一条记录。字段power是float类型,如何添加呢
power = Convert.ToSingle(textbox.text.Trim());
String sql = "insert into fsdata(power) values (power)";此处如何写
String sql = "insert into fsdata(power) values ("+this.textbox.text+")"
你得控制textbox只能输入浮点数