Incorrect syntax near ( SQL Update command)

Question

Seems a simple syntax error but need help.

protected void editback_Click(object sender, EventArgs e)
{
    String EditStoryID = DropDownList3.SelectedItem.Value;
    String EditProjectID = DropDownList1.SelectedItem.Value;
    String EditRequirement = TextBoxBacklog.Text;
    String EditLock = "0";

    String connectionString = WebConfigurationManager.ConnectionStrings["ScrumString"].ConnectionString;
    SqlConnection myConnection = new SqlConnection(connectionString);


    myConnection.Open();
    String query = "UPDATE product_backlog SET (project_id=@project_id,user_story=@user_story,is_locked=@is_locked) WHERE project_backlog.id = (@id)";

    SqlCommand commandEdit = new SqlCommand(query, myConnection);
    commandEdit.Parameters.AddWithValue("@project_id", EditProjectID);
    commandEdit.Parameters.AddWithValue("@id", EditStoryID);
    commandEdit.Parameters.AddWithValue("@user_story", EditRequirement);
    commandEdit.Parameters.AddWithValue("@is_locked", EditLock);

    commandEdit.ExecuteNonQuery();

    Page.Response.Redirect(Page.Request.Url.ToString(), true);

    Labelsuccess.Text = "User story has been updated";
    TextBoxBacklog.Text = "";
}

in your query try removing ( and ) in the set and also around @id — shurik
– shurik, Commented Nov 5, 2015 at 22:55

Gordon Linoff · Accepted Answer · 2015-11-05 22:54:44Z

1

The set clause should not be surrounded by parentheses:

UPDATE product_backlog
    SET project_id = @project_id,
        user_story = @user_story,
        is_locked = @is_locked
   WHERE project_backlog.id = (@id);

answered Nov 5, 2015 at 22:54

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Comments

Bergerova · Accepted Answer · 2015-11-05 23:04:12Z

0

You must remove the parentheses after the SET statement. They are excepted after the WHERE statement but the SET must be without, even if you have more than 1 field you want to update

UPDATE your_table SET key=@value WHERE id = (@id)

answered Nov 5, 2015 at 23:04

Bergerova

9033 gold badges10 silver badges21 bronze badges

Collectives™ on Stack Overflow

Incorrect syntax near ( SQL Update command)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related