public void LoadSearchQuestions(Search search) { DataTable dataTable = SearchQuestion.GetAssociated(search); foreach (DataRow dr in dataTable.Rows) { var searchQuestionId = new Guid(dr["SearchQuestionId"].ToString()); var searchQuestion = new SearchQuestion(searchQuestionId); SearchQuestions.Add(searchQuestion); var searchBidQuestion = new SearchBidQuestion(); searchBidQuestion.SearchBidId = searchBid.Id; searchBidQuestion.SearchQuestionId = searchQuestion.Id; searchBidQuestions.Add(searchBidQuestion); } }
private void LoadDgvQuestions() { DataTable dataTable = SearchQuestion.GetAssociated(CurrentSearch); var dataTableEnum = dataTable.AsEnumerable(); /// Set the datatable based on the SelectedIndex of <see cref="cboResultsView"/>. switch (cboQuestionViews.SelectedIndex) { case 0: dataTableEnum = dataTableEnum.Where(x => x.Field <int>("StateCode") == 0); break; case 1: dataTableEnum = dataTableEnum.Where(x => x.Field <int>("StateCode") == 1); break; default: return; } if (dataTableEnum.Any()) { dataTable = dataTableEnum.CopyToDataTable(); } else { dataTable.Rows.Clear(); } dgvQuestions.DataSource = dataTable; // Display/order the columns. dgvQuestions.Columns["SearchQuestionId"].Visible = false; dgvQuestions.Columns["SearchId"].Visible = false; dgvQuestions.Columns["ModifiedBy"].Visible = false; dgvQuestions.Columns["ModifiedOn"].Visible = false; dgvQuestions.Columns["CreatedBy"].Visible = false; dgvQuestions.Columns["CreatedOn"].Visible = false; dgvQuestions.Columns["StateCode"].Visible = false; dgvQuestions.Columns["SubjectValue"].DisplayIndex = 0; dgvQuestions.Columns["AnswerValue"].DisplayIndex = 1; }
private void LoadDgvQuestions() { int currentCellRow = 0; int currentCellCol = 0; if (dgvQuestions.CurrentCell != null) { currentCellRow = dgvQuestions.CurrentCell.RowIndex; currentCellCol = dgvQuestions.CurrentCell.ColumnIndex; } DataTable dataTable = SearchQuestion.GetAssociated(CurrentSearch); var dataTableEnum = dataTable.AsEnumerable(); /// Set the datatable based on the SelectedIndex of <see cref="cboResultsView"/>. switch (cboQuestionViews.SelectedIndex) { case 0: dataTableEnum = dataTableEnum.Where(x => x.Field <int>("StateCode") == 0); break; case 1: dataTableEnum = dataTableEnum.Where(x => x.Field <int>("StateCode") == 1); break; default: return; } if (dataTableEnum.Any()) { dataTable = dataTableEnum.CopyToDataTable(); } else { dataTable.Rows.Clear(); } dgvQuestions.DataSource = dataTable; // Display/order the columns. dgvQuestions.Columns["SearchQuestionId"].Visible = false; dgvQuestions.Columns["SearchId"].Visible = false; dgvQuestions.Columns["ModifiedBy"].Visible = false; dgvQuestions.Columns["ModifiedOn"].Visible = false; dgvQuestions.Columns["CreatedBy"].Visible = false; dgvQuestions.Columns["CreatedOn"].Visible = false; dgvQuestions.Columns["StateCode"].Visible = false; dgvQuestions.Columns["SubjectValue"].DisplayIndex = 0; dgvQuestions.Columns["AnswerValue"].DisplayIndex = 1; if (dgvQuestions.RowCount > 0 && dgvQuestions.ColumnCount > 0) { DataGridViewCell selectedCell = dgvQuestions.Rows[currentCellRow].Cells[currentCellCol]; if (selectedCell != null && selectedCell.Visible) { dgvQuestions.CurrentCell = selectedCell; } else { dgvQuestions.CurrentCell = dgvQuestions.FirstDisplayedCell; } } }