private void PrintTableWithJoinStatement() { var subjects = SelectDataFromDataBase.SelectSubjectList(); string qColumn = ""; foreach (var pair in subjects) { qColumn += $", `progress`.`{pair.Value}`"; } TablePreview_dataGridView.DataSource = SelectDataFromDataBase.SelectAllFromTable( $"SELECT `progress`.`id`, `pupils`.`name`, `pupils`.`surname`{qColumn} FROM `progress` INNER JOIN `pupils` ON `progress`.`pupilID` = `pupils`.`id`;", FormColumnsList(subjects)); TablePreview_dataGridView.AutoResizeColumns(); TablePreview_dataGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; TablePreview_dataGridView.Refresh(); }
private void SelectTable_comboBox_SelectedIndexChanged(object sender, EventArgs e) { if (SelectTable_comboBox.SelectedIndex > -1) { if (SelectTable_comboBox.SelectedValue.ToString() == "progress") { PrintTableWithJoinStatement(); } else { TablePreview_dataGridView.DataSource = SelectDataFromDataBase.SelectAllFromTable(SelectTable_comboBox.SelectedValue.ToString()); TablePreview_dataGridView.AutoResizeColumns(); TablePreview_dataGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; TablePreview_dataGridView.Refresh(); } } }