Clearing Access DB / DataGrid .Net 08

•

What is DaniWeb IT Discussion Community?

You're currently browsing the VB.NET section within the Software Development category of DaniWeb, a massive community of 423,092 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,362 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our VB.NET advertiser: Programming Forums

Thread Tools Display Modes

Views: 223 | Replies: 0

•

Join Date: May 2007

Posts: 35

Reputation: cellus205 is an unknown quantity at this point

Rep Power: 2

Solved Threads: 1

cellus205

Offline

Light Poster

Clearing Access DB / DataGrid .Net 08

Jul 8th, 2008

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:

Help with Code Tags

(Toggle Plain Text)

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.

Last edited by cellus205 : Jul 8th, 2008 at 1:53 pm.