private void SearchByKeyword() { var storedGetLibraryType = BuildingStoredProcHelper.BuildStoredStrSearchByKeyword(txtSearchByKeyword.Text); HandlingDataHelper.LoadDataToGrid(dgvSearchByKeyword, DataGridViewHeader.listOfColumnsTypeByKeyword, storedGetLibraryType); lblSearchByKeywordCount.Text = $"Total: {dgvSearchByKeyword.RowCount} record(s)"; }
private void LoadSearchTab(string title) { tcNationalLibrary.SelectedIndex = 0; txtSearchByTitle.Text = title; var storedGetLibraryType = BuildingStoredProcHelper.BuildStoredStrSearchByTitle(title); HandlingDataHelper.LoadDataToGrid(dgvSearchByTitle, DataGridViewHeader.listOfColumnsType, storedGetLibraryType); lblSearchByTitleCount.Text = $"Total: {dgvSearchByTitle.RowCount} record(s)"; }
private void tcAddData_SelectedIndexChanged(object sender, EventArgs e) { switch (tcAddData.SelectedTab.Name) { case TabControlConstants.TabAddDataPublisher: HandlingDataHelper.LoadDataToGrid(dgvPublisher, DataGridViewHeader.listOfColumnsPublisher, TableConstants.LibraryTypePublisher); break; case TabControlConstants.TabAddDataEdition: HandlingDataHelper.LoadDataToGrid(dgvEdition, DataGridViewHeader.listOfColumnsEdition, TableConstants.LibraryTypeEdition); break; case TabControlConstants.TabAddDataEditor: HandlingDataHelper.LoadDataToGrid(dgvEditor, DataGridViewHeader.listOfColumnsEditor, TableConstants.LibraryTypeEditor); break; case TabControlConstants.TabAddDataFormat: HandlingDataHelper.LoadDataToGrid(dgvFormat, DataGridViewHeader.listOfColumnsFormat, TableConstants.LibraryTypeFormat); break; case TabControlConstants.TabAddDataLanguage: HandlingDataHelper.LoadDataToGrid(dgvLanguage, DataGridViewHeader.listOfColumnsLanguage, TableConstants.LibraryTypeLanguage); break; case TabControlConstants.TabAddDataCategory: HandlingDataHelper.LoadDataToGrid(dgvCategory, DataGridViewHeader.listOfColumnsCategory, TableConstants.LibraryTypeCategory); break; case TabControlConstants.TabAddDataCopyright: HandlingDataHelper.LoadDataToGrid(dgvCopyright, DataGridViewHeader.listOfColumnsCopyright, TableConstants.LibraryTypeCopyright); break; case TabControlConstants.TabAddDataAuthor: HandlingDataHelper.LoadDataToGrid(dgvAuthor, DataGridViewHeader.listOfColumnsAuthor, TableConstants.LibraryTypeAuthor); break; default: break; } }