Sorry the previous post was not written clearly, people did not understand what I meant. All my data uploaded in datagridview 2 is for easy viewing just need to get information. actually not uploaded. What to do after I book the meeting room in another form with the time column data: start, stop, roomname will display on datagridview1 which means that after you book the meeting room, you can look at datagridview1 to know what time is the meeting room as shown? I only know how to load data up the same form as the code below, but from one booking form to another, I don't know how to display it. hope you guys can guide me, thank you very much
private void selectAreaColor() { string starttime1 = cboStarttime.Text;//I don't know how to declare it to get it from the database string stoptime1 = cboStoptime.Text;//I don't know how to declare it to get it from the database // 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();//I don't know how to declare it to get it from the database // 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 = 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); } } } } }