6
Answers

asp.net insert query

Michael Mount

Michael Mount

10y
770
1
I am trying to insert into an access database and cannot get it to add any records. I've been working on this problem for days and cannot get it to work. Here's my code.

Oledbconnection constring = new Oledbconnection(Connection String Here");

string strInsertEmployee = "Insert into tblEmployees(EmployeeID, EmployeeFirstName, EmployeeLastName, EmployeePhoneNumber, EmployeeVanNumber, EmployeeMeterNumber, EmployeeTabletNumber, EmployeePassword, EmployeeActive)Values(@EmployeeID, @
EmployeeFirstName, @EmployeeLastName, @EmployeePhoneNumber, @EmployeeVanNumber, @EmployeeMeterNumber, @EmployeeTabletNumber, @EmployeePassword, @EmployeeActive);

OledbCommand cmdInsertEmployee = new oledbcommand(strInsertEmployee, constring);

cmdInsertEmployee.Parameters.AddWithValue("@EmployeeID", Convert.Tostring(strEmployeeID));
cmdInsertEmployee.Parameters.AddWithValue("@EmployeeFirstName", strEmployeeFirstName);
cmdInsertEmployee.Parameters.AddWithValue("@EmployeeLastName", strEmployeeLastName);
cmdInsertEmployee.Parameters.AddWithValue("@EmployeePhoneNumber", Convert.Tostring( strEmployeePhoneNumber));
cmdInsertEmployee.Parameters.AddWithValue("@EmployeeVanNumber", strEmployeeVanNumber);
cmdInsertEmployee.Parameters.AddWithValue("@EmployeeMeterNumber", strEmployeeMeterNumber);
cmdInsertEmployee.Parameters.AddWithValue("@EmployeeTabletNumber", strEmployeeTabletNumber);
cmdInsertEmployee.Parameters.AddWithValue("@EmployeePassword", strEmployeePassword);
cmdInsertEmployee.Parameters.AddWithValue("@EmployeeActive", strEmployeeActive);

cmdInsertEmployee.Connection = constring;
constring.open();
cmdInsertEmployee.executeNonQuery();
constring.Close();

I know my connectionstring is good because I have a select statement that returns records, but I just can't get this to insert.

Thanks
Answers (6)