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.
This was last published in October 2004

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.