Delete query not working in c#.net

Question

        private void btnDelete_Click(object sender, EventArgs e)
    {

      //dataGridView1.Rows.RemoveAt(dataGridView1.CurrentRow.Index);

        OleDbConnection con = new OleDbConnection(constr);
        con.Open();

        OleDbCommand cmd = new OleDbCommand("DELETE FROM tb1 WHERE name='@Name'", con);
        cmd.Parameters.AddWithValue("@Name", txtproject_name.Text);


        cmd.ExecuteNonQuery();

        Bind();

        MessageBox.Show("deleted......");
        con.Close();
        }

This is my code for deleting the data from a database on a button click...but it is not deleting anything..can anyone help me with the code

Is your WHERE clause correct? I.e., are there any rows in the table that match txtproject_name.Text? — Tim
– Tim, Commented Jan 13, 2014 at 7:11
Another thought - try DELETE FROM tb1 WHERE name=@Name for your SQL. In other words, remove the single quotes - I believe AddWithValue will put them in for you. — Tim
– Tim, Commented Jan 13, 2014 at 7:12

Sergey Berezovskiy · Accepted Answer · 2014-01-13 07:12:26Z

6

Remove quotes around parameter:

"DELETE FROM tb1 WHERE name=@Name"

answered Jan 13, 2014 at 7:12

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

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

4 Comments

Sergey Berezovskiy Over a year ago

@user3181292 yep, you should use just parameter name. Value of appropriate type (nvarchar, int, etc) will be passed to database and parameter will be replaced with constant value of appropriate type. E.g. if you are passing string "Bob", then @Name will have value 'Bob'

user3181292 Over a year ago

i have one more problem could you please help me out/?

Sergey Berezovskiy Over a year ago

@user3181292 if that problem is not related to current question, then it probably better to start another question (that might help other people who will have same problem in future)

Sergey Berezovskiy Over a year ago

@user3181292 if you are using parameter names without any quotes, then you have another problem, and I suggest you to ask new question for that, somebody will answer you :)

Vignesh Kumar A · Accepted Answer · 2014-01-13 07:13:34Z

0

Try this

   private void btnDelete_Click(object sender, EventArgs e)
    {

      //dataGridView1.Rows.RemoveAt(dataGridView1.CurrentRow.Index);

        OleDbConnection con = new OleDbConnection(constr);
        con.Open();

        OleDbCommand cmd = new OleDbCommand("DELETE FROM tb1 WHERE name=@Name", con);
        cmd.Parameters.AddWithValue("@Name", txtproject_name.Text);


        cmd.ExecuteNonQuery();

        Bind();

        MessageBox.Show("deleted......");
        con.Close();
        }

answered Jan 13, 2014 at 7:13

Vignesh Kumar A

28.6k14 gold badges67 silver badges119 bronze badges

Comments

Conejo Perez · Accepted Answer · 2014-01-13 07:14:38Z

0

Try without the 2 ['] around @Name

answered Jan 13, 2014 at 7:14

Conejo Perez

241 bronze badge

Collectives™ on Stack Overflow

Delete query not working in c#.net

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related