Syntax error in INSERT INTO statement Error

Question

I have a database connected successfully by "OLEDB" connection. I've used one table for the sign up form and it worked perfectly and then I used the other table with another form, but with the same code, with the differences that are needed, yet I keep getting this error:

Syntax error in INSERT INTO statement.

The error is for this part of the code:

{
    string sqlpost2 = "insert into postqr(Professor,Title,Body)";
    sqlpost2 += "value('" + postname + "','" + posttitle + "','" + postbody + "')";
    DBFunction.ChangeTable(sqlpost2, "DBS.accdb");
}

This is all of the code used in that page:

protected void Button9_Click(object sender, EventArgs e)
{
    string postname = this.Postuser.Text;
    string postpass = this.Postpass.Text;
    string posttitle = this.TOP.Text;
    string postbody = this.BOP.Text;
    string sqlstr2 = "select * from professors WHERE pname='" + postname + "' AND ppass='" + postpass + "'";

    DataTable dt1 = DBFunction.SelectFromTable(sqlstr2, "DBS.accdb");

    if (dt1.Rows.Count > 0)
    {
        string sqlpost2 = "insert into postqr(Professor,Title,Body)";
        sqlpost2 += "values('" + postname + "','" + posttitle + "','" + postbody + "')";
        DBFunction.ChangeTable(sqlpost2, "DBS.accdb");
    }
    else
        this.Label1.Text = "Posting on this wall is only allowed for professors and it seems that you're not one";          

    DataList1.DataBind();
}

it doesn't work for me you should post that code so you can get the help you badly need. For this, check the spaces and spelling — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented Apr 6, 2019 at 19:48
You can find an example of OleDbParameter use here learn.microsoft.com/en-us/dotnet/api/… — Steve
– Steve, Commented Apr 6, 2019 at 19:56

Athii · Accepted Answer · 2019-04-06 20:21:47Z

1

in your SQL code try to put a space before the SQL Keyword VALUES

answered Apr 6, 2019 at 20:21

Athii

6698 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

Syntax error in INSERT INTO statement Error

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