I’m looking to create a display board on an Intranet website. To do this I’m using Microsoft Visual studio 2010 C# coding and SQL express 2008.
Im looking to do several things but I think the solution to one should cure all, so heres an example of what something I would like to set up.
Lets say I want to create an “out of office” display board. I can create a nice SQL table with a Primary Key ID field and some columns for “Name” “Start Date” “End Date” “Description” etc..
So my table would look something like this with some fictional data.
ID : Name: Description: Start Date: End Date:
1 Joe Smith Dentist Appt. 3/22/12 3/24/12
Creating an entry system for user to enter data into this table isn’t a problem, so what I would like to do is create a display for this data on the website page. I was thinking a gridview control, but any suggestions of better options are welcome. The main thing is I want the display to show only current time constrained data, so if a user entered a post that was 4 weeks in advance, I wouldn’t want it to display until say 1 week prior to the start date entered and I would also like the post to disappear from the display after the end date has passed.
I imagine I’m going to have to set up a filter of some kind though I’m not sure how to go about it. Any ideas are welcome and also tips on setting up the SQL database to best accomplish this. I’m not all that good with coding, so laymans terms are welcome also.
Im looking to do several things but I think the solution to one should cure all, so heres an example of what something I would like to set up.
Lets say I want to create an “out of office” display board. I can create a nice SQL table with a Primary Key ID field and some columns for “Name” “Start Date” “End Date” “Description” etc..
So my table would look something like this with some fictional data.
ID : Name: Description: Start Date: End Date:
1 Joe Smith Dentist Appt. 3/22/12 3/24/12
Creating an entry system for user to enter data into this table isn’t a problem, so what I would like to do is create a display for this data on the website page. I was thinking a gridview control, but any suggestions of better options are welcome. The main thing is I want the display to show only current time constrained data, so if a user entered a post that was 4 weeks in advance, I wouldn’t want it to display until say 1 week prior to the start date entered and I would also like the post to disappear from the display after the end date has passed.
I imagine I’m going to have to set up a filter of some kind though I’m not sure how to go about it. Any ideas are welcome and also tips on setting up the SQL database to best accomplish this. I’m not all that good with coding, so laymans terms are welcome also.
Last edited:
Facebook
Twitter