I am new at this and need help with what I hope is a simple question. I have a C# app that needs to insert records into an Oracle db. The code I have runs without error but does not actually insert a record. Here is my code so far.
string eEmpID = tbEmpID.Text;
string eFName = tbFName.Text;
string eLName = tbLName.Text;
string eEmail = tbEmail.Text;
string ePhone = tbPhone.Text;
string eHireDate = " ";
string eJobID = ddlJobID.SelectedValue;
string eGrade = ddlGrade.SelectedValue;
using (OracleConnection con = new OracleConnection(Configura
tion.oConn
))
{
con.Open();
string oCMD = "insert into RANDRAPP.EMPLOYEES(EMPLOYE
E_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID, SALARY, MANAGER_ID, DEPT_ID, TIME_REMAINING) VALUES (eEmpID, eFName, eLName, eEmail, ePhone, eHire_Date, eJobID, eGrade)";
OracleCommand cmd = new OracleCommand(oCMD, con);
}
Start Free Trial
