执行sql语句提示ORA-00933:sql语句未正确结束
云牧歌 2011-07-27 10:49:22 我在执行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;
}
}
高手们帮我看看、检查下。在线等消息··