Auto Refresh Result From sql DB

Question

1.00/5 (1 vote)

See more:

hi guys
i wanna show latest result from a SQL table ,so i have to get records that updated,Inserted and deleted records then update my datagrid view.
how can i get the changed records frequentlly?
in my case ,timer wouldn't answer me.

Posted 9-Feb-11 23:29pm

IT-discovery

Add a Solution

3 solutions

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)

Abhinav S · Answer 1 · 2011-02-09T23:35:00

Solution 1

You need to implement some sort of notification service that updates the client once data is changed.

Maybe Notification Services[^] can help you get to a solution.

Posted 9-Feb-11 23:35pm

Abhinav S

Eduard Keilholz · Answer 2 · 2011-02-09T23:37:00

Why won't a time answer your question?

If you create a trigger on the modified database table and set a datetime field indicating the latest database changes and have a timer monitoring that datetime, you'll be able to 'find' the changed records.

You may also want to use an async timer (System.Threading.Timer) to 'poll' the database for changes and raise an event when a change is found.

Good luck,

Eduard

IT-discovery · Answer 3 · 2011-02-11T17:18:00

thanks Abhinav S and thanks Eduard
let me explain what i'm looking for:
suppose,i have a table with following fields:

Name | Price
____________
A | 200
B | 100
C | 300
.
.
.

1-it have more than 10000 records.
2-the records always changing their data.

the problem is the way for changing the output on UI(for example DataGridView).

i have to get only the updated records ,then update them on the UI.(not to update all my UI(DataGridView))
hope it clear because of my poor english :)

Auto Refresh Result From sql DB

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0