protected void Button4_Click(object sender, EventArgs e)
{
OracleConnection conn = new OracleConnection("Data Source=caora;User ID=gufei;Password=gufei;");
//在此构造你所需的Sql语句。
String strSql = "Insert into GUFEI.ENERGY(ENERGY_ID,UNITBASIC_ID, SOFTCOAL, NSOFTCOAL,MIXCOAL,FUELCOKE,FUELOIL,NATUGAS,MARSHGAS,COALGAS,BIOFUEL,OILCOKE,LPG,STEAM,ELECTRICITY,ELSENERGY,WAST,OTHERAMOUNT,SOURCE1,SOURCE2,SOURCE3,SOURCE4,SOURCE5,SOURCE6,SOURCE7,SOURCE8,SOURCE9,SOURCE10,SOURCE11,SOURCE12,SOURCE13,SOURCE14,SOURCE15,EXPLAIN) values(nvl((select max(ENERGY_ID) from GUFEI.ENERGY)+1, 1), nvl((select max(UNITBASIC_ID) from GUFEI.ENERGY)+1, 1),'" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" + TextBox8.Text + "','" + TextBox9.Text + "','" + TextBox10.Text + "','" + TextBox11.Text + "','" + TextBox12.Text + "','" + TextBox13.Text + "','" + TextBox14.Text + "','" + TextBox15.Text + "','" + TextBox16.Text + "','" + TextBox17.Text + "','" + TextBox18.Text + "','" + TextBox19.Text + "','" + TextBox20.Text + "','" + TextBox21.Text + "','" + TextBox22.Text + "','" + TextBox23.Text + "','" + TextBox24.Text + "','" + TextBox25.Text + "','" + TextBox26.Text + "','" + TextBox27.Text + "','" + TextBox28.Text + "','" + TextBox29.Text + "','" + TextBox30.Text + "','" + TextBox31.Text + "','"+TextBox32.Text+"')";
//Response.Write(strSql);
//Response.End();
OracleCommand cmd = new OracleCommand(strSql, conn);
cmd.Connection.Open();
//通过SqlCommand对象执行Sql命令语句即可。
cmd.ExecuteNonQuery();
}
第1个红色字段是主键,所以要+1,第2个不用+1,+1是因为它自增长的