In my app, I have a WebListBox which shows accounts and descriptions. To edit an item in the list, I click a button and a WebDialogBox opens which is populated with the proper data. But when I change the data and update the database (MySQL) the WebListBox showing the selected account/line is not refreshed.
I have looked through comments here and found discussions from a couple years ago but they do not seem to be updated as some of the properties are no longer available…like listbox.Cell(,) for example.
You can probably envision what I am trying to do. It’s pretty basic. I am thinking that someone has accomplished this already so, any help would be greatly appreciated!
Oh, you can probably guess… adding and deleting accounts is next on my to-do list so any thoughts on making WebListBox lines appear and disappear would be great!
Are you saying that updating the WebListbox cell is not displaying or are you expecting it to automatically update? The later does not happen, you must update the cell yourself.
I am trying to update the WebListBox cells myself but, they are not refreshing. I have the current row index stored (currow) and that seems to be accurate.
Here was my problem. I was pulling initial values from the database rowset, showing the edit screen, replacing the database values with what was on screen and updating the weblistbox with the rowset value again … well, you know that just isn’t going to work.
Thanks again! The example you provided was clear and helpful.
I am trying to do almost the same thing and is not working for me. I am displaying a Weblistbox and when I doubleclick on a row, I am deleting that row from a SQLlite database. I then empty the weblistbox and reload but I don’t see the change on the screen until I get out of that page and go back to it or manually refresh the page. Any way to refresh that page after I delete the row?
not the answer to your question, but IMHO double clic to delete something is not very user friendly… and can make mistakes easy too.
you should clic to multi select the items, then a button to delete, and a confirm message before deleting.
So how are you handling the removal of the actual database table record? I used DELETE FROM… and executed the proper SQL in my project. There are other ways, but this might be an issue.
If I can only figure out how to prevent the Weblistbox from not displaying the contents after a while. I thought it was because it was running as a service on a windows 10 machine but even if I just run the executable, the weblistbox stops working after a while where I have to close the server app and recall it.
Hi Guys,
I just want to throw this at you to see if anyone have had that problem with the Weblistbox where they stop loading the data. When it happens, I need to restart the service.
Before restarting service: