private void ViewTablebutton_Click(object sender, EventArgs e)
{
DataTable src_table;
switch (ChooseTableComboBox.GetItemText(ChooseTableComboBox.SelectedItem))
{
case "faculties":
src_table = UniDB.faculties;
break;
case "departments":
src_table = UniDB.departments;
break;
case "teachers":
src_table = UniDB.teachers;
break;
case "students":
src_table = UniDB.students;
break;
case "grades":
src_table = UniDB.grades;
break;
case "disciplines":
src_table = UniDB.disciplines;
break;
case "stud_groups":
src_table = UniDB.stud_groups;
break;
case "disciplines_teachers":
src_table = UniDB.disciplines_teachers;
break;
default: // "students_disciplines"
src_table = UniDB.students_disciplines;
break;
}
view_table_src.DataSource = src_table;
BindingSource view_table_colums = new BindingSource();
IList <string> namesColums = new List <string>();
foreach (var colum in src_table.Columns)
{
namesColums.Add(colum.ToString());
}
view_table_colums.DataSource = namesColums;
view_table_src.Filter = null;
ChooseFieldComboBox.DataSource = view_table_colums;
}
private void Updatebutton_Click(object sender, EventArgs e)
{
TableGridView.CurrentCell.Value = UpdatetextBox.Text;
try
{
switch (ChooseTableComboBox.GetItemText(ChooseTableComboBox.SelectedItem))
{
case "faculties":
builder.DataAdapter = faculties1;
faculties1.UpdateCommand = builder.GetUpdateCommand();
faculties1.Update(UniDB.faculties);
break;
case "departments":
builder.DataAdapter = departments1;
departments1.UpdateCommand = builder.GetUpdateCommand();
departments1.Update(UniDB.departments);
break;
case "teachers":
builder.DataAdapter = teachers1;
teachers1.UpdateCommand = builder.GetUpdateCommand();
teachers1.Update(UniDB.teachers);
break;
case "students":
builder.DataAdapter = students1;
students1.UpdateCommand = builder.GetUpdateCommand();
students1.Update(UniDB.students);
break;
case "grades":
builder.DataAdapter = grades1;
grades1.UpdateCommand = builder.GetUpdateCommand();
grades1.Update(UniDB.grades);
break;
case "disciplines":
builder.DataAdapter = disciplines1;
disciplines1.UpdateCommand = builder.GetUpdateCommand();
disciplines1.Update(UniDB.disciplines);
break;
case "stud_groups":
builder.DataAdapter = stud_groups1;
stud_groups1.UpdateCommand = builder.GetUpdateCommand();
stud_groups1.Update(UniDB.stud_groups);
break;
case "disciplines_teachers":
builder.DataAdapter = dis_teach1;
dis_teach1.UpdateCommand = builder.GetUpdateCommand();
dis_teach1.Update(UniDB.disciplines_teachers);
break;
default: // "students_disciplines"
builder.DataAdapter = stud_disc1;
stud_disc1.UpdateCommand = builder.GetUpdateCommand();
stud_disc1.Update(UniDB.students_disciplines);
break;
}
}
catch (SqlException ex)
{
for (int i = 0; i < ex.Errors.Count; i++)
{
errorMessages.Append("Index #" + i + "\n" +
"Message: " + ex.Errors[i].Message + "\n" +
"LineNumber: " + ex.Errors[i].LineNumber + "\n" +
"Source: " + ex.Errors[i].Source + "\n" +
"Procedure: " + ex.Errors[i].Procedure + "\n");
}
MessageBox.Show(errorMessages.ToString());
}
}