public static void Insert(Student_Registration_Form studentToAdd) //used by that add student form to add a new record to the db { var db = new DataClassesDataContext(); db.Student_Registration_Forms.InsertOnSubmit(studentToAdd); db.SubmitChanges(); }
protected void AddStudent_Click(object sender, EventArgs e) { // Create a new student object var student = new Student_Registration_Form { //instantiate values Fname = FirstName.Text, Lname = LastName.Text, Gender = ddlGender.SelectedValue, DOB = Convert.ToDateTime(txtDOB.Text), Address1 = Address.Text, Accomodition_Type = ddlAccomodationType.SelectedValue, Phone = LandLine.Text, Mobile = Mobile.Text, Email = Email.Text, Marital_Status = ddlStatus.SelectedValue, Contact = ddlContact.SelectedValue, Main_Ethnicity = ddlRace.SelectedValue, Faculty = ddlFaculty.SelectedValue, Courses = ddlCourse.SelectedValue, Detailed_Ethnicity = DetailedEnthicity.Text, campus = ddlCampus.SelectedValue }; try { // Submit the data to database via students object Students.Insert(student); } catch (Exception ff) { ErrorMessage.Text = ff.ToString(); } }
partial void DeleteStudent_Registration_Form(Student_Registration_Form instance);
partial void UpdateStudent_Registration_Form(Student_Registration_Form instance);
partial void InsertStudent_Registration_Form(Student_Registration_Form instance);
public static void Delete(Student_Registration_Form studentToDelete) { var db = new DataClassesDataContext(); db.Student_Registration_Forms.Attach(studentToDelete); db.SubmitChanges(); }
public static void Update(Student_Registration_Form oldStudent, Student_Registration_Form newStudent) { var db = new DataClassesDataContext(); db.Student_Registration_Forms.Attach(newStudent, oldStudent); db.SubmitChanges(); }