0

Can someone please help me with this - it's driving me mad.

I have a very simple app (at the moment) that stores file names/paths and folder names/paths in an SQL database and displays them in a ListView and TreeView respectively. All fine and dandy.

I have an option to remove a file or folder from the appropriate database table and then recreate the associated list. The file update looks like this:

tbl_FilesAdapter.Delete(itemName, itemPath)
tbl_FilesAdapter.Update(Me.dtd_DataDataSet.tbl_Files)
Me.tbl_FilesTableAdapter.Fill(Me.dtd_DataDataSet.tbl_Files)

and it works perfectly. The folder update looks like this:

tbl_FolderAdapter.Delete(itemName, itemPath)
tbl_FolderAdapter.Update(Me.dtd_DataDataSet.tbl_Folders)
Me.Tbl_FoldersTableAdapter.Fill(Me.dtd_DataDataSet.tbl_Folders)

and utterly refuses to do anything.

I've checked and double checked the folder table adapter (even to the point of recreating it c/w Insert, Update and Delete commands) to no avail. Does anyone know why nothing is happening?

Thanks for looking,

Chris.

1
Contributor
1
Reply
2
Views
7 Years
Discussion Span
Last Post by Chris147
0

Ok, so I've deleted the whole folder bit (table, binding source, table adapter et al) and rebuilt it from the ground up.

It now works perfectly. Go figure. (must have been a dodgy bit of code somewhere.)

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.