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"); } }