简单问题,请指教!如何在ASP.NET中调用Oracle中的存储过程,假设需要输入3个参数,输出1个参数,该如何写,最好有注释,我第一次学.NET!谢谢大

[zmpanda]

简单问题,请指教!如何在ASP.NET中调用Oracle中的存储过程,假设需要输入3个参数,输出1个参数,该如何写,最好有注释,我第一次学.NET!谢谢大家!

[zmpanda]

存储过程已经写好存在,大家帮忙,在线等!!

[radeonle]

up

[Y悠悠Y]

oleDbCommand1 = new OleDbCommand("myprocedure",oleDbConnection1);
oleDbCommand1.CommandType = CommandType.StoredProcedure;
//oleDbCommand1.Parameters.Add("CommandType",1);

oleDbCommand1.Parameters.Add("commandtype",OleDbType.Integer);

p_errorid = oleDbCommand1.Parameters.Add("ErrorID",OleDbType.Integer);
p_errormsg = oleDbCommand1.Parameters.Add("ErrorMsg",OleDbType.VarChar,30);
p_errorid.Direction = ParameterDirection.Output;
p_errormsg.Direction = ParameterDirection.Output;

oleDbConnection1.Open();
oleDbCommand1.ExecuteNonQuery();
Label1.Text = oleDbCommand1.Parameters["ErrorMsg"].Value.ToString();
oleDbConnection1.Close();