Need to refresh datagridview when SQL server changes

Question

0.00/5 (No votes)

See more:

I have a VB.Net application that I created for my job. It runs on multiple users PC's and uses Access databases for data storage, with a timer to refresh the DataGridView every 5 minutes to keep everyone up-to-date. Now I'm switching over to SQL Server Express 2014 and I've heard that it has triggers that flag changes. What I'm wanting to know is if I can use these, instead of timers, to trigger an update to the DataGridView whenever something is changed in the SQL Server table? Any VB.Net or SQL code examples would be greatly appreciated. Thanks for any help!

What I have tried:

Have tried Google searches for SQL Server triggers, but nothing made sense.

Posted 15-Apr-16 7:03am

WolfmanLee

Updated 15-Apr-16 9:02am

Add a Solution

2 solutions

Solution 1

I'm going to say it is probably not possible. Sql server triggers fire when something is inserted, updated, or deleted, but that is not exposable through anything that would talk to your vb project. The only think I could suggest is to have a rowguid and a modified date on each table, and on a timer, go check the rowguid. If it is different, then reload your data, being careful to not overwrite changes the local user has made.

If multiple users are in an access database(using only access forms and grids), then somehow(magically) changes from one user show up in the others forms and grids. I have not seen anything so magical for ado.net. Please correct me if I'm wrong.

Posted 15-Apr-16 8:38am

Member 10425001

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mathi Mani · Accepted Answer · 2016-04-15T09:02:00

There are ways to track data changes in SQL Server, in the form of Change Data Capture and Change Tracking. You can read about them. But the solution you are looking for may be achieved using SqlDependency. There are a couple of articles in CP that explain how to use this for getting notification about changes.

It may not be exactly what you are looking for, but may help you go in the right direction.

Using SqlDependency for data change events[^]
Query Notification using SqlDependency and SqlCacheDependency[^]