datagrid

[Guest]

Hi guys

I want to e able to delete rows from a datagrid and the same rows must be
deleted from the datasource of the datagrid. I have a buon that removes a row
based on a field value that is listed in a list box. here is te code:
Dim tbl As New DataTable("DATAdemo")
tbl = Me.DataSet1.Tables(0)
Dim a As Integer

For a = 0 To ListBox1.Items.Count
tbl.Rows.RemoveAt([a])
Me.OleDbDataAdapter1.Update(tbl)
Me.Refresh()
ListBox1.Items.Clear()
Next

Can somebody modify my code to accomplish my mission?
Thanx

 

[Cor Ligthert [MVP]]

BeGentle,

Your problem is that you removes the row, which means that it is removed
from the table. In the update there is no information anymore to remove it
from the database. For this case the delete would be used.

http://msdn2.microsoft.com/en-us/library/system.data.datarow.delete.aspx

I hope this helps,

Cor