Auto refresh without timer

ShindeAR

Hello Friends, I have one query,If i use a multi-user system in that on main page there is a dashboard consider it as a grid in that grid value of xyz table is displayed. As it is a multiuser system in that data can be inserted in that xyz table, if any user inserts data in the xyz table as soon as the user inserts the data the changes gets automatically reflected in main page dashboard. Just like mail systems of gmail and all.

PiyushBha

GridView Auto Refresh In this tutorial i will let you know how to auto refresh or update GridView using AJAX Timer and UpdatePanel in asp.net. In this it is described that how a GridView is update after a specific time set in timer control.

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</form>

</body>
</html>

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{

protected void Page\_Load(object sender, EventArgs e)
{

}
protected void Timer1\_Tick(object sender, EventArgs e)
{
    databind();
    update.Text = " Gridview Was Last Updated at " + DateTime.Now;
}

public void databind()
{
    string strcon = ConfigurationManager.ConnectionStrings\["con"\].ConnectionString;
    SqlConnection conn = new SqlConnection(strcon);
    conn.Open();
    string str = "select \* from dept";
    SqlCommand cmd = new SqlCommand(str, conn);
    SqlDataAdapter da = new SqlDataAdapter(cmd);
    DataTable dt = new DataTable();
    da.Fill(dt);
    GridView1.DataSource = dt;
    GridView1.

Lost User

This sounds like a possible application for Microsofts SignalR (very nice product, without using a timer). http://signalr.net/[^] www.styletech.co.uk

Avik Ghosh22

protected void Page_Load(object sender, EventArgs e)
{
string sss = "xxx";
Response.AppendHeader("Refresh", "2");
if (!IsPostBack)
{
// Response.Write(sss);

//GRIDVIEW CODE

}