redirect to another page if time is not updating

Question

0.00/5 (No votes)

See more:

Dear Friends,
am working on asp.net , C#, SqlServer 2005.
I want to redirect it to Underconstruction page if time is not updating.
if database time is less than 5 minutes when compare to system time...it must redirect to underconstruction page. else it should be Home.aspx.
This is my code.

C#

protected void Page_Load(object sender, EventArgs e)
    {
       // lblUpdate.Text = "Last Updated at : " + DateTime.Now.AddMinutes(-60).ToLongTimeString();

       SqlConnection con = new SqlConnection("Data Source=IT-PC;Initial Catalog=collegeDB;User ID=sa; Password=12345;");
       

        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "Select timeupdate from timeLastUpdate";

        using (con)
        {
            con.Open();
            SqlDataReader reader = cmd.ExecuteReader();

            if (reader.Read())
            {
                lblUpdate.Text = reader["timeupdate "].ToString();

                lblUpdate.ForeColor = Color.Red;
            }
        }
}

If time updating stops it must redirect to underconstructionpage.aspx
else
redirect to Home.aspx
Please help me, Thanks.

Posted 9-Oct-12 20:59pm

Ranjith Reddy CSE

Updated 9-Oct-12 21:01pm

tanweer

v2

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**tanweer** · Answer 1 · 2012-10-09T21:13:00

hi, it will work:

C#

protected void Page_Load(object sender, EventArgs e)
    {
            // lblUpdate.Text = "Last Updated at : " + DateTime.Now.AddMinutes(-60).ToLongTimeString();

            SqlConnection con = new SqlConnection("Data Source=IT-PC;Initial Catalog=collegeDB;User ID=sa; Password=12345;");

            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            cmd.CommandText = "Select timeupdate from timeLastUpdate";

            using (con)
            {
                con.Open();
                SqlDataReader reader = cmd.ExecuteReader();

                if (reader.Read())
                {
                    lblUpdate.Text = reader["timeupdate "].ToString();

                    lblUpdate.ForeColor = Color.Red;

                    if (Convert.ToDateTime(reader["timeupdate "].ToString()) < DateTime.Now.AddMinutes(-5))
                    {
                        Response.Redirect("underconstructionpage.aspx");
                    }
                }
            }
    }

Mohd. Mukhtar · Answer 2 · 2012-10-09T21:11:00

Hi Use the below code

C#

protected void Page_Load(object sender, EventArgs e)
    {
       // lblUpdate.Text = "Last Updated at : " + DateTime.Now.AddMinutes(-60).ToLongTimeString();
       SqlConnection con = new SqlConnection("Data Source=IT-PC;Initial Catalog=collegeDB;User ID=sa; Password=12345;");       
 
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "Select timeupdate from timeLastUpdate";
        DateTime lastupdatetime;
        using (con)
        {
            con.Open();
            SqlDataReader reader = cmd.ExecuteReader();
 
            if (reader.Read())
            {
                lastupdatetime = Convert.ToDateTime(reader["timeupdate "].ToString());
                lblUpdate.Text = lastupdatetime.ToString();
                lblUpdate.ForeColor = Color.Red;
            }
        }
        if(lastupdatetime.AddMinutes(5) > DateTime.Now)
        {
            Response.Redirect("HomePage.aspx");
        }
        else
        {
            Response.Redirect("underconstruction.aspx");

         }
}

Also you should clean all the resources.

surendersinghprajapati · Answer 3 · 2012-10-09T21:09:00

I think you can write that code at Global.asax file at session start to get time from the database and then compare it.

if you condition satisfy for less then 5 min then you can directly redirect to underconstrunctionpage.aspx else no redirection. and it will display home.aspx as usual.

I hope this would be helpful. Let me know if you need any further help.

redirect to another page if time is not updating

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

redirect to another page if time is not updating

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us