Guest User

Untitled

a guest
Apr 16th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.29 KB | None | 0 0
  1. public static void Register_User(string FirstName, string LastName, string UserName, string Password, string Email, string SecurityQuestion, string SecurityAnswer)
  2. {
  3. DAO db = new DAO();
  4. //DataSet ds;
  5. SqlParameter pFirstName = new SqlParameter("@FirstName", SqlDbType.NVarChar);
  6. SqlParameter pLastName = new SqlParameter("@LastName", SqlDbType.NVarChar);
  7. SqlParameter pUserName = new SqlParameter("@UserName", SqlDbType.NVarChar);
  8. SqlParameter pPassword = new SqlParameter("@Password", SqlDbType.NVarChar);
  9. SqlParameter pEmail = new SqlParameter("@Email", SqlDbType.NVarChar);
  10. SqlParameter pSecurityQuestion = new SqlParameter("@SecurityQuestion", SqlDbType.NVarChar);
  11. SqlParameter pSecurityAnswer = new SqlParameter("@SecurityAnswer", SqlDbType.NVarChar);
  12. SqlParameter[] p = new SqlParameter[7];
  13. pFirstName.Value = FirstName;
  14. pLastName.Value = LastName;
  15. pUserName.Value = UserName;
  16. pPassword.Value = Password;
  17. pEmail.Value = Email;
  18. pSecurityQuestion.Value = SecurityQuestion;
  19. pSecurityAnswer.Value = SecurityAnswer;
  20. p[0] = pFirstName;
  21. p[1] = pLastName;
  22. p[2] = pUserName;
  23. p[3] = pPassword;
  24. p[4] = pEmail;
  25. p[5] = pSecurityQuestion;
  26. p[6] = pSecurityAnswer;
  27. object result = db.getStoredProcedureScalar("Register_User", p);
  28. }
Add Comment
Please, Sign In to add comment