private void deleteButton_Click(object sender, EventArgs e)
{
using (LinqToSqlDataContext context = new LinqToSqlDataContext()) {
Student_Table student = context.Student_Tables.SingleOrDefault(StudentName => StudentName.FirstName == this.studentList.SelectedItem.ToString());
context.Student_Tables.DeleteOnSubmit(student);
context.SubmitChanges();
MessageBox.Show("Record Deleted");
this.studentList.Items.Clear();
PopulateListBox();
ClearFileds();
};
}
private void updateButton_Click(object sender, EventArgs e)
{
using (LinqToSqlDataContext context = new LinqToSqlDataContext())
{
Student_Table student = context.Student_Tables.SingleOrDefault(StudentName => StudentName.FirstName == this.studentList.SelectedItem.ToString());
student.LastName = this.lastName.Text;
student.City = this.city.Text;
student.State = this.state.Text;
student.Nationality = this.nationality.Text;
context.SubmitChanges();
MessageBox.Show("Record Updated");
this.studentList.Items.Clear();
PopulateListBox();
};
}
private void addButton_Click(object sender, EventArgs e)
{
using (LinqToSqlDataContext context = new LinqToSqlDataContext())
{
Student_Table student = new Student_Table();
student.FirstName = this.firstName.Text;
student.LastName = this.lastName.Text;
student.City = this.city.Text;
student.State = this.state.Text;
student.Nationality = this.nationality.Text;
context.Student_Tables.InsertOnSubmit(student);
context.SubmitChanges();
MessageBox.Show("Record Added");
this.studentList.Items.Clear();
PopulateListBox();
};
}
partial void DeleteStudent_Table(Student_Table instance);
partial void UpdateStudent_Table(Student_Table instance);
partial void InsertStudent_Table(Student_Table instance);
