System.Data.SqlClient.SqlException on multiple WHERE query

Question

I am using my quo_custname that is bind in my dropdownlist and use its value to Insert my data.So whenever I choose a value on my dropdownlist quo_name change but whenever I use my class for mysql Insertion.

I get this error Additional information: Incorrect syntax near the keyword 'WHERE'.

Here is my code:

 private void AddToQuotation()
    {
        con.Open();
        cmd = new SqlCommand(@"INSERT INTO JobQuotations
                            (quo_disount,quo_unitPrice,quo_TotalAmount,quo_finishing)
                             VALUES
                            ('@discount','@unitPrice','@totalAmount'
                            ,'@finishing')
                            WHERE quo_custname = '@customername'
                            AND quo_verified = 'no'",con);

        cmd.Parameters.AddWithValue("@customername",DropDownList3.SelectedItem.Value.ToString());
        cmd.Parameters.AddWithValue("@discount",txtDisc.Text);
        cmd.Parameters.AddWithValue("@unitPrice",txtUnitPrice.Text);
        cmd.Parameters.AddWithValue("@totalAmount",lblTotalAmount.Text);
        cmd.ExecuteNonQuery();
        con.Close();
        string script = "alert(\"Functioning!\");";

        ScriptManager.RegisterStartupScript(this, GetType(),
            "ServerControlScript", script, true);
    }

*Bonus question also how could I using try and catch so that it wouldn't break my program and get the SqlException name and the Additional information in my script to popup a message.

write your parameters @customername instead of '@customername' otherwise they will be recognized as string — fubo
– fubo, Commented May 10, 2016 at 9:40

Patrick Hofman · Accepted Answer · 2016-05-10 09:46:25Z

3

Your statement doesn't make much sense to me. You are mixing insert into select syntax with insert into values syntax. Also, you are using quotes around your parameters, which won't work (they are interpreted as literals now).

Are you sure you didn't mean to update?

update JobQuotations
set    quo_disount     = @discount
,      quo_unitPrice   = @unitPrice
,      quo_TotalAmount = @totalAmount
,      quo_finishing   = @finishing
where  quo_custname    = @customername
and    quo_verified    = 'no'

edited May 10, 2016 at 9:46

answered May 10, 2016 at 9:40

Patrick Hofman

158k23 gold badges270 silver badges343 bronze badges

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

4 Comments

rai nalasa Over a year ago

No I'm not updating.

Patrick Hofman Over a year ago

So what is the purpose of the where then?

rai nalasa Over a year ago

I am trying to insert this sqldata in my null columns.Their initial value was Null.Example : totalAmount is null so I need to insert value on it in order to have its price after I calculated it.

Patrick Hofman Over a year ago

So that is an update right? The columns were null, so there is a row.

Spikolynn · Accepted Answer · 2016-05-10 09:34:27Z

0

It seems you are making an insert statement while also specifying a WHERE condition. SQL inserts typically do not use WHERE conditions so you probably want to remove that part.

answered May 10, 2016 at 9:34

Spikolynn

4,1932 gold badges40 silver badges49 bronze badges

Comments

Akram Khan · Accepted Answer · 2016-05-10 09:50:06Z

0

for this use update query that you have record in database.

answered May 10, 2016 at 9:50

Akram Khan

1248 bronze badges

1 Comment

Patrick Hofman Over a year ago

There was already a comprehensive answer that goes into detail. No need for this comment.

Patrick Hofman · Accepted Answer · 2016-05-10 10:05:15Z

0

You are using a WHERE clause in an INSERT statement, it will not work because we can't use a where clause with an INSERT statement. Either you have to use :

INSERT INTO JobQuotations(quo_disount,quo_unitPrice,quo_TotalAmount,quo_finishing)
                  VALUES('@discount','@unitPrice','@totalAmount','@finishing')

or

UPDATE statement (if you want to use WHERE).

edited May 10, 2016 at 10:05

Patrick Hofman

158k23 gold badges270 silver badges343 bronze badges

answered May 10, 2016 at 9:57

R C

4714 silver badges17 bronze badges

Collectives™ on Stack Overflow

System.Data.SqlClient.SqlException on multiple WHERE query

4 Answers 4

4 Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related