Update webpage without page refresh when database is updated

Question

0.00/5 (No votes)

See more:

Dear friends,

i have come up with web application and here i have got some quires on it, i have a page which displays list of items in a gridview from database, when database is get added with some more items by another user, i want grid view in my page to get update with newly added itemslist without page refresh.please help out friends with solution.

Regards

Vivek

Posted 8-Jul-12 17:33pm

Vivek Shankar

Add a Solution

Comments

Ganesan Senthilvel 8-Jul-12 23:39pm

Without page refresh, need to think

Vivek Shankar 8-Jul-12 23:43pm

example like facebook,

2 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)

Sandeep Mewara · Answer 1 · 2012-07-08T17:48:00

when database is get added with some more items by another user, i want grid view in my page to get update with newly added itemslist without page refresh.
All the while you just said 'I want'. Did you try? Think of it's feasibility? Do you know how ASP.NET webpage works? Page life cycle?

1. Updating a page without refresh is not possible in general, partial rendering/update of a page is.
2. For a web scenario, updating a page automatically based on some other user activity makes less sense but may be required at times. Less sense as, we can only have PULL (data from DB) mechanism here and NOT PUSH (data from DB). Thus, polling every few seconds and checking if any new data is there is the only way - leading to unnecessary load on server.

Now, for this polling, you need to use AJAX. Either XMLHttpRequest or ASP.NET AJAX.
Put a timer control and set it to send request every few seconds (eg: 60 seconds). Based on the response received update the UI.

Try out and post specific issue.

Nimisha Mary John · Answer 2 · 2012-07-10T20:41:00

Solution 2

Add an Update panel And paste your gridview inside of it,Which will help to refresh the particular gridview instead of the whole page,
Then add a timer too,Inside Updatepanel;
Set timer interval ;
inside the timer_tick event,Add the code for filling gridview

Posted 10-Jul-12 20:41pm

Nimisha Mary John