Member Avatar for Chris147

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
  • 122 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Chris147
Member Avatar for Chris147

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.)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.