×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Load data from database to Datagridview C#

Load data from database to Datagridview C#

Load data from database to Datagridview C#

(OP)
Hello everyone,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. I have api including details of data tables as each table, do not have to get data directly on the database management system, only use api
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);
}
}
}
}
}

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close