Problem in Reload a GridView using Timer

udhayav · December 16th, 2006, 07:16 AM

Hi,

I am new to ASP.net. I have a problem; I need to reload a gridview for every five seconds. So, I am using a timer control. In the timerconrol_elapsed event, I am getting the datasource from the database and binding it into the gridview. The problem is, the retrieved data from th database is not displaying in the gridview. Here is my code,

Default.aspx:

<%@ 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">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
<atlas:ScriptManager EnablePartialRendering="true" ID="UpdateManager" runat="server"></atlas:ScriptManager>
    <form id="form1" runat="server">
    <div>

    <atlas:UpdatePanel ID="upCityPanel" runat="server" Mode="Conditional">
        <ContentTemplate>
            <asp:GridView ID="GrdCity" runat="server" PageSize="5"></asp:GridView>
        </ContentTemplate>
        <Triggers>
            <atlas:ControlEventTrigger ControlID="btn" EventName="Click" />
        </Triggers>
    </atlas:UpdatePanel>
    <asp:Button runat="server" ID="btnReload" Text="Click to Reload" OnClick="ReloadGrid" />
    </div>
    </form>
</body>
</html>

Default.aspx.cs:

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Timers;

public partial class _Default : System.Web.UI.Page
{
    SqlConnection conn = new SqlConnection("server=localhost/;database=new;user id=sa;password=;");

    protected void Page_Load(object sender, EventArgs e)
    {
        Timer timer = new Timer();
        timer.Enabled = true;
        timer.Interval = 5000;
        timer.Elapsed += new ElapsedEventHandler(timer_Elapsed);
    }

    void timer_Elapsed(object sender, ElapsedEventArgs e)
    {
        ReloadGrid(this, EventArgs.Empty);
    }

    protected void ReloadGrid(object sender, EventArgs e)
    {
        SqlDataAdapter da = new SqlDataAdapter("select distinct(city) from authors", conn);
        DataTable dt = new DataTable();
        if (dt != null)
        da.Fill(dt);
        GrdCity.DataSource = dt;
        GrdCity.DataBind();
    }

}

Can anyone tell me what should I need to do? for getting the proper output.

Thanks in advance.

Udhaya