private void buttonUpdate_Click(object sender, EventArgs e)
{
if (selectedTest == null)
{
MessageBox.Show("Элемент не выбран");
return;
}
selectedTest.Name = tbName.Text;
selectedTest.PassMark = Convert.ToInt16(tbPassMark.Text);
var updateTest = new Test()
{
id = (int)selectedTest.id,
Name = selectedTest.Name,
PassMark = (short)selectedTest.PassMark
};
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
db.Test.Add(updateTest);
db.Entry(updateTest).State = EntityState.Modified;
db.SaveChanges();
}
Clear();
LoadData();
}
private QuestionControl ConfigurateControl(Question question)
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
var z = from a in db.Answer
where
a.idQuestion == question.id
select new
{
Id = a.Id,
idQuestion = a.idQuestion,
Text = a.Text,
isCorrect = a.isCorrect
};
List <Answer> answers = new List <Answer>();
foreach (var o in z)
{
answers.Add(new Answer()
{
Id = o.Id, idQuestion = o.idQuestion, isCorrect = o.isCorrect, Text = o.Text
});
}
QuestionControl control = new QuestionControl(question, answers);
control.Location = new System.Drawing.Point(28, 63);
control.MaximumSize = new Size(Width, 0);
control.Size = new System.Drawing.Size(Width, 28);
control.Visible = true;
return(control);
}
}
private void buttonAdd_Click(object sender, EventArgs e)
{
string selectedText = comboBoxAcSubs.SelectedItem.ToString().Trim();
AcademicSubject academicSubject = allAcademicSubjects.Find(item => item.Name.Trim().Equals(selectedText));
bool alreadyExist = false;
var x = dataGridView1.Rows;
for (int i = 0; i < x.Count; i++)
{
if (Convert.ToInt32(x[i].Cells["id"].Value) == academicSubject.id)
{
alreadyExist = true;
}
}
if (academicSubject == null || alreadyExist)
{
MessageBox.Show("Данная связь уже существует или предмет не выбран");
return;
}
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
string query = @"Insert Into Test_AcademicSubject Values
(@idTest, @idAcademicSubject)";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@idAcademicSubject", academicSubject.id));
sqlParameters.Add(new SqlParameter("@idTest", test.id));
db.Database.ExecuteSqlCommand(query, sqlParameters.ToArray());
LoadData();
}
}
private void LoadSubject()
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
if (user.Role == UserRole.Teacher)
{
string query = @"Select DISTINCT s.id,s.Name from Subjects as s
JOIN AcademicSubject as AcSu on s.id = AcSu.idSubjects
JOIN AcademicSubject_Teacher as A_T on AcSu.id = A_T.idAcademicSubject
JOIN Teacher as t on t.id = A_T.idTeacher
where t.login = @Login";
SqlParameter parameter = new SqlParameter("@Login", user.Login);
subjects = db.Database.SqlQuery <Subjects>(query, parameter).ToList();
subjects.ForEach(o => comboBoxSubjects.Items.Add(o.Name.Trim()));
}
else
{
db.Subjects.Load();
subjects = db.Subjects.Local.ToBindingList().ToList();
subjects.ForEach(o => comboBoxSubjects.Items.Add(o.Name.Trim()));
}
if (questionList.Count > 0)
{
Subjects subject = subjects.Find(item => item.id.Equals(questionList[0].idSubjects));
comboBoxSubjects.SelectedIndex = subjects.IndexOf(subject);
}
}
}
private void buttonDelete_Click(object sender, EventArgs e)
{
if (selectedGroupTesting == null || updatedGroupTesting == null)
{
MessageBox.Show("Элемент не выбран");
return;
}
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
string query = @"Delete GroupTesting
where idTest=@idTest
and idAcademicGroup=@selectIdAcademicGroup
and isAvailable=@selectIsAvailable
and expirationDate=@selectExpirationDate";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@idTest", test.id));
sqlParameters.Add(new SqlParameter("@selectIdAcademicGroup", selectedGroupTesting.idAcademicGroup));
sqlParameters.Add(new SqlParameter("@selectIsAvailable", selectedGroupTesting.isAvailable));
sqlParameters.Add(new SqlParameter("@selectExpirationDate", selectedGroupTesting.expirationDate));
db.Database.ExecuteSqlCommand(query, sqlParameters.ToArray());
}
Clear();
LoadData();
}
private void LoadAcSubs()
{
if (user.Role != UserRole.Admin)
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
string query = @"Select AcS.id, AcS.Name, s.id As'idSubjects' from AcademicSubject as AcS
JOIN AcademicSubject_Teacher as AS_T ON AS_T.idAcademicSubject = AcS.id
JOIN Teacher as t on t.id = AS_T.idTeacher
JOIN Subjects as s on s.id = AcS.idSubjects
where t.login = @Login";
SqlParameter parameter = new SqlParameter("@Login", user.Login);
academicSubjects = db.Database.SqlQuery <AcademicSubject>(query, parameter).ToList();
academicSubjects.ForEach(o => comboBoxAcSubs.Items.Add(o.Name.Trim()));
}
}
else
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
db.AcademicSubject.Load();
academicSubjects = db.AcademicSubject.Local.ToBindingList().ToList();
academicSubjects.ForEach(o => comboBoxAcSubs.Items.Add(o.Name.Trim()));
}
}
}
private void Statisticks_Load(object sender, EventArgs e)
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
string query = @"Select ag.Name as AcademicGroup,s.Surname,s.Name,s.Patronymic,e.ExamDate,e.Mark,
CONVERT(bit,(CASE WHEN e.Mark>=t.PassMark Then 1 ElSE 0 END)) As IsPassed
from Examination as e
JOIN Student as s on e.idStudent = s.id
JOIN Test as t on t.id = e.idTest
JOIN AcademicGroup as ag on s.idAcademicGroup = ag.id
Where t.id = @idTest";
SqlParameter parameter = new SqlParameter("@idTest", test.id);
var z = db.Database.SqlQuery <TestStatisticks>(query, parameter).ToList();
dataGridView1.DataSource = z.ToList();
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.Columns["AcademicGroup"].HeaderText = "Группа";
dataGridView1.Columns["Surname"].HeaderText = "Фамилия";
dataGridView1.Columns["Name"].HeaderText = "Имя";
dataGridView1.Columns["Patronymic"].HeaderText = "Отчество";
dataGridView1.Columns["Mark"].HeaderText = "Балл";
dataGridView1.Columns["ExamDate"].HeaderText = "Дата сдачи теста";
dataGridView1.Columns["isPassed"].HeaderText = "Сдано";
}
}
private void LoadData()
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
var data = from gt in db.GroupTesting
join ag in db.AcademicGroup
on gt.idAcademicGroup equals ag.id
where gt.idTest == test.id
select new
{
GroupName = ag.Name,
gt.expirationDate,
gt.isAvailable
};
string query = "Select gt.idTest,gt.idAcademicGroup,gt.expirationDate,gt.isAvailable from GroupTesting as gt Where gt.idTest = @idTest";
SqlParameter parameter = new SqlParameter("@idTest", test.id);
List <GroupTesting> groupTesting = db.Database.SqlQuery <GroupTesting>(query, parameter).ToList();
groupTestingList = groupTesting.ToList();
dataGridView1.DataSource = data.ToList();
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.Columns["GroupName"].HeaderText = "Группа";
dataGridView1.Columns["expirationDate"].HeaderText = "Дата окончания тестирования";
dataGridView1.Columns["isAvailable"].HeaderText = "Доступен студентам";
}
}
private void buttonAdd_Click(object sender, EventArgs e)
{
string selectedText = comboBox1.SelectedItem.ToString().Trim();
AcademicGroup academicGroup = academicGroups.Find(item => item.Name.Trim().Equals(selectedText));
bool alreadyExist = false;
var x = dataGridView1.Rows;
for (int i = 0; i < x.Count; i++)
{
if (Convert.ToString(x[i].Cells["GroupName"].Value) == academicGroup.Name)
{
alreadyExist = true;
}
}
if (academicGroup == null || alreadyExist)
{
MessageBox.Show("Данная связь уже существует или предмет не выбран");
return;
}
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
string query = @"INSERT into GroupTesting(idTest,idAcademicGroup,expirationDate,isAvailable) VALUES
(@idTest, @idAcademicGroup , @expirationDate, @isAvailable)";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@idTest", test.id));
sqlParameters.Add(new SqlParameter("@idAcademicGroup", academicGroup.id));
sqlParameters.Add(new SqlParameter("@expirationDate", dateTimePicker1.Value));
sqlParameters.Add(new SqlParameter("@isAvailable", checkBox1.Checked));
db.Database.ExecuteSqlCommand(query, sqlParameters.ToArray());
}
LoadData();
}
private void buttonAdd_Click(object sender, EventArgs e)
{
string selectedText = comboBox1.SelectedItem.ToString().Trim();
AcademicSubject academicSubject = academicSubjects.Find(item => item.Name.Trim().Equals(selectedText));
bool alreadyExist = false;
var x = dataGridView1.Rows;
for (int i = 0; i < x.Count; i++)
{
if (Convert.ToInt32(x[i].Cells["id"].Value) == academicSubject.id)
{
alreadyExist = true;
}
}
if (academicSubject == null || alreadyExist)
{
MessageBox.Show("Данная связь уже существует или предмет не выбран");
return;
}
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
db.AddAcSubjects(idTeacher, academicSubject.id);
LoadData();
}
}
private void LoadData()
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
SqlParameter param = new SqlParameter("idTest", test.id.ToString());
List <int> idQuestions = db.Database.SqlQuery <int>("Select q_t.idQuestion from Question_Test as q_t Where q_t.idTest = @idTest", param).ToList();
if (idQuestions.Count != 0)
{
var questions = from q in db.Question
where
idQuestions.Contains(q.id)
select new
{
id = q.id,
Text = q.Text,
idSubjects = q.idSubjects,
Mark = q.Mark
};
questionList = new List <Question>();
foreach (var o in questions)
{
questionList.Add(new Question()
{
id = o.id, Text = o.Text, idSubjects = o.idSubjects, Mark = o.Mark
});
}
questionControls = AddControls();
ChangeSizeControls(questionControls);
}
}
}
private void LoadData()
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
var x = from s in db.Student
select new
{
s.id,
s.Surname,
s.Name,
s.Patronymic,
academicGroupName = s.AcademicGroup.Name,
s.Login
};
dataGridView1.DataSource = x.ToList();
dataGridView1.Columns["id"].Visible = false;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.Columns["Surname"].HeaderText = "Фамилия";
dataGridView1.Columns["Name"].HeaderText = "Имя";
dataGridView1.Columns["Patronymic"].HeaderText = "Отчество";
dataGridView1.Columns["academicGroupName"].HeaderText = "Группа";
dataGridView1.Columns["Login"].HeaderText = "Логин";
}
}
private void btnEnter_Click(object sender, EventArgs e)
{
bool allDataDontInserted = tbSurname.Text == null
& tbName.Text == null
& tbPatronymic.Text == null
& tbLogin.Text == null
& tbPassword.Text == null;
if (allDataDontInserted)
{
return;
}
DialogResult result = MessageBox.Show("Вы уверены, что хотите сохранить изменения?",
"Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result != DialogResult.Yes)
{
return;
}
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
using (SqlConnection connection = new SqlConnection(db.Database.Connection.ConnectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand(
"sp_addlogin @Login, @Password, @DBNAME", connection))
{
command.Parameters.Add(new SqlParameter("@Login", tbLogin.Text));
command.Parameters.Add(new SqlParameter("@Password", tbPassword.Text));
command.Parameters.Add(new SqlParameter("@DBNAME", Properties.Settings.Default.DataBase));
SqlDataReader reader = command.ExecuteReader();
}
using (SqlCommand command = new SqlCommand(
"sp_adduser @Login, @Login, @Role", connection))
{
command.Parameters.Add(new SqlParameter("@Login", tbLogin.Text));
command.Parameters.Add(new SqlParameter("@Role", "teacher"));
SqlDataReader reader = command.ExecuteReader();
}
}
db.Teacher.Add(new Teacher()
{
Surname = tbSurname.Text,
Name = tbName.Text,
Patronymic = tbPatronymic.Text,
Login = tbLogin.Text,
});
db.SaveChanges();
}
LoadData();
}
private void buttonDelete_Click(object sender, EventArgs e)
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
db.DeleteAcSubjects(idTeacher, selectedAcademicSubject.id);
}
LoadData();
}
private void buttonAdd_Click(object sender, EventArgs e)
{
short passMark;
bool text = tbName.Text.Equals("");
bool number = !Int16.TryParse(tbPassMark.Text, out passMark);
bool acsub = comboBoxAcSubs.SelectedItem != null;
if (text | number)
{
return;
}
if (acsub)
{
string selectedText = comboBoxAcSubs.SelectedItem.ToString().Trim();
AcademicSubject academicSubject = academicSubjects.Find(item => item.Name.Trim().Equals(selectedText));
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
string query = @"exec dbo.addtest @TextName, @PassMark, @IdAcSub";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@TextName", tbName.Name));
sqlParameters.Add(new SqlParameter("@PassMark", passMark));
sqlParameters.Add(new SqlParameter("@IdAcSub", academicSubject.id));
db.Database.ExecuteSqlCommand(query, sqlParameters.ToArray());
}
Clear();
LoadData();
}
else if (user.Role.Equals(UserRole.Admin))
{
DialogResult result = MessageBox.Show("Предмет не задан! Тест не будет виден, пока ему его не присовоят.", "Предупреждение", MessageBoxButtons.OKCancel);
if (result.Equals(DialogResult.OK))
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
db.Test.Add(new Test()
{
Name = tbName.Text,
PassMark = passMark
});
db.SaveChanges();
}
Clear();
LoadData();
}
else
{
return;
}
}
else
{
MessageBox.Show("Предмет не задан!");
}
}
private void LoadData()
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
var users = (
from s in db.Student
select new
{
s.Surname,
s.Name,
s.Patronymic,
s.Login,
}
).Concat
(
from t in db.Teacher
select new
{
Surname = t.Surname,
Name = t.Name,
Patronymic = t.Patronymic,
Login = t.Login
}
);
var userToList = new
{
Surname = users.First().Surname,
Name = users.First().Name,
Patronymic = users.First().Patronymic,
Login = users.First().Login,
role = db.GetRole(users.First().Login).FirstOrDefault()
};
var UserList = new[] { userToList }.ToList();
UserList.Clear();
users.ToList().ForEach(o =>
{
string currentRole = db.GetRole(o.Login).FirstOrDefault();
UserList.Add(new
{
Surname = o.Surname,
Name = o.Name,
Patronymic = o.Patronymic,
Login = o.Login,
role = currentRole
});
});
dataGridView1.DataSource = UserList;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.Columns["Surname"].HeaderText = "Фамилия";
dataGridView1.Columns["Name"].HeaderText = "Имя";
dataGridView1.Columns["Patronymic"].HeaderText = "Отчество";
dataGridView1.Columns["Login"].HeaderText = "Логин";
dataGridView1.Columns["role"].HeaderText = "Роль";
}
}
private void LoadAcGroups()
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
db.AcademicGroup.Load();
academicGroups = db.AcademicGroup.Local.ToBindingList().ToList();
academicGroups.ForEach(o => comboBox1.Items.Add(o.Name.Trim()));
}
}
private void LoadAcSubjects()
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
db.AcademicSubject.Load();
allAcademicSubjects = db.AcademicSubject.Local.ToBindingList().ToList();
allAcademicSubjects.ForEach(o => comboBoxAcSubs.Items.Add(o.Name.Trim()));
}
}
private void Students_Load(object sender, EventArgs e)
{
LoadData();
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
db.AcademicGroup.Load();
academicGroups = db.AcademicGroup.Local.ToBindingList().ToList();
academicGroups.ForEach(o => comboBox1.Items.Add(o.Name.Trim()));
}
}
private void LoadAllTest()
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
string query = @"Select t.id, t.Name, t.PassMark from test as t";
tests = db.Database.SqlQuery <Test>(query).ToList();
dataGridView1.DataSource = tests;
ConfigureDataGridView();
}
}
private void UpdateAttributes()
{
if (!selectedGroupTesting.idAcademicGroup.Equals(updatedGroupTesting.idAcademicGroup))
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
string query = @"Update GroupTesting Set idAcademicGroup = @updateIdAcademicGroup
where idTest=@idTest and idAcademicGroup=@selectIdAcademicGroup";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@idTest", test.id));
sqlParameters.Add(new SqlParameter("@updateIdAcademicGroup", updatedGroupTesting.idAcademicGroup));
sqlParameters.Add(new SqlParameter("@selectIdAcademicGroup", selectedGroupTesting.idAcademicGroup));
db.Database.ExecuteSqlCommand(query, sqlParameters.ToArray());
}
}
if (!selectedGroupTesting.expirationDate.Equals(updatedGroupTesting.expirationDate))
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
string query = @"Update GroupTesting Set expirationDate = @updateExpirationDate
where idTest=@idTest
and idAcademicGroup=@updateIdAcademicGroup
and expirationDate=@selectExpirationDate";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@idTest", test.id));
sqlParameters.Add(new SqlParameter("@updateIdAcademicGroup ", updatedGroupTesting.idAcademicGroup));
sqlParameters.Add(new SqlParameter("@updateExpirationDate", updatedGroupTesting.expirationDate));
sqlParameters.Add(new SqlParameter("@selectExpirationDate", selectedGroupTesting.expirationDate));
db.Database.ExecuteSqlCommand(query, sqlParameters.ToArray());
}
}
if (!selectedGroupTesting.isAvailable.Equals(updatedGroupTesting.isAvailable))
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
string query = @"Update GroupTesting Set isAvailable = @updateIsAvailable
where idTest=@idTest
and idAcademicGroup=@updateIdAcademicGroup
and isAvailable=@selectIsAvailable";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@idTest", test.id));
sqlParameters.Add(new SqlParameter("@updateIdAcademicGroup ", updatedGroupTesting.idAcademicGroup));
sqlParameters.Add(new SqlParameter("@updateIsAvailable", updatedGroupTesting.isAvailable));
sqlParameters.Add(new SqlParameter("@selectIsAvailable", selectedGroupTesting.isAvailable));
db.Database.ExecuteSqlCommand(query, sqlParameters.ToArray());
}
}
}
private void Save(List <Answer> saveList)
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
saveList.ForEach(o =>
{
o.idQuestion = Question.id;
db.Answer.Add(o);
});
db.SaveChanges();
}
}
private static void Delete(List <Question> deleteList)
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
deleteList.ForEach(o =>
{
db.Question.Attach(o);
db.Question.Remove(o);
});
db.SaveChanges();
}
}
private void LoadData()
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
var z = db.GetAcSubjects(idTeacher);
dataGridView1.DataSource = z.ToList();
dataGridView1.Columns["id"].Visible = false;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.Columns["Name"].HeaderText = "Предмет";
}
}
private void Delete(List <Answer> deleteList)
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
deleteList.ForEach(o =>
{
db.Answer.Attach(o);
db.Answer.Remove(o);
});
db.SaveChanges();
}
}
private User CreateUser()
{
User user;
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
string login = db.GetLoginT().FirstOrDefault();
string role = db.GetRole(login).FirstOrDefault();
user = new User(login, role);
}
return(user);
}
private void LoadTestWithOutAcSub()
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
string query = @"Select t.id,t.Name,t.PassMark from Test_AcademicSubject as T_A
RIGHT Outer JOIN Test as t on t.id = T_A.idTest
Where T_A.idAcademicSubject is NULL";
tests = db.Database.SqlQuery <Test>(query).ToList();
dataGridView1.DataSource = tests;
ConfigureDataGridView();
}
}
private void LoadData()
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
db.Teacher.Load();
dataGridView1.DataSource = db.Teacher.Local.ToBindingList();
dataGridView1.Columns["id"].Visible = false;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.Columns["Surname"].HeaderText = "Фамилия";
dataGridView1.Columns["Name"].HeaderText = "Имя";
dataGridView1.Columns["Patronymic"].HeaderText = "Отчество";
dataGridView1.Columns["Login"].HeaderText = "Логин";
}
}
private void buttonDelete_Click(object sender, EventArgs e)
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
string query = @"Delete from Test_AcademicSubject
Where Test_AcademicSubject.idAcademicSubject = @idAcademicSubject
and Test_AcademicSubject.idTest = @idTest";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@idAcademicSubject", selectedAcademicSubject.id));
sqlParameters.Add(new SqlParameter("@idTest", test.id));
db.Database.ExecuteSqlCommand(query, sqlParameters.ToArray());
}
LoadData();
}
private void LoadData()
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
db.GetCurrentTest().Load();
tests = db.GetCurrentTest().ToList();
dataGridView1.DataSource = tests;
dataGridView1.Columns["Name"].HeaderText = "Название теста";
dataGridView1.Columns["PassMark"].HeaderText = "Проходной балл";
dataGridView1.Columns["id"].Visible = false;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
}
