Q

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 first published in October 2004

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchCloudComputing

SearchSoftwareQuality

SearchSOA

TheServerSide

SearchCloudApplications

Close