DataBindingNavigator delete button deletes previous record than selected

Question

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

Kirtan Patel · 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 :)

Kirtan Patel · Answer

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; }

Dealy · Answer

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.

Kirtan Patel · Answer

friend  what do you mean by changing record ????after deleting ??

Dealy · Answer

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?

Kirtan Patel · Answer

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 kirtan007@gmail.com :) I will Quickly resolve your problem :) Thank you :)

Dealy · Answer

@ 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 Billa · Answer

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 Patel · Answer

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 ); }

Dealy · Answer

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 Patel · Answer

Hi Friend Can you Provide me the code you are using to delete a Record I will Provide you Correct code :)

Roei Bar · Answer

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

Dealy · Answer

Thanks for the answer but can you be more specific on how can i rebind the Navigator?

Roei Bar · Answer

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 ;-)