0

Hi I have made a website where it is possible to see the days program on one page, it updates itself so it is only for that day.

But now I wan't to be able to insert a picture that changes position according to what time it is.

For example if the time is 1pm. then the small picture should move down to 1pm.
and if the time is 3pm the picture moves down to 3pm.

Maybe you can see what I meen on:
http://radio.web.surftown.dk/default.aspx

the time is written as datetime in my ms sql database.

my code on my aspx page looks like this:

<%# Eval("tid", "{0:t}")%>

and my code on the codebehind page looks like this:

SqlConnection objconn = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionstring"].ToString());
            SqlCommand objcmd = new SqlCommand();


            objcmd.Connection = objconn;
            objcmd.CommandType = CommandType.Text;

            if (DateTime.Now.Hour > 3)
            {

                objcmd.CommandText = "SELECT * FROM PROGRAM WHERE CONVERT(VARCHAR, date, 105) = CONVERT(VARCHAR, GETDATE(), 105)";
            
           
            SqlDataReader reader = null;

            objconn.Open();
            reader = objcmd.ExecuteReader();
            program.DataSource = reader;
            program.DataBind();

            objconn.Close();
            }
    
         else
            {
                objcmd.CommandText = "SELECT * FROM PROGRAM WHERE DATE = DATEADD(day, DATEDIFF(day, 1, GETDATE()), 0)";

                SqlDataReader reader = null;

                objconn.Open();
                reader = objcmd.ExecuteReader();
                program.DataSource = reader;
                program.DataBind();

            }

        }

I hope you understand what I meen and that you can help me?

2
Contributors
4
Replies
5
Views
8 Years
Discussion Span
Last Post by Ramy Mahrous
0

I think that this might be a way to do it?

my column in my ms sql Db that the system time has to be the same as is called tid.
So I have a suspicion that it could be done something like this:

objcmd.CommandText = "SELECT tid FROM PROGRAM CONVERT(VARCHAR, GETDATE(), {0:t})";

and then later make an if sentence.

if(tid == getdate() "{0:t}")
{
  insert picture with img src="x";
}

But I know that it should be written in a different way, and I am not even sure i'm on the right track.

I hope someone can please help me?

0

My friend it's not related to MS SQL Server :) it's about how can you play with the datetime value returned from SQL Server, as SQL Server returns the value, the problem is over here, and you can post this question to ASP.NET forum, you'd get fast response there.
Best of luck!

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.