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

Popular posts from this blog

php - failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request -

java - How to filter a backspace keyboard input -

java - Show Soft Keyboard when EditText Appears -