Hi!
Im making a page where I want to display this weeks information & news as a default setting.
What do I have to do to make it work (Im new to .Net but used to ASP 3 & MySql)?
My idea is to store the week number in a variable which is updated att Page_load and then
to use this variable in the following sql statement that gets news and info from the MsSql
database where weeknumber is = the defined variable.
So how do I store weeknumber in a variable?
AND
How do I use this variable in the SQL statement?
Weeknumber can be store in a Session variable.
There is a function in SqlServer called DateDiff() with many options, you can get the number of week between 2 date. than compare this nubmer with the Session variable.
Hope this help
No comments:
Post a Comment