Thursday, July 21, 2011

Reload Gridview Data regularly without any page postback.

First, create a web-application using Visual-Studio 2005 or later.
(Note: For visual-studio 2005, we’ll have to make this web-application ajax enabled by selecting“Asp .Net Ajax-Enabled Web-site” Template.Do note that in case of visual studio 2008, it has an in-built support for ajax, so there is no need to specify anything extra.)
Now, in Design-Mode,
Add “Timer” and “Update-Panel” controls from “Ajax Extensions” tab of Toolbox. Set Interval for the Timer (suppose 10 sec).
Add the GridView control inside the Update-Panel Control.
Now set “UpdateMode” property of Update-Panel to “Conditional“.
And set Timer as Trigger Control for Update-Panel and select “Tick” as event-name
Now, in the page_load(), Bind data to gridview.
Run the application, do any changes in database table, and u’ll find, the gridview data will be refreshed regularly at each time-interval specified(10 secondswithout any page-postback.
 Sample Code:
<form id=”form1″ runat=”server”>
<br />
      <asp:ScriptManager ID=”ScriptManager1″ runat=”server” />
<asp:Timer ID=”Timer1″ runat=”server” Interval=”10000″ >
     <asp:UpdatePanel ID=”UpdatePanel1″ UpdateMode=”Conditional” runat=”server”>
          <%– UpdateMode for Update Panel is set Conditional as it will update it’s content based upon condition  –%>
         <Triggers><%– Triggers contains the list of events that will force update panel to update it’s content asynchronously–%>
              <%– Tick event of timer1 has been selected as Triggering event for asynchronous updation of update panel data which will be executed at each time-interval(10 seconds) specified –%>
  <asp:AsyncPostBackTrigger ControlID=”Timer1″ EventName=”Tick” />
                        <asp:DataGrid ID=”grvDemo” runat=”server” Width=”100%” GridLines=”Both” HeaderStyle-BackColor=”AntiqueWhite” AutoGenerateColumns=”true”>
 In Page_Load() write,
//Definition of BindGrid()
//Definition of BindGrid()
public void BindGrid()
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = “select * from Table1 order by 1″;
cmd.Connection = con;
SqlDataReader dr = cmd.ExecuteReader();
grvDemo.DataSource = dr;


Post a Comment


Web Design Company karimnagar, Web Designing warangal, Logo Design Company nizamabad, Indian Website Design Company,