oracle - ORA-00936: missing expression. OleDbDException was unhandled by user code -
public partial class _editemp : system.web.ui.page { string connstr = webconfigurationmanager.connectionstrings["econn"].connectionstring; oledbconnection conn; protected void page_load(object sender, event,args e) { if (!ispostback) { if (!string.isnullorempty(context.request.querystring["emp_id"])) { emp_id.value = context.request.querystring["emp_id"]; lemp_id.text = emp_id.value; conn = new oledbconnection(connstr); conn.open(); oledbcommand mycommand = new oledbcommand("select * emp emp_id=@emp_id", conn); mycommand.commandtype = commandtype.text; oledbparameter pemp_id = new oledbparameter("@emp_id", oledbtype.varchar); pemp_id.value = context.request.querystring["emp_id"]; mycommand.parameters.add(pemp_id); oledbdatareader drname = mycommand.executereader(); if (drname.read() == true) { lemp_id.text = drname["emp_id"].tostring(); txt_fn.text = drname["first_name"].tostring(); txt_ln.text = drname["last_name"].tostring(); txt_dob.text = drname["dob"].tostring(); txt_address.text = drname["address"].tostring(); txt_pn.text = drname["phone_no"].tostring(); txt_email.text = drname["email"].tostring(); } drname.close(); conn.close(); } } }}}
Comments
Post a Comment