How to update grid when values in database changes

Question

0.00/5 (No votes)

See more:

I am developing a windows application using c# as front end and SQL server 2005 as back end.

I have grid which shows values from database. My task is to update values in grid if and only if values in database changes.

I have tried thread, sqlDependency and signalR though it is for ASP.NET. I have also studied observer design pattern but i didn't understand exactly what id does, I have also tried event notification and service broker

In both the case grid keeps refreshing which is not desired. Is there any way to solve my problem?

Posted 10-Sep-13 20:39pm

Sandeep_Gosavi

Add a Solution

Comments

Anurag Sinha V 11-Sep-13 2:55am

How is your DB getting updated?
Is it manual or via a job or something?

Sandeep_Gosavi 11-Sep-13 3:00am

it will be updated by manually and through same application but on remote machine

Anurag Sinha V 11-Sep-13 4:25am

Then my friend you can try something like below:
have the update statements in a batch, put them in a stored procedure and have a variable act as a flag. I mean to say, when all the updates are successfully executed, set the flag variable as 'Success' or anything else.
In your UI code, check the flag value and then retrieve the updated data set from the Db and bind your gridview.
Its just an idea, I know you will have your questions, but keep this as a reference and try to build something with the above idea in mind.

-Anurag

Sandeep_Gosavi 11-Sep-13 5:36am

yes i will definitely try this too. Thanks

1 solution

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)

Salman622 · Answer 1 · 2013-09-10T20:50:00

Solution 1

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.rowupdating.aspx#Y456[^]

http://www.c-sharpcorner.com/Forums/Thread/40936/[^]

http://devilswork.wordpress.com/2009/03/27/gridview-row-edit-delete-and-update/[^]

Posted 10-Sep-13 20:50pm

Salman622

Updated 10-Sep-13 21:04pm

v2

Comments

Sandeep_Gosavi 11-Sep-13 3:09am

My requirement is to update grid automatically upon changes made in database. It is easy to reload dataset and attach to grid again but how to monitor changes in database.