asp.net insert query

Michael Mount

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Michael Mount12y ago
When I add a breakpoint, the query shows as

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

never looks like any values are passed to the parameters.
Bhabani Prasad12y ago
u just put a debug point and see the value is coming or not
Michael Mount12y ago
Still doesn't insert. No errors are being thrown and everything I see looks like it should work, it just doesn't. Thanks for helping though.
Bhabani Prasad12y ago
u mst welcome if its helpful plz mark as answer
Michael Mount12y ago
I'm sorry, all of my parameters are initialized. I can't copy and paste because I'm working from Virtualbox on another machine, so I just posted the code giving me the issue. I forgot to post the code where thdey are initialized. Thanks though.
Bhabani Prasad12y ago
Hi Michael i just go through your code.its well but you need to specify StrEmployeeId=txtempid.Text(whatever it may be your textbox name of emp id)like this all the parameter should be initialized first then it will sure insert your data