Click here to Skip to main content
       

ASP.NET

 
GeneralRe: Application_Error not called for SqlException PinmvpSandeep Mewara11-Feb-13 20:55 
GeneralRe: Application_Error not called for SqlException Pinmember«_Superman_»11-Feb-13 23:25 
GeneralRe: Application_Error not called for SqlException Pinmember«_Superman_»12-Feb-13 0:19 
GeneralRe: Application_Error not called for SqlException PinmvpSandeep Mewara12-Feb-13 4:13 
GeneralRe: Application_Error not called for SqlException Pinmember«_Superman_»15-Feb-13 1:28 
GeneralRe: Application_Error not called for SqlException PinmvpSandeep Mewara15-Feb-13 10:23 
QuestionAuto refresh without timer PinmemberShindeAR7-Feb-13 19:02 
AnswerRe: Auto refresh without timer PinmemberPiyushBha7-Feb-13 20:33 
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">
 
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>
    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
    <ContentTemplate>
        <asp:Timer ID="Timer1" Interval="10000" runat="server" ontick="Timer1_Tick">
        </asp:Timer>
     <div>
        <asp:GridView ID="GridView1" runat="server">
        </asp:GridView>
    </div>
        <asp:Label ID="update" runat="server" Text="Label"></asp:Label>
    </ContentTemplate>
    </asp:UpdatePanel>
 
    </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.DataBind();
 

    }
}

AnswerRe: Auto refresh without timer PingroupStyleTech Solutions Ltd9-Feb-13 4:10 
AnswerRe: Auto refresh without timer PinmemberAvik Ghosh2212-Feb-13 0:49 
Questionconnect the e-signature pad with crystal report and get sign Pinmemberpremaa_36@yahoo.co.in6-Feb-13 23:58 
QuestionEmail validation against database Pinmembersonal12346-Feb-13 19:18 
AnswerRe: Email validation against database PinmvpRahul Rajat Singh6-Feb-13 22:59 
AnswerRe: Email validation against database PinmemberAnkur\m/7-Feb-13 2:50 
QuestionValidation of viewstate MAC failed for ASP.NET 4.0 application PinmemberMember 98165276-Feb-13 12:24 
AnswerRe: Validation of viewstate MAC failed for ASP.NET 4.0 application PinmentorKeith Barrow6-Feb-13 13:33 
AnswerRe: Validation of viewstate MAC failed for ASP.NET 4.0 application Pinmemberkarthickpradhaban11-Feb-13 5:46 
GeneralRe: Validation of viewstate MAC failed for ASP.NET 4.0 application Pinmembersmehta.er12-Feb-13 7:28 
GeneralRe: Validation of viewstate MAC failed for ASP.NET 4.0 application Pinmemberkarthickpradhaban13-Feb-13 6:24 
GeneralRe: Validation of viewstate MAC failed for ASP.NET 4.0 application Pinmembersmehta.er13-Feb-13 6:44 
GeneralRe: Validation of viewstate MAC failed for ASP.NET 4.0 application Pinmemberkarthickpradhaban13-Feb-13 6:45 
GeneralRe: Validation of viewstate MAC failed for ASP.NET 4.0 application Pinmembersmehta.er14-Feb-13 8:10 
GeneralRe: Validation of viewstate MAC failed for ASP.NET 4.0 application Pinmemberkarthickpradhaban7-Mar-13 6:27 
QuestionDynamic width DIV next to a static width DIV Pinmemberjojoba20116-Feb-13 1:31 
AnswerRe: Dynamic width DIV next to a static width DIV PinmentorKeith Barrow6-Feb-13 13:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.141223.1 | Last Updated 26 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid