我在执行sql语句的时候提示ORA-00933:sql语句未正确结束。代码如下“
protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                MainID.Value = Request.QueryString["REAGENTID"];
                //Response.Write(MainID.Value);
                if (string.IsNullOrEmpty(MainID.Value))
                    MainID.Value = "0";                SQLBase h = new SQLBase();
                DBParameterCollection pc = new DBParameterCollection();
                pc.Add(pcPageParams.GetDBParameter("id"));
                DataTable dt = h.ExecuteDataTable("SELECT * FROM SJ_INFORMATION Where REAGENTID = :id", pc);
                
                //将查询到的数据填充到输入控件中
                pcPageParams.SetValue(dt);
                if (string.IsNullOrEmpty(MainID.Value))
                    MainID.Value = "0";
            }
            msg.Value = "";
        }        protected void save_Click(object sender, EventArgs e)
        {
            SQLBase sb = new SQLBase();
            sb.Begin(true);
            try
            {
                string sql = "";                if (MainID.Value == "0")
                {
                    sql = @"insert into SJ_INFORMATION(REAGENTNAME,REAGENTNAMEPYM,REAGENTSPEC,NOTUSE,REAGENTTXM,MANUFACTURER,UPSTOCKPILE,LOWSTOCKPILE,PASSNUMBER,EFFECTIVEDATE)VALUES('" + REAGENTNAME.Text + "','" + REAGENTNAMEPYM.Text + "','" + REAGENTSPEC.Text + "','" + NOTUSE.Text + "','" + REAGENTTXM.Text + "','" + MANUFACTURER.Text + "','" + UPSTOCKPILE.Text + "','" + LOWSTOCKPILE.Text + "','" + PASSNUMBER.Text + "','" + EFFECTIVEDATE.Text + "')";                    MainID.Value = PubGlobal.GetPrimaryID(sb, "SJ_INFORMATION").ToString();
                }
                else
                {
                    sql = @"UPDATE SJ_INFORMATION SET REAGENTNAME ='" + REAGENTNAME.Text + "', REAGENTNAMEPYM = '" + REAGENTNAMEPYM.Text + "', REAGENTSPEC = '" + REAGENTSPEC.Text + "', NOTUSE = '" + NOTUSE.Text + "', REAGENTTXM = '" + REAGENTTXM.Text + "', MANUFACTURER = '" + MANUFACTURER.Text + "' UPSTOCKPILE = '" + UPSTOCKPILE.Text + "', LOWSTOCKPILE = '" + LOWSTOCKPILE.Text + "', PASSNUMBER = '" + PASSNUMBER.Text + "',EFFECTIVEDATE ='" + EFFECTIVEDATE.Text + "' where REAGENTID ='"+ MainID .Value +"'";
                }                DBParameterCollection pc = new DBParameterCollection();                sb.ExecuteNonQuery(sql, pc);                sb.Commit();                msg.Value = "OK";                Response.Redirect("ReagentInformationlist.aspx");
            }
            catch
            {
                sb.Rollback();
                throw;
            }
        }高手们帮我看看、检查下。在线等消息··