What i trying to do is, i just want to refresh the certain content in the page, i dont want to refresh the whole page. I using update panel + timer to refresh one of the content. Bt i fail to do so, it will refresh whole page instead small part.
Below are the code, can someone guide me with this problem.
Imports System.Data
Imports MySql.Data
Imports MySql.Data.MySqlClient
Partial Class Default2
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Label5.Text = DateTime.Now.ToLongTimeString
End Sub
Protected Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs)
lbl1.Text = "Updated at: " + DateTime.Now.ToLongTimeString()
GetChamber()
End Sub
Private Function GetChamber() As Boolean
Dim myConnection As New MySqlConnection
Dim lCmd As New MySqlCommand
Dim lRd As MySqlDataReader
Dim lsCmd As String = Nothing
Dim lTx As MySqlTransaction
myConnection = New MySqlConnection("server=localhost; user id=root; password=; database=te; pooling=false;")
Try
'open connection
myConnection.Open()
lCmd.Connection = myConnection
'Link the transaction
lTx = myConnection.BeginTransaction
lCmd.Transaction = lTx
'check whether chamber end_time is null or gt value
lsCmd = "Select Name, Start_Time, End_Time from chamber where Name = 'JPEWG2C35' and End_Time =''"
lCmd.CommandText = lsCmd
lRd = lCmd.ExecuteReader()
If lRd.Read() = True Then
Me.btn1.Enabled = True
Me.btn2.Enabled = False
Else
Me.btn1.Enabled = False
Me.btn2.Enabled = True
End If
lRd.Close()
myConnection.Close()
Catch ex As Exception
Me.Label4.Text = ex.Message
Finally
If myConnection.State = ConnectionState.Open Then
myConnection.Close()
End If
End Try
Return True
End Function
End Class
ctee
Member
115 Points
250 Posts
Refresh Problem. Help!!
May 16, 2012 06:56 AM|LINK
Hi,
What i trying to do is, i just want to refresh the certain content in the page, i dont want to refresh the whole page. I using update panel + timer to refresh one of the content. Bt i fail to do so, it will refresh whole page instead small part.
Below are the code, can someone guide me with this problem.
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="MainPage.aspx.vb" Inherits="Default2" %> <!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 id="Head1" runat="server"> <title>Management</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <link rel="stylesheet" type="text/css" href="Styles/mainstyle.css" /> </head> <body> <form id="form1" runat="server"> <div> <!-- Begin Wrapper --> <div id="wrapper"> <!-- Begin Header --> <div id="header"><h1><a href=""></a>Chamber</h1> <h1> </h1></div> <!-- End Header --> <!-- Begin Faux Columns --> <div id="faux"> <div> <asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager> <asp:UpdatePanel ID="UpdatePanel1" runat="server"> <ContentTemplate> <asp:Label ID="lbl1" runat="server" Text="The chamber still not refresh yet."></asp:Label> <asp:Button ID="btn1" runat="server" BackColor="#33CC33" ForeColor="White" Text="Start" Width="80px" /> <asp:Button ID="btn2" runat="server" BackColor="Red" ForeColor="White" Text="Stop" /> <br /> <asp:Label ID="lbl2" runat="server">hi</asp:Label> <br /> <asp:Label ID="lbl3" runat="server"></asp:Label> <br /> </ContentTemplate> </asp:UpdatePanel> <asp:Timer ID="Timer1" runat="server" Interval="10000" OnTick = "Timer1_Tick"> </asp:Timer> </div> <div class="clear"> <div> <table border="0"> <tr> <td>row 1, cell 1</td> <td>row 1, cell 2</td> </tr> <tr> <td>row 2, cell 1</td> <td>row 2, cell 2</td> </tr> </table> <asp:Label ID="Label4" runat="server"></asp:Label> <br /> <asp:Label ID="Label5" runat="server"></asp:Label> </div> </div> </div> <!-- End Faux Columns --> <!-- Begin Footer --> <div id="footer"> ©Copyright 2012. All rights reserved.</div> <!-- End Footer --> </div> <!-- End Wrapper --> </div> </form> </body> </html>Imports System.Data Imports MySql.Data Imports MySql.Data.MySqlClient Partial Class Default2 Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Label5.Text = DateTime.Now.ToLongTimeString End Sub Protected Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) lbl1.Text = "Updated at: " + DateTime.Now.ToLongTimeString() GetChamber() End Sub Private Function GetChamber() As Boolean Dim myConnection As New MySqlConnection Dim lCmd As New MySqlCommand Dim lRd As MySqlDataReader Dim lsCmd As String = Nothing Dim lTx As MySqlTransaction myConnection = New MySqlConnection("server=localhost; user id=root; password=; database=te; pooling=false;") Try 'open connection myConnection.Open() lCmd.Connection = myConnection 'Link the transaction lTx = myConnection.BeginTransaction lCmd.Transaction = lTx 'check whether chamber end_time is null or gt value lsCmd = "Select Name, Start_Time, End_Time from chamber where Name = 'JPEWG2C35' and End_Time =''" lCmd.CommandText = lsCmd lRd = lCmd.ExecuteReader() If lRd.Read() = True Then Me.btn1.Enabled = True Me.btn2.Enabled = False Else Me.btn1.Enabled = False Me.btn2.Enabled = True End If lRd.Close() myConnection.Close() Catch ex As Exception Me.Label4.Text = ex.Message Finally If myConnection.State = ConnectionState.Open Then myConnection.Close() End If End Try Return True End Function End Classkedarrkulkar...
All-Star
34013 Points
5468 Posts
Re: Refresh Problem. Help!!
May 16, 2012 07:10 AM|LINK
you have not set updatepanel trigger to timer control... change u r updatepanel tag as this
<asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager> <asp:UpdatePanel ID="UpdatePanel1" runat="server"> <Triggers> <asp:AsyncPostBackTrigger controlid="Timer1" eventname="Tick" /> </Triggers> <ContentTemplate> <asp:Label ID="lbl1" runat="server" Text="The chamber still not refresh yet."></asp:Label> <asp:Button ID="btn1" runat="server" BackColor="#33CC33" ForeColor="White" Text="Start" Width="80px" /> <asp:Button ID="btn2" runat="server" BackColor="Red" ForeColor="White" Text="Stop" /> <br /> <asp:Label ID="lbl2" runat="server">hi</asp:Label> <br /> <asp:Label ID="lbl3" runat="server"></asp:Label> <br /> </ContentTemplate> </asp:UpdatePanel> <asp:Timer ID="Timer1" runat="server" Interval="10000" OnTick = "Timer1_Tick"> </asp:Timer>note the <triggers> tag
hope this helps...
KK
Please mark as Answer if post helps in resolving your issue
My Site
nijhawan.sau...
All-Star
16398 Points
3172 Posts
Re: Refresh Problem. Help!!
May 16, 2012 07:16 AM|LINK
Use asynchronous trigger Or you can put your timer inside updatepanel and then it'd work.
ctee
Member
115 Points
250 Posts
Re: Refresh Problem. Help!!
May 16, 2012 07:22 AM|LINK
Thanks.. It can work now with refresh the whole page..