Problem solve Get help with specific problems with your technologies, process and projects.

Troubleshooting SQL table/VB interface update issues

I'm using SQL tables tied to VB interfaces. I have two interfaces with a datagrid on one. When I enter information on one form it goes into my SQL tables and the datagrid on the first page. When I go to the second page, the updated information simply isn't there. Obviously, I'm getting the updates into my database but why is it not updating my second interface when it updates my first interface?
You're probably binding the datagrids to DataSets. It's important to understand that DataSets are disconnected from the datasource. Once you filled them though a DataAdapter, the connection is closed. If you want updated data, you will have to use DataAdapter.Fill() again. There's no magic live-data there: the application must go to the database and get the newer data, that's it.

Dig Deeper on Win Development Resources

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.