Hows it going everyone. I am having trouble clearing the data in an access DB that I am using in my program. I have two DataGrids and each have a table from my access DB bound to them. Im not having any trouble adding the data to them, but the problem comes when I try to actually clear an item. For the clear button, which is supposed to clear the Datagrid/DB, the code for each clear button is basically the following:
Table1TableAdapter.Connection.Open()
TestdbDataSet.Table1.Rows.Clear()
Table1TableAdapter.Update(TestdbDataSet.Table1)
Table1TableAdapter.Connection.Close()This actually clears the DataGrid, but when I go to the Access Database then the data is still in the tables. Seems like it would be a pretty simple fix, but its got me pretty stumped. Any help would be greatly appreciated.