I've been tinkering with vb.net to MySQL for some small work project and have a small issue I'm not sure how to resolve.
I have a datagridview that loads on form load using this code:
I also have a some textboxes that fill when I click in the datagridview with this code:
In order to fill the textboxes using this I had to make the variable DBSET from LoadTable() a global variable.
My update and save buttons work, and the info is saved or updated but each function calls the LoadTable() to refresh the grid afterwards. When it does, I get duplicates of the table. If I make DBSET local to the LoadTable() sub it seems to work fine, but I can't filter.
Can you folks give me some tips on what I should look at?