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();
}
}
}
