DataBindingNavigator delete button deletes previous record than selected

Dealy

Hello,

I have the code for deleting a record from a table through bindNavigator Delete button. My problem is when i click on delete button it deletes the previous record.

How can i delete the correct record?

Thank you

14 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kirtan Patel17y ago
Accepted answer
Hi Friend,

Problem Solved :)

I Changed The connection String ..in code to connect it with my server so change it :)

and One more thing when you delete record you need to first delete Sub Records of Order Table First :) may be it will
cause exception while deleting .

Problem was occurring because when we click on delete Button the Contex of dataBinding Moving to Previous DataRecord ..

but it was just logically deleted the Item But Not Physically deletes the Item

so i have captured the value in TextBox before it movies to previous Record Context.

Corrected Project Files(Updated..)

dont forget to mark "do you like this answer" please :)

0
Kirtan Patel17y ago
Just Add below code in

Cancel part of dialog box

else if (x == DialogResult.Cancel)
            {

                MessageBox.Show("Abort");

               //Added Code
                int z = itmBindNavigator.BindingSource.Position;
                button1.PerformClick();
                itmBindNavigator.BindingSource.Position = z+1;

            }
0
Dealy17y ago
In the example i sent you, when I click on delete automatically moves to next record before the Confirm Delete MessageBox, which it may be confusing for the users. They might think that they are deleting that record.
0
Kirtan Patel17y ago
friend ,
what do you mean by changing record ????after deleting ??
0
Dealy17y ago
Thanks now it works:)

One more question... is it possible to change record after the confirmation of delete, not as soon as the user clicks on delete?
0
Kirtan Patel17y ago
Friend,

Its Seems no Problem with code but if you can provide me Project Files then i could quickly resolve problem

I have Northwind Database please send me Only Project Files(zipped) at [email protected] :)

I will Quickly resolve your problem :)

Thank you :)

0

Dealy17y ago

@ Kirtan,

still having the same problem so i would appreciate if you could check my code. Here's the code for Nortwind example:

  private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("Delete?", "Confirm Delete", MessageBoxButtons.OKCancel) == DialogResult.OK)
            {
                string connectionString = @"Server=local; Initial Catalog=Northwind; Integrated Security=True";
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    SqlCommand command = new SqlCommand("DELETE_ORDER", conn);
                    command.CommandType = CommandType.StoredProcedure;

                    command.Parameters.AddWithValue("@OrderID", orderID_txt.Text);

                    conn.Open();
                    int rows = command.ExecuteNonQuery();
                    conn.Close();
                    if (rows > 0)
                        MessageBox.Show("Success");
                    else
                        MessageBox.Show("Failed");
                }
            }
            else
                MessageBox.Show("Abort");
        }

and here's the code for the Stored prcedure:

 CREATE PROCEDURE DELETE_ORDER
(@OrderID INT)
AS

DELETE 
FROM Orders
WHERE OrderID=@OrderID
GO

Thank you again.

Master Billa17y ago

Hi

You can use my code

private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("Sure you wanna delete?", "Warning", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes)
               bindingSource1.RemoveCurrent();
        }

thank you

Kirtan Patel17y ago
Try Bellow Corrected Code .:)

if Still Having Problem then you are having problem with your stored Procedure

if (MessageBox.Show("Are you sure you want;", "Confirm Deletion", MessageBoxButtons.OKCancel) == DialogResult.OK)
            {
                string connectionString = GetConnection();
                SqlConnection conn = new SqlConnection(connectionString);
                SqlCommand command = new SqlCommand("DELETE_COMMAND", conn);
                command.CommandType = CommandType.StoredProcedure;

                command.Parameters.AddWithValue("@C_IDENTITY", c_identity_txt.Text);

                conn.Open();
                int rows = command.ExecuteNonQuery();
                conn.Close();
                if (rows > 0)
                {
                    MessageBox.Show("Success");
                }
                else
                {
                    MessageBox.Show("Failure");
                }
            }
            else
            {
                MessageBox.Show("Cancelled");
            }
0

Dealy17y ago

   if (MessageBox.Show("Are you sure you want;", "Confirm Deletion", MessageBoxButtons.OKCancel) == DialogResult.OK)
            {
                string connectionString = GetConnection();
                SqlConnection conn = new SqlConnection(connectionString);
                SqlCommand command = new SqlCommand("DELETE_COMMAND", conn);
                command.CommandType = CommandType.StoredProcedure;
   
               command.Parameters.Add("@C_IDENTITY", SqlDbType.Int).Value = Convert.ToInt32(c_identity_txt.Text);

                conn.Open();
                int rows = command.ExecuteNonQuery();
                conn.Close();
                if (rows > 0)
                    MessageBox.Show("Success");
                else
                    MessageBox.Show("Failure");
            }
            else
                MessageBox.Show("Cancelled");

Kirtan Patel17y ago
Hi Friend

Can you Provide me the code you are using to delete a Record I will Provide you Correct code :)
0
Roei Bar17y ago
this.BindingSource1.DataSource = ds.Tables(0) this.DataGridView1.DataSource = this.BindingSource1 this.BindingNavigator1.BindingSource = this.BindingSource1
call this code every time you click on the delete button, when offcourse the ds is the return dataset from the db that you are performing to get the data
0
Dealy17y ago
Thanks for the answer but can you be more specific on how can i rebind the Navigator?
0
Roei Bar17y ago
it took me a minute but now i got the fault :-)
you delete one record and upon deleting the other you delete the prevoius
meaning you need to rebind the BindingNavigator ;-)

0