代码
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
sqlcon = new OracleConnection(strCon);
string sqlstr = "update crm.terminal_ticket_instance set end_date='" + "to_date('" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.Trim() + "','YYYY-MM-DD')" + "' where ticket_instance_code='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
sqlcom = new OracleCommand(sqlstr, sqlcon);
sqlcon.Open();
sqlcom.ExecuteNonQuery();
sqlcon.Close();
GridView1.EditIndex = -1;
bind(); }
报错:
ORA-00933: SQL 命令未正确结束说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.OracleClient.OracleException: ORA-00933: SQL 命令未正确结束
源错误:
行 50: sqlcom = new OracleCommand(sqlstr, sqlcon);
行 51: sqlcon.Open();
行 52: sqlcom.ExecuteNonQuery();
行 53: sqlcon.Close();
行 54: //InstInfo(GridView1.DataKeys[e.RowIndex].Value.ToString());
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
sqlcon = new OracleConnection(strCon);
string sqlstr = "update crm.terminal_ticket_instance set end_date='" + "to_date('" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.Trim() + "','YYYY-MM-DD')" + "' where ticket_instance_code='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
sqlcom = new OracleCommand(sqlstr, sqlcon);
sqlcon.Open();
sqlcom.ExecuteNonQuery();
sqlcon.Close();
GridView1.EditIndex = -1;
bind(); }
报错:
ORA-00933: SQL 命令未正确结束说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.OracleClient.OracleException: ORA-00933: SQL 命令未正确结束
源错误:
行 50: sqlcom = new OracleCommand(sqlstr, sqlcon);
行 51: sqlcon.Open();
行 52: sqlcom.ExecuteNonQuery();
行 53: sqlcon.Close();
行 54: //InstInfo(GridView1.DataKeys[e.RowIndex].Value.ToString());
http://www.mybuffet.cn