private void TeacherSort_CheckedChanged(object sender, EventArgs e)
{
if (TeacherSort.Checked)
{
StudyloadGridView.Sort(StudyloadGridView.Columns[0], ListSortDirection.Ascending);
}
}
private void DisciplineSort_CheckedChanged(object sender, EventArgs e)
{
if (DisciplineSort.Checked)
{
StudyloadGridView.Sort(StudyloadGridView.Columns[1], ListSortDirection.Ascending);
}
}
private void SelectStudyload(string text)
{
int g_width = 0;
if (text == StudyloadHintText)
{
text = String.Empty;
}
MySqlDataAdapter adap = new MySqlDataAdapter();
using (MySqlConnection con = DBUtils.GetDBConnection())
{
con.Open();
MySqlCommand cmd = new MySqlCommand("TeacherDisciplineMatch", con)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("_name", text);
adap.SelectCommand = cmd;
DataTable table = new DataTable();
adap.Fill(table);
StudyloadGridView.DataSource = table;
StudyloadGridView.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
StudyloadGridView.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
foreach (DataGridViewColumn column in StudyloadGridView.Columns)
{
if (column.Visible == true)
{
g_width += column.Width;
}
}
Width = g_width + 90;
}
if (TeacherSort.Checked)
{
StudyloadGridView.Sort(StudyloadGridView.Columns[0], ListSortDirection.Ascending);
}
}
