问题是：：未处理System.Data.OleDb.OleDbException   HResult=-2147217900   Message=语法错误 (操作符丢失) 在查询表达式 '2014/12/1 0:00:00' 中。


public void add(string addselect)
        {
            oledbconn = dataconn.getcon();
            oledbconn.Open();
            OleDbCommand cmd = new OleDbCommand(addselect, oledbconn);
          int x = (int)cmd.ExecuteNonQuery();
            if (x > 0)
            {
                MessageBox.Show("添加信息成功！");
            }
            oledbconn.Close();

      
        }



 private void button1_Click(object sender, EventArgs e)
        {
            if (textBox1.Text == "" || textBox2.Text == "")
                MessageBox.Show("登记编号或姓名不能为空！");
            else
            {
                string st1 = dateTimePicker1.Value.Date.ToString();
                string inSQL = String.Format("insert into dingfang(登记编号,姓名,性别,身份证号,联系方式,房间类型,房间号,入住天数,登记日期) values({0},{1},{2},{3},{4},{5},{6},{7},{8})", textBox1.Text, textBox2.Text, comboBox3.Text, textBox3.Text, textBox4.Text, comboBox1.Text, comboBox2.Text, textBox5.Text, st1);
               
                dataoperate.add(inSQL);
                dataoperate.SaveImage(textBox1.Text.Trim(), openFileDialog1);
            }
        }

[ 本帖最后由 zhu404424118 于 2014-12-1 19:45 编辑 ]

string inSQL = String.Format("insert into dingfang(登记编号,姓名,性别,身份证号,联系方式,房间类型,房间号,入住天数,登记日期) values({0},{1},{2},{3},{4},{5},{6},{7},{8})", textBox1.Text, textBox2.Text, comboBox3.Text, textBox3.Text, textBox4.Text, comboBox1.Text, comboBox2.Text, textBox5.Text, st1);
你写的这句有问题啊！在那个帖子中已经回复，是你的''号用的不对。

嗯，明白，谢了