private void textBoxManageSearch_TextChanged(object sender, EventArgs e) { string value = textBoxManageSearch.Text; if (value != null) { DataTable dt = bookloanD.Search(value); dataGridViewManageBookLoanDatabase.DataSource = dt; } else { refreshData(); } }
private void dataGridViewUsers_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) { //find the row index of the row clicked on user data grid view int RowIndex = e.RowIndex; textBoxUserID.Text = dataGridViewUsers.Rows[RowIndex].Cells[0].Value.ToString(); textBoxUsername.Text = dataGridViewUsers.Rows[RowIndex].Cells[1].Value.ToString(); textBoxFirstName.Text = dataGridViewUsers.Rows[RowIndex].Cells[2].Value.ToString(); textBoxLastName.Text = dataGridViewUsers.Rows[RowIndex].Cells[3].Value.ToString(); textBoxEmail.Text = dataGridViewUsers.Rows[RowIndex].Cells[4].Value.ToString(); textBoxAddress.Text = dataGridViewUsers.Rows[RowIndex].Cells[5].Value.ToString(); textBoxMobile.Text = dataGridViewUsers.Rows[RowIndex].Cells[6].Value.ToString(); switch (dataGridViewUsers.Rows[RowIndex].Cells[7].Value.ToString().Trim()) { case "Male": comboBoxGender.SelectedIndex = 0; break; case "Female": comboBoxGender.SelectedIndex = 1; break; case "Other": comboBoxGender.SelectedIndex = 2; break; } dateTimePickerEnrolledDate.Value = DateTime.Parse(dataGridViewUsers.Rows[RowIndex].Cells[8].Value.ToString()); dateTimePickerExpiryDate.Value = DateTime.Parse(dataGridViewUsers.Rows[RowIndex].Cells[9].Value.ToString()); textBoxBooksBorrowed.Text = dataGridViewUsers.Rows[RowIndex].Cells[10].Value.ToString(); List <BookLoanModel> listBooks = bloanD.Search(int.Parse(textBoxUserID.Text)); /* dataGridViewBooksBorrowed.DataSource = dt; * */ /* MessageBox.Show(listBooks[0].issued_book_name); */ var columns = from t in listBooks orderby t.return_date select new { BookName = t.issued_book_name, Username = t.issued_user_name, Issue_Date = t.issued_date, Return_Date = t.return_date, Days_left_DAY_HR_MIN_SEC = t.return_date - t.issued_date }; dataGridViewBooksBorrowed.DataSource = columns.ToList(); }