How To Refresh Asp.Net Gridview Automatically

In this tutorial i will let you know how to auto refresh or update GridView using AJAX Timer and UpdatePanel in asp.net, How To Refresh Asp.Net Gridview Automatically. In this it is described that how a GridView is update after a specific time set in timer control. In this Example we describes How To Auto Refresh Or Update GridView Automatically At Regular Interval In Asp.Net Using Ajax And Timer.

In earlier post we have discussed Upload Multiple Files in Asp.Net.

How To Refresh Asp.Net Gridview Automatically Design View:-

01<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
02 
03<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
04 
05<html xmlns="http://www.w3.org/1999/xhtml">
06<head runat="server">
07    <title></title>
08</head>
09<body>
10    <form id="form1" runat="server">
11    <asp:ScriptManager ID="ScriptManager1" runat="server">
12    </asp:ScriptManager>
13    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
14    <ContentTemplate>
15        <asp:Timer ID="Timer1" Interval="10000" runat="server" ontick="Timer1_Tick">
16        </asp:Timer>
17     <div>
18        <asp:GridView ID="GridView1" runat="server">
19        </asp:GridView>
20    </div>
21        <asp:Label ID="update" runat="server" Text="Label"></asp:Label>
22    </ContentTemplate>
23    </asp:UpdatePanel>
24    
25    </form>
26</body>
27</html>

How To Refresh Asp.Net Gridview Automatically Code:

01using System;
02using System.Collections.Generic;
03using System.Data;
04using System.Data.SqlClient;
05using System.Configuration;
06using System.Web;
07using System.Web.UI;
08using System.Web.UI.WebControls;
09 
10public partial class _Default : System.Web.UI.Page
11{
12 
13    protected void Page_Load(object sender, EventArgs e)
14    {
15 
16    }
17    protected void Timer1_Tick(object sender, EventArgs e)
18    {
19        databind();
20        update.Text = " Gridview Was Last Updated at " + DateTime.Now;
21    }
22 
23    public void databind()
24    {
25        string strcon = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
26        SqlConnection conn = new SqlConnection(strcon);
27        conn.Open();
28        string str = "select * from dept";
29        SqlCommand cmd = new SqlCommand(str, conn);
30        SqlDataAdapter da = new SqlDataAdapter(cmd);
31        DataTable dt = new DataTable();
32        da.Fill(dt);
33        GridView1.DataSource = dt;
34        GridView1.DataBind();
35 
36 
37    }
38}