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();
}
}
}
private void RefreshReviewTable()
{
PupilList_dataGridView.Columns.Clear();
PupilList_dataGridView.DataSource = SelectDataFromDataBase.SelectAllFromTable("pupils");
var btc = new DataGridViewButtonColumn
{
Name = @"Delete_button",
HeaderText = @"Delete pupil",
Text = @"Delete",
UseColumnTextForButtonValue = true
};
PupilList_dataGridView.Columns.Add(btc);
PupilList_dataGridView.AutoResizeColumns();
PupilList_dataGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
PupilList_dataGridView.Refresh();
}
