Get data from Datagridview2 or database to show Datagridview1

I have 2 datagridview as shown after adding new data from another form it will save data in datagridview 2. i don't know how to make it go through the columns which are time: start, stop and roomname to get the show data .When it comes to datagridview 1 as shown, it means looking at datagridview 1 to know the meeting time of the meeting room. If you create a button select datarow to select datagridview 2, can load data into datagridview 1 correctly. I want data, I finish clicking add new data from another form, the meeting room data will always be displayed datagrdivew 1. hope everyone can support, and here is the code that can only show 1 line of data.

here code get 1 value:

private void selectAreaColor()
{
    string starttime1 = cboStarttime.Text;
    string stoptime1 = cboStoptime.Text;
    string selectedRoom = cboRoom.SelectedItem.ToString();
   
    DateTime startTime = DateTime.ParseExact(starttime1, "HH:mm", null);
    DateTime endTime = DateTime.ParseExact(stoptime1, "HH:mm", null);
  

    // 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)
                {
                   
                    grdMeeting.Rows[rowIndex].Cells[_HeaderText].Style.BackColor = Color.Blue;
                   
                    if (startTime == endTime)
                        return;
                    else
                        startTime = startTime.AddMinutes(30);
                }
            }
        }
    }
}

Hi honag,

Based on your description, it sounds like you have two DataGridViews: grdMeeting and grdMeetingRoom. When a user adds new data from another form, the data is saved in grdMeetingRoom. Then, when the user selects a row in grdMeetingRoom and clicks a button, you want to display the meeting room data in grdMeeting.

Assuming that your DataGridViews have the following columns:

grdMeeting: RoomName, 8:00, 8:30, 9:00, 9:30, ..., 17:00
grdMeetingRoom: RoomName, StartTime, EndTime

try the following code:

private void btnLoadMeeting_Click(object sender, EventArgs e)
{
// Get the selected row in grdMeetingRoom
DataGridViewRow selectedRow = grdMeetingRoom.SelectedRows[0];
// Get the values of RoomName, StartTime, and EndTime
string roomName = selectedRow.Cells["RoomName"].Value.ToString();
DateTime startTime = DateTime.Parse(selectedRow.Cells["StartTime"].Value.ToString());
DateTime endTime = DateTime.Parse(selectedRow.Cells["EndTime"].Value.ToString());

// Loop through the rows in grdMeeting to find the matching room
foreach (DataGridViewRow row in grdMeeting.Rows)
{
    if (row.Cells["RoomName"].Value.ToString() == roomName)
    {
        int rowIndex = row.Index;
        // Loop through the columns and compare the start and end times with the meeting time
        for (int i = 1; i < grdMeeting.Columns.Count; i++)
        {
            DateTime columnTime = DateTime.ParseExact(grdMeeting.Columns[i].HeaderText, "HH:mm", null);
            if (columnTime >= startTime && columnTime < endTime)
            {
                row.Cells[i].Style.BackColor = Color.Blue;
            }
        }
    }
}
}

This code first gets the selected row in grdMeetingRoom, and then extracts the RoomName, StartTime, and EndTime values. It then loops through the rows in grdMeeting to find the matching room, and then loops through the columns to compare the meeting time with the start and end times of each time slot. If the meeting time falls within a time slot, the background color of the cell is set to blue.

This code assumes that each time slot in grdMeeting has a duration of 30 minutes, and that the time slots are named with a 24-hour time format (e.g. "08:00", "08:30", etc.). If your DataGridViews have different columns or formats, you may need to adjust the code accordingly.

1 Reply

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

Tuhin Paul3y ago
Hi honag,

Based on your description, it sounds like you have two DataGridViews: grdMeeting and grdMeetingRoom. When a user adds new data from another form, the data is saved in grdMeetingRoom. Then, when the user selects a row in grdMeetingRoom and clicks a button, you want to display the meeting room data in grdMeeting.

Assuming that your DataGridViews have the following columns:
1. grdMeeting: RoomName, 8:00, 8:30, 9:00, 9:30, ..., 17:00
2. grdMeetingRoom: RoomName, StartTime, EndTime
try the following code:
```
private void btnLoadMeeting_Click(object sender, EventArgs e)
{
// Get the selected row in grdMeetingRoom
DataGridViewRow selectedRow = grdMeetingRoom.SelectedRows[0];
// Get the values of RoomName, StartTime, and EndTime
string roomName = selectedRow.Cells["RoomName"].Value.ToString();
DateTime startTime = DateTime.Parse(selectedRow.Cells["StartTime"].Value.ToString());
DateTime endTime = DateTime.Parse(selectedRow.Cells["EndTime"].Value.ToString());

// Loop through the rows in grdMeeting to find the matching room
foreach (DataGridViewRow row in grdMeeting.Rows)
{
    if (row.Cells["RoomName"].Value.ToString() == roomName)
    {
        int rowIndex = row.Index;
        // Loop through the columns and compare the start and end times with the meeting time
        for (int i = 1; i < grdMeeting.Columns.Count; i++)
        {
            DateTime columnTime = DateTime.ParseExact(grdMeeting.Columns[i].HeaderText, "HH:mm", null);
            if (columnTime >= startTime && columnTime < endTime)
            {
                row.Cells[i].Style.BackColor = Color.Blue;
            }
        }
    }
}
}
```
This code first gets the selected row in grdMeetingRoom, and then extracts the RoomName, StartTime, and EndTime values. It then loops through the rows in grdMeeting to find the matching room, and then loops through the columns to compare the meeting time with the start and end times of each time slot. If the meeting time falls within a time slot, the background color of the cell is set to blue.

This code assumes that each time slot in grdMeeting has a duration of 30 minutes, and that the time slots are named with a 24-hour time format (e.g. "08:00", "08:30", etc.). If your DataGridViews have different columns or formats, you may need to adjust the code accordingly.
0