C# UPDATE 语句



if (comboBox7.Text == "" | comboBox6.Text == "" | textBox8.Text == "" | comboBox8.Text == "" | comboBox9.Text == "")
            {
                MessageBox.Show("请输入完整的数据！");
            }
            else
            {
                try
                {
                    pub.getcon();
                    object oid = dataGridView2.SelectedRows[0].Cells[0].Value;
                    string str1 = "update 宿舍信息表 set 区域 = '" + comboBox6.Text.Trim() + "',层级='" + comboBox7.Text.Trim() + "',宿舍号='" + textBox8.Text.Trim() + "',满员人数='" + comboBox8.Text.Trim() + "',寝别='" + comboBox9.Text + "',备注='" + textBox9.Text.Trim() + "' where ID =" + oid;
                    OleDbCommand cmd1 = new OleDbCommand(str1, pub.oledb_conn);
                    cmd1.ExecuteNonQuery();
                    MessageBox.Show("更新记录成功");
                   
                }
                catch (Exception ex1)
                {
                    MessageBox.Show(ex1.Message);
                }
                finally
                {
                    //不管增加记录成功与否  还原相关组件状态
                    string wninit = "select * from 宿舍信息表 ";
                    xxxs(wninit);
                    pub.con_close();

                }
            }
        }