Hello,
I have a datalist and I'm trying to split the records returned in the datalist by the Month. I have a datetime column in the databse that I want to reference. So for example if the column has the date for the record at '2013-05-01 14:02:00', I would like
to extract the month from the datetime in C# as 'May' and within the datalist put the records under May. Something along the lines of:
DataSet:
Record 1 2013-05-01 14:02:00
Record 2 2013-09-24 21:36:00
Record 3 2013-10-21 17:50:06
Record 4 2013-05-21 12:20:24
Record 5 2013-09-26 22:09:23
Output for Datalist:
MAY
Record 1
Record 4
September
Record 2
Record 5
October
Record 3
this is my code to populate the datalist:
{
string conString = ConfigurationManager.ConnectionStrings["MNE"].ConnectionString;
string query = "SELECT I ...
Go to the complete details ...