Thursday, January 27, 2011

month & year from code

DataTable dt = new DataTable();
DataColumn name = new DataColumn("value", typeof(string));
dt.Columns.Add(name);
DataRow row;
/*to genrate years */
for (int i = 1970; i <= DateTime.Now.Year; i++) { row = dt.NewRow(); dt.Rows.Add(row); row[0] = i; } return dt; /* for months*/
for (int i = 1; i < 13; i++)
{
row = dt.NewRow();
dt.Rows.Add(row);
row[0] = Convert.ToDateTime("1-" + i + "-2000").ToString("MMM"); ;
}
return dt;

No comments:

Post a Comment