I am having a interesting issue. I work for a University's Career
Services department. We collect data from recent grads. I am
recreating the online survey we use. I am trying to populate the
graduation date with 4 dates. May **, June **, August **, December **.
The "**" represents the year of graduation. To prevent having to
constantly update this survey I'd like to dynamically create this
values. So at page load I want it to check the server time and only
show the months from the past year. IE since Today is June 07 the
values would read June 07, May 07, December 06, August 06. Then in
August It would read August 07, June 07, May 07, December 06. Etc... I
am trying to think of a clever way to do this and just can not do
this. Anyone have an idea?"djjohnst" <djjohnst@.gmail.com> wrote in message
news:1180703317.389866.199290@.p77g2000hsh.googlegroups.com...
> Anyone have an idea?
List<DateTime> lstDates = new List<DateTime>();
DateTime dtmStart = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
while (lstDates.Count < 4)
{
if (dtmStart.Month == 5
|| dtmStart.Month == 6
|| dtmStart.Month == 8
|| dtmStart.Month == 12)
{
lstDates.Add(dtmStart);
}
dtmStart = dtmStart.AddMonths(-1);
}
http://www.markrae.net
How about something like...
DateTime dt = DateTime.Today();
for (int iLoop = 0; iLoop < 4; iLoop++)
{
ddlMyDropDown.Items.Add(new ListItem(String.Format("{0:MMM yy}",
dt)));
dt = dt.DateAdd("MM", -3, dt);
}
Dunc
http://www.fluidfoundation.com
On 1 Jun, 14:08, djjohnst <djjoh...@.gmail.com> wrote:
> I am having a interesting issue. I work for a University's Career
> Services department. We collect data from recent grads. I am
> recreating the online survey we use. I am trying to populate the
> graduation date with 4 dates. May **, June **, August **, December **.
> The "**" represents the year of graduation. To prevent having to
> constantly update this survey I'd like to dynamically create this
> values. So at page load I want it to check the server time and only
> show the months from the past year. IE since Today is June 07 the
> values would read June 07, May 07, December 06, August 06. Then in
> August It would read August 07, June 07, May 07, December 06. Etc... I
> am trying to think of a clever way to do this and just can not do
> this. Anyone have an idea?
On Jun 1, 3:25 pm, "Mark Rae" <m...@.markNOSPAMrae.net> wrote:
> "djjohnst" <djjoh...@.gmail.com> wrote in message
> news:1180703317.389866.199290@.p77g2000hsh.googlegroups.com...
>
> List<DateTime> lstDates = new List<DateTime>();
> DateTime dtmStart = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1)
;
> while (lstDates.Count < 4)
> {
> if (dtmStart.Month == 5
> || dtmStart.Month == 6
> || dtmStart.Month == 8
> || dtmStart.Month == 12)
> {
> lstDates.Add(dtmStart);
> }
> dtmStart = dtmStart.AddMonths(-1);
> }
> --http://www.markrae.net
Well done, Mark!
"Alexey Smirnov" <alexey.smirnov@.gmail.com> wrote in message
news:1180705293.175856.189800@.u30g2000hsc.googlegroups.com...
> Well done, Mark!
LOL!
http://www.markrae.net
"Dunc" <duncan.welch@.gmail.com> wrote in message
news:1180705084.782217.124280@.g4g2000hsf.googlegroups.com...
> DateTime dt = DateTime.Today();
> for (int iLoop = 0; iLoop < 4; iLoop++)
> {
> ddlMyDropDown.Items.Add(new ListItem(String.Format("{0:MMM yy}",
> dt)));
> dt = dt.DateAdd("MM", -3, dt);
> }
Suppose you start today, what are the four dates which your code will add to
the DropDownList...?
http://www.markrae.net
Just a bit of modification to Mark's code to output it as djjohnst was looki
ng
for, in the "June XX" format):
List<String> lstDates = new List<String>();
DateTime dtmStart = new DateTime(DateTime.Now.Year, DateTime.Now.Month,
1);
while (lstDates.Count < 4)
{
if (dtmStart.Month == 5
|| dtmStart.Month == 6
|| dtmStart.Month == 8
|| dtmStart.Month == 12)
{
lstDates.Add(dtmStart.ToString("MMMM yy"));
}
dtmStart = dtmStart.AddMonths(-1);
}
ddlGradDates.DataSource = lstDates;
ddlGradDates.DataBind();
- Converted it from a list collection of DateTimes to Strings; maybe a KVP
to keep the "data" and presentation apart may be a solution if the two need
to be different.
- Added the MMMM yy to output the long Month name and short year.
HTH.
-dl
David R. Longnecker
Web Developer
http://blog.tiredstudent.com
> "djjohnst" <djjohnst@.gmail.com> wrote in message
> news:1180703317.389866.199290@.p77g2000hsh.googlegroups.com...
>
> List<DateTime> lstDates = new List<DateTime>();
> DateTime dtmStart = new DateTime(DateTime.Now.Year,
> DateTime.Now.Month, 1);
> while (lstDates.Count < 4)
> {
> if (dtmStart.Month == 5
> || dtmStart.Month == 6
> || dtmStart.Month == 8
> || dtmStart.Month == 12)
> {
> lstDates.Add(dtmStart);
> }
> dtmStart = dtmStart.AddMonths(-1);
> }
"David Longnecker" <dlongnecker@.community.nospam> wrote in message
news:463c247119638c972440ba448a4@.msnews.microsoft.com...
> Just a bit of modification to Mark's code to output it as djjohnst was
> looking for, in the "June XX" format):
True enough - I took the final formatting "as read", and assumed that the
it was the actual date generation that was causing the OP problems... :-)
http://www.markrae.net
As of today i would want it to display the following options
June 07
May 07
Dec 06
August 06
"djjohnst" <djjohnst@.gmail.com> wrote in message
news:1180712937.354039.273110@.q69g2000hsb.googlegroups.com...
> As of today i would want it to display the following options
> June 07
> May 07
> Dec 06
> August 06
Yes, I know...
http://www.markrae.net
Friday, March 16, 2012
Populating a List box with recent dates
Labels:
amrecreating,
asp,
box,
careerservices,
collect,
dates,
department,
grads,
interesting,
net,
populating,
university
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment