Timer is not working to retrieve data from database after 1000 intervalit was working fine before just today it is not workingplease have a lookBelow is my code lt Page Title3434 Language34C34 MasterPageFile34MasterPageMaster34 AutoEventWireup34true34 CodeBehind34DashBoardaspxcs34 Inherits34AppprdDashBoard34 gtltaspContent ID34Content134 ContentPlaceHolderID34head34 runat34server34gtltaspContentgtltaspCon

HiakhterYou might be binding the gridviews inside the not IsPostBackconditionSo either you need to bind outside the not IsPostBack or inside the Timer1Tick event rebind the GridViewCheck the below exampleHTMLlth4gtampnbsp ltaspTextBox ID34txtitempbstart34 Visible34false34 runat34server34 TextMode34Date34gtltaspTextBoxgt ampnbsp ltaspTextBox ID34txtitempbend34 runat34server34 Visible34false34 TextMode34Date34gtltaspTextBoxgt ltaspTextBox ID34txtstart34 runat34server34 Visible34false34 TextMode34Date34gtltaspTextBoxgt ampnbsp ltaspTextBox ID34txtend34 Visible34false34 runat34server34 TextMode34Date34gtltaspTextBoxgtlth4gtltaspScriptManager ID34ScriptManager134 runat34server34 gtltaspTimer ID34Timer134 runat34server34 Interval34100034 OnTick34Timer

[Solved] ASP.Net AJAX Timer not refreshing GridView data after some interval

akhter

SOLVED CLOSED ACTIVE ANSWERED
User: akhter
Posted: on Dec 15, 2020 05:16 AM
Forum: Data Controls
Answer: 1
Views: 1302
Sample Code: Download

Timer is not working to retrieve data from database after 1000 interval

it was working fine before, just today it is not working

please have a look

Below is my code

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.Master" AutoEventWireup="true" CodeBehind="DashBoard.aspx.cs" Inherits="Appprd.DashBoard" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <h4>&nbsp;
        <asp:TextBox ID="txtitempbstart" visible="false" runat="server" TextMode="Date"></asp:TextBox>&nbsp;
        <asp:TextBox ID="txtitempbend" runat="server"  visible="false" TextMode="Date"></asp:TextBox>
        <asp:TextBox ID="txtstart" runat="server" visible="false"  TextMode="Date"></asp:TextBox>&nbsp;
        <asp:TextBox ID="txtend" visible="false"  runat ="server" TextMode="Date"></asp:TextBox>
    </h4>             
    <asp:ScriptManager ID="ScriptManager1" runat="server" />
    <asp:Timer ID="Timer1" runat="server" Interval="1000"></asp:Timer>
    <div>
        <asp:UpdatePanel ID="Panel1" runat="server" UpdateMode="Conditional">
            <ContentTemplate>          
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :
                <asp:Label ID="lbFFloor" visible="false"  runat="server" BackColor="#FF9966" BorderColor="#00FF99" BorderWidth="0px" Font-Bold="True" Font-Size="XX-Large" Height="0px" Text="." Width="0px"></asp:Label>    
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
                <asp:Label ID="SFloor" runat="server" visible="false" BackColor="#FF9966" BorderColor="#00FF99" BorderWidth="0px" Font-Bold="True" Font-Size="XX-Large" Height="0px" Text="." Width="0px"></asp:Label>
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br /><br />
                Section Wise Total Smal Bale&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Section Wise Total Big Bale&nbsp;&nbsp; </p>
                <table class="auto-style1">
                     <tr>
                         <td class="auto-style2">&nbsp;</td>
                         <td>
                             <table class="auto-style1">
                                 <tr>
                                     <td class="auto-style6">&nbsp;&nbsp;QTY :
                                         <asp:Label ID="lbitemtotal" runat="server" BackColor="#FF9966" BorderColor="#00FF99" BorderWidth="0px" Font-Bold="True" Font-Size="large" Height="0px" Text="." Width="0px"></asp:Label>
                                         &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Weight :<asp:Label ID="lbweightsb" runat="server" BackColor="#FF9966" BorderColor="#00FF99" BorderWidth="0px" CssClass="auto-style4" Font-Bold="True" Font-Size="large" Height="0px" Text="." Width="0px"></asp:Label>
                                         &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Per(%):<asp:Label ID="lbSBP" runat="server" BackColor="#FF9966" BorderColor="#00FF99" BorderWidth="0px" CssClass="auto-style5" Font-Bold="True" Font-Size="large" Height="0px" Text="." Width="0px"></asp:Label>
                                         &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
                                     <td class="auto-style7">QTY :
                                         <asp:Label ID="Lbtotalbig" runat="server" BackColor="#FF9966" BorderColor="#00FF99" BorderWidth="0px" Font-Bold="True" Font-Size="Large" Height="0px" Text="." Width="0px"></asp:Label>
                                         &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Weight:<asp:Label ID="lbweightbb" runat="server" BackColor="#FF9966" BorderColor="#00FF99" BorderWidth="0px" Font-Bold="True" Font-Size="Large" Height="0px" Text="." Width="0px"></asp:Label>
                                         &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Per(%)
                                         <asp:Label ID="lbbbp" runat="server" BackColor="#FF9966" BorderColor="#00FF99" BorderWidth="0px" Font-Bold="True" Font-Size="Large" Height="0px" Text="." Width="0px"></asp:Label>
                                     </td>
                                     <td>Rags Issuance</td>
                                     <td>&nbsp;</td>
                                 </tr>
                                 <tr>
                                     <td class="auto-style6" rowspan="2">
                                         <asp:GridView ID="GVSectotal" runat="server" AutoGenerateColumns="true" Height="3px" Width="417px">
                                             <RowStyle BackColor="#EFF3FB" />
                                             <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                                             <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                                             <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                                             <AlternatingRowStyle BackColor="White" />
                                         </asp:GridView>
                                     </td>
                                     <td class="auto-style7" rowspan="2">
                                         <asp:GridView ID="GVBigbale" runat="server" AutoGenerateColumns="true" Height="3px" Width="417px">
                                             <RowStyle BackColor="#EFF3FB" />
                                             <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                                             <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                                             <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                                             <AlternatingRowStyle BackColor="White" />
                                         </asp:GridView>
                                     </td>
                                     <td class="auto-style9">
                                         <asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" Height="172px">
                                             <AlternatingRowStyle BackColor="White" />
                                             <EditRowStyle BackColor="#2461BF" />
                                             <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                                             <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                                             <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                                             <RowStyle BackColor="#EFF3FB" />
                                             <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                                             <SortedAscendingCellStyle BackColor="#F5F7FB" />
                                             <SortedAscendingHeaderStyle BackColor="#6D95E1" />
                                             <SortedDescendingCellStyle BackColor="#E9EBEF" />
                                             <SortedDescendingHeaderStyle BackColor="#4870BE" />
                                         </asp:GridView>
                                     </td>
                                     <td rowspan="2">&nbsp;</td>
                                 </tr>
                                 <tr>
                                     <td class="auto-style8">&nbsp;</td>
                                 </tr>
                             </table>
                         </td>
                     </tr>                    
                     <caption>
                     </caption>
                </table>  
            </ContentTemplate>
            <Triggers>
                <asp:AsyncPostBackTrigger ControlID="Timer1" />
            </Triggers>
        </asp:UpdatePanel>
    </div>
</asp:Content>

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 6

Reply
ANSWER
User: dharmendr
Replied: on Dec 16, 2020 04:42 AM
Report

Hiakhter,

You might be binding the gridviews inside the not IsPostBackcondition.

So either you need to bind outside the not IsPostBack or inside the Timer1_Tick event rebind the GridView.

Check the below example.

HTML

<h4>&nbsp;
    <asp:TextBox ID="txtitempbstart" Visible="false" runat="server" TextMode="Date"></asp:TextBox>
    &nbsp;
    <asp:TextBox ID="txtitempbend" runat="server" Visible="false" TextMode="Date"></asp:TextBox>
    <asp:TextBox ID="txtstart" runat="server" Visible="false" TextMode="Date"></asp:TextBox>
    &nbsp;
    <asp:TextBox ID="txtend" Visible="false" runat="server" TextMode="Date"></asp:TextBox>
</h4>
<asp:ScriptManager ID="ScriptManager1" runat="server" />
<asp:Timer ID="Timer1" runat="server" Interval="1000" OnTick="Timer1_Tick"></asp:Timer>
<div>
    <asp:UpdatePanel ID="Panel1" runat="server" UpdateMode="Conditional">
        <ContentTemplate>
            <asp:Label ID="lblTime" runat="server" />
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :
            <asp:Label ID="lbFFloor" Visible="false" runat="server" BackColor="#FF9966" BorderColor="#00FF99" BorderWidth="0px" Font-Bold="True" Font-Size="XX-Large" Height="0px" Text="." Width="0px">
            </asp:Label>
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <asp:Label ID="SFloor" runat="server" Visible="false" BackColor="#FF9966" BorderColor="#00FF99" BorderWidth="0px" Font-Bold="True" Font-Size="XX-Large" Height="0px" Text="." Width="0px"></asp:Label>
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <br />
            <br />
            Section Wise Total Smal Bale&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Section Wise Total Big Bale&nbsp;&nbsp; </p>
            <table class="auto-style1">
                <tr>
                    <td class="auto-style2">&nbsp;</td>
                    <td>
                        <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" AutoGenerateColumns="false">
                            <Columns>
                                <asp:BoundField DataField="CustomerId" HeaderText="Customer Id" />
                                <asp:BoundField DataField="ContactName" HeaderText="Contact Name" />
                                <asp:BoundField DataField="Country" HeaderText="Country" />
                            </Columns>
                        </asp:GridView>
                        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:constr %>"
                            SelectCommand="SELECT TOP 5 * FROM Customers ORDER BY NEWID()"></asp:SqlDataSource>
                    </td>
                </tr>
                <caption>
                </caption>
            </table>
        </ContentTemplate>
        <Triggers>
            <asp:AsyncPostBackTrigger ControlID="Timer1" />
        </Triggers>
    </asp:UpdatePanel>
</div>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</p>

Code

protected void Page_Load(object sender, EventArgs e)
{
    lblTime.Text = "Last Refreshed: " + DateTime.Now.ToString();
    if (!IsPostBack)
    {
        GridView1.DataBind();
    }
}

protected void Timer1_Tick(object sender, EventArgs e)
{
    // Re-bind the GridView to refresh the data.
    GridView1.DataBind();
}

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

[Solved] ASP.Net AJAX Timer not refreshing GridView data after some interval

Company

Explore

Follow us

Contact Us