提交textbox中的内容到数据库,下面是提交button的代码
protected void Button2_Click(object sender, EventArgs e)
{
OracleConnection conn = new OracleConnection( "Data Source=caora;User ID=gufei;Password=gufei; ");
//在此构造你所需的Sql语句。
String strSql = "Insert into GUFEI.PRODUCTION(PRODUCTNO, PRODCODE,PUNIT,PRODNAME,PQUANTITY) values( ' " + TextBox1.Text + " ', ' " + TextBox2.Text + " ', ' " + TextBox3.Text + " ', ' " + TextBox4.Text + " ', ' " + TextBox5.Text + " ') ";
OracleCommand cmd = new OracleCommand(strSql, conn);
cmd.Connection.Open();
//通过SqlCommand对象执行Sql命令语句即可。
cmd.ExecuteNonQuery();
//cmd.Connection.Close();
点击提交后报错ORA-01400: 无法将 NULL 插入 ( "GUFEI ". "PRODUCTION ". "PRODUCTION_ID ")
PRODUCTION_ID是PK我知道不能为空,但是我textbox中的内容没它,我该怎么做呢
------解决方案--------------------------------------------------------
那你这个 PRODUCTION_ID 的值从哪里来呢？是个序列吗？
还有，楼主，你上一个帖子还没结
------解决方案--------------------------------------------------------
PRODUCTION_ID你要设置为自增字段，要不就PK为空
------解决方案--------------------------------------------------------
String strSql = "Insert into GUFEI.PRODUCTION(PRODUCTION_ID, PRODUCTNO, PRODCODE,PUNIT,PRODNAME,PQUANTITY) values(coalesce(production_id,0)+1, ' " + TextBox1.Text + " ', ' " + TextBox2.Text + " ', ' " + TextBox3.Text + " ', ' " + TextBox4.Text + " ', ' " + TextBox5.Text + " ') ";
------解决方案--------------------------------------------------------
写法错误
String strSql = "Insert into GUFEI.PRODUCTION(PRODUCTION_ID,UNITBASIC_ID, PRODUCTNO, PRODCODE,PUNIT,PRODNAME,PQUANTITY) values(nvl((select max(PRODUCTION_ID) from GUFEI.PRODUCTION), 1), nvl((select max(UNITBASIC_ID) from GUFEI.PRODUCTION), 1), ' " + TextBox1.Text + " ', ' " + TextBox2.Text + " ', ' " + TextBox3.Text + " ', ' " + TextBox4.Text + " ', ' " + TextBox5.Text + " ') ";