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