CREATEORREPLACEPROCEDURE CMS.PR_INSERTDM ( ptaskid varchar2, proleid integer, pmembername varchar2 ) IS BEGIN insertinto dutymember(taskid,ROLEID,membername) values(ptaskid,proleid,pmembername); EXCEPTION WHEN NO_DATA_FOUND THEN NULL; WHEN OTHERS THEN RAISE; END PR_INSERTDM;
using System; using System.Data; using System.Data.OleDb; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.IO; using System.Drawing; using System.Reflection; using System.Runtime.InteropServices; using Microsoft.Office.Interop.Excel; using System.Data.Common; using Microsoft.Practices.EnterpriseLibrary.Common; using Microsoft.Practices.EnterpriseLibrary.Configuration; using Microsoft.Practices.EnterpriseLibrary.Data; publicpartialclass TaskAdministration_test : System.Web.UI.Page ...{ protectedvoid Page_Load(object sender, EventArgs e) ...{ } protectedvoid Button1_Click(object sender, EventArgs e) ...{ ExcelOperation OEM =new ExcelOperation(); Database db = DatabaseFactory.CreateDatabase(); DbConnection tconn = db.CreateConnection(); DbCommand cmd = tconn.CreateCommand(); cmd.CommandText ="PR_INSERTDM"; cmd.CommandType = CommandType.StoredProcedure; OEM.AddInParameter(cmd, "ptaskid",txt1.Text); OEM.AddInParameter(cmd, "proleid", txt2.Text); OEM.AddInParameter(cmd, "pmembername", txt3.Text); tconn.Open(); cmd.ExecuteNonQuery(); tconn.Close(); } }