- String or = ConfigurationManager.ConnectionStrings["conn"].ToString();
- OracleConnection oc = new OracleConnection(or);
- oc.Open();
- OracleCommand om = oc.CreateCommand();
- om.CommandType = CommandType.StoredProcedure;
- om.CommandText = "proc2";
- om.Parameters.Add("v_id", OracleType.Number).Direction = ParameterDirection.Input;
- om.Parameters["v_id"].Value = this.TextBox2.Text.Trim();
- om.Parameters.Add("v_name", OracleType.NVarChar).Direction = ParameterDirection.Input;
- om.Parameters["v_name"].Value = this.TextBox3.Text.Trim();
- om.ExecuteNonQuery();
- oc.Close();
来源: http://www.bubuko.com/infodetail-1973921.html