Hi AnandM,
I did some searching online and found a possible solution referred to as "creating date dimension" or "calendar table".
Its an sql stored procedure solution that inserts dates specified from a particular period to another or a whole calendar year into a table.
I actually want to build a timesheet and my requirement is to have a database table (I use mssql 2008 server) with one calendar year in the first column, the day component in the next column and the week component in the third column.
Then bind all these data to a label or textbox control of a gridview.
Now there will also need to be an html interface from where the user will specify data range and then the sql stored procudure will do the rest from behind.
I havent seen this "date dimension" solution here on aspsnippets and I know the likes of Mudassar usually breaks stuff down making them very easy to implement.
I will start work on it and I will certainly appreciate your input AnandM.
Thank you