[RESOLVED] Delete BindingSource

[hepeci]

Hello!

I have one simple question.

What's the code for deleting one row from Database using BindingSource and DataSet? Just like from BindingNavigator.

I tried with

BindingSource.RemoveCurrent

But computer doesn't remove CURRENT date, but first or last date. Help. Thanks.

[dkahn]

You can remove it by index like this:

BindingSource.RemoveAt(m_index)

That way you know you're removing the row that you want.

[hepeci]

What's the index? Can you describe better? Thanks!

[dkahn]

If your table has 5 rows, then the first row is index 0, the second row is index 1 and so on. What are you using to display your data? You should be able to use a SelectedIndex property to get the index of the selected item.

[hepeci]

I have one listbox with dates which are in one database. And I want to remove row from selected item from ListBox. How to?

[dkahn]

You should be able to do this:

Dim m_index as Integer
m_index=Listbox1.SelectedIndex
BindingSource.RemoveAt(m_index)

That would remove the selected listbox item from the binding source. You would then need to apply an Update method to save the changes.

[hepeci]

It gives me Error:

Index -1 is either negative or above rows count.

I just copied your code.

[dkahn]

That was meant as an example, I doubt you could just copy and paste that into your application. Index = -1 means the index your looking for wasn't found. Can you post your code? Then I or someone else can help you better.

[hepeci]

I just copied your code

[dkahn]

I just copied your code

I see, sorry about the paste. You can also get index = -1 if no item was selected in the listbox when you execute that code.

[jmcilhinney]

Calling RemoveCurrent on the BindingSource will delete the currently selected record. Is that what you want? If so then that's what you do. If not then RemoveAt will delete the record at a specific index. Instead of asking us what index, you tell us. You must know what record you want to delete. How do you identify it? That will tell you how to get the index.

Note that, either way, that's only going to delete the record locally. You still have to use a TableAdapter or DataAdapter to Update the database with the changes from the DataTable. You would normally use the same TableAdapter or DataAdapter that you used to Fill your DataTable in the first place.

Don't just blindly copy and paste code. Read it, think about what it does and then write your own code that implements the same principle but in a way that's appropriate for your app. If you don't understand what it does then do some reading or ask a question.

[hepeci]

Yes, I tried with

Me.BindingSource.RemoveCurrent

And everything is OK when I navigate with buttons from BindingNavigator (previous, next, first, last) but if I use this code:

        Me.BindingSource.Position = Me.BindingSource.Find("Column from DataBase", ListBox.SelectedItem)

Then, when I click on some item in ListBox, program navigates good, BUT when I click remove with code:

Me.BindingSource.RemoveCurrent

Program removes first date. What's the problem?

[jmcilhinney]

RemoveCurrent removes the current item, plain and simple. If the first date is removed then that's the current item. I can't tell you more because the information you've provided is insufficient to determine how your app works and is supposed to work.

[hepeci]

No!

I said you, when I use this code for finding dates:

        Me.BindingSource.Position = Me.BindingSource.Find("Name", ListBox.SelectedItem)

And when I press button with code:

Me.BindingSource.RemoveCurrent

Program removes first item.

And when I navigate to item I want with BindingNavigator and then I press button remove, everything is OK, program removes item that's current.

[hepeci]

RESOLVED!

When you click on remove button, just enable Timer and Timer tick code you write listbox.clear, and then again you load dates in listbox and timer1.enabled = false.