[RESOLVED] How to refresh page every second

[tommygrayson]

Hi guys.

How do I refresh the page every second because my page is not showing because loading to the next page is too long.

Here's what I have done so far.

Page.RegisterStartupScript("Timer", "<script type=text/javascript>setTiemout('document.location=document.location',1000)</script>")
        SqlConnection1.Open()
        SqlConnection2.Open()
        Server.ScriptTimeout = 1000000
        SqlSelectCommand2.CommandText = "SELECT t_mobile.t_fullname, t_mobile.t_empNo FROM t_mobile INNER JOIN t_Mmobile ON t_mobile.prime = t_Mmobile.prime WHERE (t_Mmobile.t_month LIKE '%" & MonthStr & "%') AND (t_Mmobile.t_year LIKE '%" & YearStr & "%')"
        SqlSelectCommand2.ExecuteNonQuery()
        SqlDataAdapter2.Fill(DataSet1)
        EmpCount = 100
        DataSet1.Reset()
        Do While Not LoopCounter = EmpCount
                             SqlSelectCommand2.CommandText = "SELECT t_mobile.t_fullname, t_mobile.t_empNo, t_mobile.t_total FROM t_mobile INNER JOIN t_Mmobile ON t_mobile.prime = t_Mmobile.prime WHERE (t_Mmobile.t_month LIKE '%" & MonthStr & "%') AND (t_Mmobile.t_year LIKE '%" & YearStr & "%')"
                SqlSelectCommand2.ExecuteNonQuery()
                SqlDataAdapter2.Fill(DataSet1)
                EmpNumber = Trim(DataSet1.Tables(0).Rows(LoopCounter - 1).Item(1))
                xcRange = xcWS.Range("B" & LoopCounter + 1)
                xcRange.Value = UCase(Trim(DataSet1.Tables(0).Rows(LoopCounter - 1).Item(0)))
       Loop

Apprceiate your help.