protected void btnInsert_Click(object sender, EventArgs e) { try { StudentsDS.InsertParameters["St_Id"].DefaultValue = studId.Text; StudentsDS.InsertParameters["St_Fname"].DefaultValue = studFName.Text; StudentsDS.InsertParameters["St_Lname"].DefaultValue = studLName.Text; StudentsDS.InsertParameters["St_Address"].DefaultValue = studAddress.Text; StudentsDS.InsertParameters["St_Age"].DefaultValue = studAge.Text; StudentsDS.InsertParameters["Dept_Id"].DefaultValue = studDepartment.SelectedValue; StudentsDS.Insert(); studId.Text = studFName.Text = studLName.Text = studAddress.Text = studAge.Text = ""; GridView1.DataBind(); Master.ShowAlert("Success", "Row inserted successfully"); } catch (Exception) { Master.ShowAlert("Error", "Cannot insert a row with the provided data"); } }
protected void AddStudentBTN_Click(object sender, EventArgs e) { MembershipCreateStatus createStatus; MembershipUser newUser = Membership.CreateUser(st_UsernameTB.Text, st_PasswordTB.Text, st_EmailTB.Text, "Default Question", "Default Answer", true, out createStatus); switch (createStatus) { case MembershipCreateStatus.Success: AddStudentResultLB.Text = "<i class='icon-ok'></i> The student account was successfully created!"; break; case MembershipCreateStatus.DuplicateUserName: AddStudentResultLB.Text = "<i class='icon-remove'></i> There already exists a student with this username."; break; case MembershipCreateStatus.DuplicateEmail: AddStudentResultLB.Text = "<i class='icon-remove'></i> There already exists a student with this email address."; break; case MembershipCreateStatus.InvalidEmail: AddStudentResultLB.Text = "<i class='icon-remove'></i> The email address you provided in invalid."; break; case MembershipCreateStatus.InvalidAnswer: AddStudentResultLB.Text = "<i class='icon-remove'></i> The security answer was invalid."; break; case MembershipCreateStatus.InvalidPassword: AddStudentResultLB.Text = "<i class='icon-remove'></i> The password you provided is invalid. It must be seven characters long and have at least one non-alphanumeric character."; break; default: AddStudentResultLB.Text = "<i class='icon-remove'></i> There was an unknown error; the user account was NOT created."; break; } if (createStatus == MembershipCreateStatus.Success) { StudentsDS.Insert(); StudentsGridView.DataBind(); } }