private void button3_Click(object sender, EventArgs e)
{
var studentTableAdapter = new Learning_databasesDataSetTableAdapters.StudentsTableAdapter();
var studentsTable = studentTableAdapter.InsertStudent(FirstName.Text, SecondName.Text, int.Parse(Age.Text), Gender.Text, int.Parse(CourseId.Text));
this.studentsTableAdapter.Fill(this.learning_databasesDataSet.Students);
}
private void button2_Click(object sender, EventArgs e)
{
var studentTableAdapter = new Learning_databasesDataSetTableAdapters.StudentsTableAdapter();
var studentsTable = studentTableAdapter.GetDataByStudentSecondName(textBox1.Text);
StringBuilder allNames = new StringBuilder();
// Loop through each returned student row and add name/second name to string
foreach (var studentRow in studentsTable.Rows.Cast <Learning_databasesDataSet.StudentsRow>())
{
allNames.AppendLine(studentRow.Name + " " + studentRow.SecondName);
}
MessageBox.Show(allNames.ToString());
}
private void DeleteButton_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count == 1)
{
DataRowView dataViewRow = dataGridView1.SelectedRows[0].DataBoundItem as DataRowView;
Learning_databasesDataSet.StudentsRow studentRow
= (Learning_databasesDataSet.StudentsRow)dataViewRow.Row;
var studentId = studentRow.Id;
var result = MessageBox.Show("Are you sure you want to delete student " + studentRow.Name + " " + studentRow.SecondName, "Delete Student", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
var StudentsTableAdapter = new Learning_databasesDataSetTableAdapters.StudentsTableAdapter();
StudentsTableAdapter.DeleteStudent(studentId);
dataGridView1.Rows.RemoveAt(this.dataGridView1.SelectedRows[0].Index);
}
}
else
{
MessageBox.Show("No student selected");
}
}
