表:STUDENT(NAME,SEX,SCORE)
存储过程:
CREATE OR REPLACE PROCEDURE SENYI.PRO_INSTU(NAME1 VARCHAR,SEX1 INT,SCORE1 NUMBER)
IS
BEGIN
INSERT INTO STUDENT VALUES(NAME1,SEX1,SCORE1);
END;
/
C#代码:
string str = System.Configuration.ConfigurationManager.ConnectionStrings["con"].ToString();
OracleConnection con = new OracleConnection(str);
OracleCommand cmd = new OracleCommand();
OracleParameter[] para = new OracleParameter[]{
new OracleParameter("NAME1",this.TextBox1.Text.Trim()),
new OracleParameter("SEX1",Convert.ToInt32(this.TextBox2.Text.Trim())),
new OracleParameter("SCORE1",Convert.ToDouble(this.TextBox3.Text.Trim()))
};
//OracleDataAdapter da = new OracleDataAdapter();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SENYI.PRO_INSTU";
cmd.Connection = con;
con.Open();
foreach (OracleParameter pa in para)
{
cmd.Parameters.Add(pa);
}
int flag =Convert.ToInt32(cmd.ExecuteNonQuery());
con.Close();
if (flag == 1)
{
this.Label1.Text = "成功!";
}
else
{
this.Label1.Text = "失败!";
}
--------------------------------
修改信息与插入信息差不多