Database update error

I'm trying to write a questionnaire that gathers info of the user and then updates a database in Access. I've managed to write the program and everything works up to the point where it updates the database, at which point it displays the error message below:

OleDbException was unhandled
Syntax error in INSERT INTO statement

I've checked it and I can't find any syntax errors in it. Could someone help me out please? I'm very new to programming, so please try to explain in as simple terms as possible. The section of code is below. Thanks for your help.

if (Found == "F")
{
if (txtPasswordInput.Text == txtConfirmPassword.Text)
{
DataRow drNewRow = m_dtLoginTable.NewRow(); //creates variable
drNewRow["Username"] = txtUsernameInput.Text;
drNewRow["Password"] = txtPasswordInput.Text;
m_dtLoginTable.Rows.Add(drNewRow);
m_dtDataAdapter.Update(m_dtLoginTable); database
m_rowPosition = m_dtLoginTable.Rows.Count - 1;
new record
}
else
{
txtError.Text = "Passwords do not match";
}

}

4 Replies

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

Bechir Bejaoui18y ago
But my dear freind, the above code doesn't illustrate the insert task
+1
harika m18y ago
hi frnd,

jst paste ur insert statement so that we can resolve ur probs
+1
Ryan Alford18y ago
how are we suppose to see what the problem is with the update statement if you don't post it?
+1
Bechir Bejaoui18y ago
Could you please send the entire code
+1