Update multiple rows with 2 parameter in 1 column in sql server

Question

I have a problem with updating record. I want to update 2 record in 1 column in one button click with two parameters. this is the code :

private void Button_Click(object sender, EventArgs e)
    {
        int use = Convert.ToInt32(textBox1.Text);

        perintahsql = new SqlCeCommand("UPDATE Barang SET Pakai = @Pakai WHERE Nama_Barang = 'Mie Rebus' AND Nama_Barang = 'Telor'", koneksi);
        perintahsql.Parameters.Clear();
        perintahsql.Parameters.AddWithValue("@Pakai", use);
    }

How to overcome this problem? Thanks.

And what is your problem?

Jodrell
– Jodrell

2013-01-11 09:32:46 +00:00
Commented Jan 11, 2013 at 9:32 — Jodrell
– Jodrell, Commented Jan 11, 2013 at 9:32

Cristian Lupascu · Accepted Answer · 2013-01-11 09:30:43Z

2

Change your SQL statement to:

UPDATE Barang SET Pakai = @Pakai WHERE Nama_Barang in ('Mie Rebus', 'Telor')

answered Jan 11, 2013 at 9:30

Cristian Lupascu

40.8k18 gold badges107 silver badges139 bronze badges

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

Comments

Fiona - myaccessible.website · Accepted Answer · 2013-01-11 09:31:39Z

1

Your WHERE clause is looking for rows where Nama_Barang = 'Mie Rebus' AND Nama_Barang = 'Telor'

The key is the AND here. You don't have any rows where Nama_Barang is both 'Mie Rebus' and 'Telor'. You're looking for rows where Nama_Barang is either 'Mie Rebus' or 'Telor', so your WHERE clause should be Nama_Barang = 'Mie Rebus' OR Nama_Barang = 'Telor'

answered Jan 11, 2013 at 9:31

Fiona - myaccessible.website

15k17 gold badges85 silver badges118 bronze badges

Comments

Steve · Accepted Answer · 2013-01-11 09:34:19Z

0

You can do this by changing the AND to an OR operator in the WHERE clause.

private void Button_Click(object sender, EventArgs e)
{
    int use = Convert.ToInt32(textBox1.Text);

    perintahsql = new SqlCeCommand("UPDATE Barang SET Pakai = @Pakai WHERE Nama_Barang = 'Mie Rebus' OR Nama_Barang = 'Telor'", koneksi);
    perintahsql.Parameters.Clear();
    perintahsql.Parameters.AddWithValue("@Pakai", use);
}

However, if you're going to be doing this for many values then its probably best to use

WHERE Nama_Barang IN ('name1','name2', ... ,'name99')

answered Jan 11, 2013 at 9:34

Steve

3,7011 gold badge21 silver badges24 bronze badges

Collectives™ on Stack Overflow

Update multiple rows with 2 parameter in 1 column in sql server

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related