honag luc

honag luc

  • NA
  • 123
  • 7.5k

Merge column on datagridview C#

Mar 28 2023 4:30 AM

After obtaining the meeting area and meeting time. but i want to merge all columns from start time to end time into a single cell as shown
handle the code merger column that I don't know how to do. thank you very much

private void selectAreaColor()
{
    string starttime1 = cboStarttime.Text;
    string stoptime1 = cboStoptime.Text;
    // Get the start time and end time inputs and the selected meeting room
    DateTime startTime = DateTime.ParseExact(starttime1, "HH:mm", null);
    DateTime endTime = DateTime.ParseExact(stoptime1, "HH:mm", null);
    string selectedRoom = cboRoom.SelectedItem.ToString();//

    // Loop through the rows in the DataGridView and find the matching row

    foreach (DataGridViewRow row in grdMeeting.Rows)
    {
        if (row.Cells[0].Value.ToString() == selectedRoom)
        {
            int rowIndex = row.Index;
            // Loop through the columns and compare the start and end times with the time slots
            for (int i = 1; i < grdMeeting.Columns.Count; i++)
            {
                DateTime columnTime;
                try
                {
                    columnTime = DateTime.ParseExact(grdMeeting.Columns[i].HeaderText, "HH:mm", CultureInfo.InvariantCulture);
                }
                catch (Exception ex)
                {
                    continue;
                }
                //DateTime columnTime = DateTime.ParseExact(grdMeeting.Columns[i].HeaderText, "HH:mm", null);
                string _HeaderText = grdMeeting.Columns[i].Name.ToString();
                if (startTime == columnTime)//|| endTime == columnTime
                {

                    grdMeeting.Rows[rowIndex].Cells[_HeaderText].Style.BackColor = Color.Blue;

                    if (startTime == endTime)
                        return;
                    else
                        startTime = startTime.AddMinutes(30);

                }
            }
        }
    }
}

/forums/uploadfile/72149a/03282023041855AM/MergeColumn.rar

 


Answers (2)