Question

通过Winform界面向Oracle数据库插入数据，报错ORA-00947，没有足够的值，代码如下，哪里不对啊？

private void button3_Click(object sender, EventArgs e)
{
if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "")
{
MessageBox.Show("请输入完整的注册信息！", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
string connectionstring = "DATA SOURCE=DESKTOP-5M5KR9H:1521/RFID;USER ID=SYSTEM;Password=Poppy618";
OracleConnection con = new OracleConnection(connectionstring);
#pragma warning disable CS0618 // 类型或成员已过时
OracleCommand cmd = new OracleCommand("select * from ADMIN where ADMINNO='" + textBox1.Text + "' ", con);
#pragma warning restore CS0618 // 类型或成员已过时
con.Open();
cmd.Connection = con;
OracleDataReader odr = cmd.ExecuteReader();
odr.Read();
if (odr.HasRows)
{
MessageBox.Show("用户名已存在，请重新输入！", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
textBox1.Text = "";
}

else
{
try
{
string contstr = "DATA SOURCE=DESKTOP-5M5KR9H:1521/RFID;USER ID=SYSTEM;Password=Poppy618";
OracleConnection cons = new OracleConnection(contstr);
OracleCommand commd;
commd = new OracleCommand();
commd.Connection = cons;
cons.Open();
commd.CommandType = CommandType.Text;
commd.CommandText = "insert into ADMIN (ADMINNO,ADMINPW,ADMINID,ADMINNAME,ADMINSEX,ADMINTEL) values('" + textBox1.Text.Trim() + "', '" + textBox2.Text.Trim() + "'," +
"'" + textBox19.Text.Trim() + "','" + textBox18.Text.Trim() + "','" + comboBox15.Text.Trim() + "','" + textBox12.Text.Trim() + "')";
commd.ExecuteNonQuery();
textBox2.Text = textBox3.Text;
MessageBox.Show("注册成功，请登录!","成功", MessageBoxButtons.OK, MessageBoxIcon.Warning);
Form2 form2 = new Form2();
form2.Show();
this.Hide();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
con.Dispose();
}
}

Answer 1

看下表ADMIN 的表结构，看看是不是有必填字段漏insert了
请采纳！