Error parsing query from C# program to SQL Server CE

Question

I need to update the details in a certain row of my SQL Server CE database as the user wants requires to. But I get an error

There was an error parsing the query.[Token line number=1,Token line offset=31,Token in error=Name]

My query is:

"Update MembersTable set First Name='" + txtFirstName.Text +
    "', Surname='" + txtSurname.Text + 
    "', Middle Name='" + txtMiddleName.Text +
    "',Home Address='" + txtAddress.Text +
    "',Date Of Birth='" + dtpDOB.Text + 
    "',Home Phone No='" + txtHomePhone.Text +
    "',Mobile No='" + txtMobilePhone.Text + 
    "',Email='" + txtEmail.Text +
    "',Profession='" + txtProfession.Text + 
    "',Cell Leaders Name='" + txtCellLeader.Text +
    "' Where ID='" + DC.ID + "'";"

What am I doing wrong??

SQL Injection alert - you should not concatenate together your SQL statements - use parametrized queries instead to avoid SQL injection — marc_s
– marc_s, Commented Mar 2, 2015 at 11:35

cbr · Accepted Answer · 2015-03-02 11:23:08Z

1

It appears like your column names contain spaces. To deal with this, you'd want to enclose the column name with square brackets [ ]

"Update MembersTable set [First Name]='" + txtFirstName.Text + "',Surname='" + txtSurname.Text + "',[Middle Name]='" // ...

edited Mar 2, 2015 at 11:23

answered Mar 2, 2015 at 11:12

cbr

13.8k3 gold badges43 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error parsing query from C# program to SQL Server CE

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related