大家都来看看这个小问题，关于DataTimePicker和SQL结合

Question

string updatesql="update shuju set 时间='"+this.textBox1.Text+"',"
                  +"电压="+this.textBox2.Text+",电流="+this.textBox3.Text+","
                  +"水压="+this.textBox4.Text+",水位="+this.textBox5.Text+","
                  +"温度="+this.textBox6.Text+","
         +"湿度="+this.textBox7.Text+",气压="+this.textBox8.Text+","
                  +"海拔="+this.textBox9.Text+" "
+"where 井号="+this.comboBox3.Text+" and "
                  +"日期='"+this.dateTimePicker3.Value.ToShortDateString()+"'";
我要按日期和井号来更新一条记录，ACCESS数据库，日期字段为”日期/时间“格式的短日期，可运行程序后出错说我字段类型不匹配。
+"日期='"+this.dateTimePicker3.Value.ToShortDateString()+"'"应该写成什么？

Answer 1

access没用过，this.dateTimePicker3.Value.ToShortDateString()返回的是string的，你用this.dateTimePicker3.Value试试，或者根oracle似的，用to_date(this.dateTimePicker3.Value.ToShortDateString())

Answer 2

+"日期=#"+this.dateTimePicker3.Value.ToShortDateString()+"#"