C# Listview/Datagridview columns names contain date and day

Hey try this

public partial class GridViewMonthDetails : Form
{
public GridViewMonthDetails()
{
InitializeComponent();
}
private void GridViewMonthDetails_Load(object sender, EventArgs e)
{
FillMonthList();
}
private void FillMonthList()
{
var listMonths = Enumerable.Range(1, 12).Select(i => new { I = i, M = DateTimeFormatInfo.CurrentInfo.GetMonthName(i) });
DataTable dataTable = ToDataTable(listMonths.ToList());
DataRow dataRow = dataTable.NewRow();
dataRow["M"] = "Select Month";
dataRow["I"] = 0;
dataTable.Rows.InsertAt(dataRow, 0);
comboBoxMonth.DataSource = dataTable;
comboBoxMonth.DisplayMember = "M";
comboBoxMonth.ValueMember = "I";
}
private void LoadGridView()
{
DataTable dataTable = new DataTable();
dataTable.Columns.Add("ID", typeof(int));
dataTable.Columns.Add("DATE", typeof(string));
dataTable.Columns.Add("DAYOFWEEK", typeof(string));
int curYear = DateTime.Now.Year;
var listDate = GetDates(curYear, Convert.ToInt32(comboBoxMonth.SelectedValue.ToString()));
foreach (var item in listDate)
{
DateTime dateTime = item;
DayOfWeek dayOfWeek = dateTime.DayOfWeek;
dataTable.Rows.Add(dateTime.Day, dateTime.Date.ToString("dd-MM-yyyy"), dayOfWeek.ToString());
}
var pivotedDataTable = new DataTable();
var pivotColumnName = "DATE";
var pivotColumnName1 = "DAYOFWEEK";
pivotedDataTable.Columns.Add("Column1");
pivotedDataTable.Columns.Add("Column2");
pivotedDataTable.Columns.AddRange(
dataTable.Rows.Cast().Select(x => new DataColumn(x[pivotColumnName].ToString()+ Environment.NewLine + x[pivotColumnName1].ToString())).ToArray());
dataGridViewMonth.DataSource = pivotedDataTable;
}
public static DataTable ToDataTable(List items)
{
DataTable dataTable = new DataTable(typeof(T).Name);
//Get all the properties
PropertyInfo[] Props = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance);
foreach (PropertyInfo prop in Props)
{
//Setting column names as Property names
dataTable.Columns.Add(prop.Name);
}
foreach (T item in items)
{
var values = new object[Props.Length];
for (int i = 0; i < Props.Length; i++)
{
//inserting property values to datatable rows
values[i] = Props[i].GetValue(item, null);
}
dataTable.Rows.Add(values);
}
//put a breakpoint here and check datatable
return dataTable;
}
private List GetDates(int year, int month)
{
return Enumerable.Range(1, DateTime.DaysInMonth(year, month)) // Days: 1, 2 ... 31 etc.
.Select(day => new DateTime(year, month, day)) // Map each day to a date
.ToList(); // Load dates into a list
}
//Using for-loop:
private List GetDates1(int year, int month)
{
var dates = new List();
// Loop from the first day of the month until we hit the next month, moving forward a day at a time
for (var date = new DateTime(year, month, 1); date.Month == month; date = date.AddDays(1))
{
dates.Add(date);
}
return dates;
}
private void comboBoxMonth_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBoxMonth.SelectedIndex > 0)
LoadGridView();
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty6y ago
Hey try this
public partial class GridViewMonthDetails : Form
{
    public GridViewMonthDetails()
    {
        InitializeComponent();
    }

    private void GridViewMonthDetails_Load(object sender, EventArgs e)
    {
        FillMonthList();
    }

    private void FillMonthList()
    {
        var listMonths = Enumerable.Range(1, 12).Select(i => new { I = i, M = DateTimeFormatInfo.CurrentInfo.GetMonthName(i) });
        DataTable dataTable = ToDataTable(listMonths.ToList());
        DataRow dataRow = dataTable.NewRow();
        dataRow["M"] = "Select Month";
        dataRow["I"] = 0;
        dataTable.Rows.InsertAt(dataRow, 0);
        comboBoxMonth.DataSource = dataTable;
        comboBoxMonth.DisplayMember = "M";
        comboBoxMonth.ValueMember = "I";
    }

    private void LoadGridView()
    {
        DataTable dataTable = new DataTable();
        dataTable.Columns.Add("ID", typeof(int));
        dataTable.Columns.Add("DATE", typeof(string));
        dataTable.Columns.Add("DAYOFWEEK", typeof(string));

        int curYear = DateTime.Now.Year;
        var listDate = GetDates(curYear, Convert.ToInt32(comboBoxMonth.SelectedValue.ToString()));
        foreach (var item in listDate)
        {
            DateTime dateTime = item;
            DayOfWeek dayOfWeek = dateTime.DayOfWeek;
            dataTable.Rows.Add(dateTime.Day, dateTime.Date.ToString("dd-MM-yyyy"), dayOfWeek.ToString());
        }

        var pivotedDataTable = new DataTable();
        var pivotColumnName = "DATE";
        var pivotColumnName1 = "DAYOFWEEK";

        pivotedDataTable.Columns.Add("Column1");
        pivotedDataTable.Columns.Add("Column2");

        pivotedDataTable.Columns.AddRange(
            dataTable.Rows.Cast().Select(x => new DataColumn(x[pivotColumnName].ToString()+ Environment.NewLine + x[pivotColumnName1].ToString())).ToArray());

        dataGridViewMonth.DataSource = pivotedDataTable;
    }

    public static DataTable ToDataTable(List items)
    {
        DataTable dataTable = new DataTable(typeof(T).Name);
        //Get all the properties
        PropertyInfo[] Props = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance);
        foreach (PropertyInfo prop in Props)
        {
            //Setting column names as Property names
            dataTable.Columns.Add(prop.Name);
        }
        foreach (T item in items)
        {
            var values = new object[Props.Length];
            for (int i = 0; i < Props.Length; i++)
            {
                //inserting property values to datatable rows
                values[i] = Props[i].GetValue(item, null);
            }
            dataTable.Rows.Add(values);
        }
        //put a breakpoint here and check datatable
        return dataTable;
    }

    private List GetDates(int year, int month)
    {
        return Enumerable.Range(1, DateTime.DaysInMonth(year, month))  // Days: 1, 2 ... 31 etc.
                            .Select(day => new DateTime(year, month, day)) // Map each day to a date
                            .ToList(); // Load dates into a list
    }

    //Using for-loop:
    private List GetDates1(int year, int month)
    {
        var dates = new List();
        // Loop from the first day of the month until we hit the next month, moving forward a day at a time
        for (var date = new DateTime(year, month, 1); date.Month == month; date = date.AddDays(1))
        {
            dates.Add(date);
        }
        return dates;
    }

    private void comboBoxMonth_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (comboBoxMonth.SelectedIndex > 0)
            LoadGridView();
    }
}
Laxmidhar Sahoo6y ago
1. DataTable dt = new DataTable();
2. DataColumn dcol = new DataColumn("ID", typeof(System.Int32));
3. dcol.AutoIncrement = true;
4. dt.Columns.Add(dcol);
6. int days = 0;
7. string selected_month = "JAN";
9. if (selected_month == "JAN" || selected_month == "MAR")
10. { days = 31; }
11. else if(selected_month == "APR")
12. { days = 30; }
14. for (int z = 1; z < days; z++)
15. {
16. dcol = new DataColumn(z.ToString(), typeof(System.String));
17. dt.Columns.Add(dcol);
18. }
In the for loop use adddays function and use the date columns converting to string.just for reference I used integer field