Guest User

Untitled

a guest
Dec 15th, 2018
137
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.60 KB | None | 0 0
  1. SqlConnection conn = new SqlConnection("data source=.\SQLEXPRESS; initial catalog=forum; user id=sa; password=moomin63549;";
  2.  
  3. string sql = "insert into users(email, userpass, accesslevel) values(@mail, @pass, @lvl)";
  4.  
  5. List<SqlParameter> args = new List<SqlParameter>();
  6. args.Add(new SqlParameter("@mail", txtEmail.Text);
  7. args.Add(new SqlParameter("@pass", HashIt(txtPassword.Text)); // HashIt function returns a hashed string for the password value
  8. args.Add(new SqlParameter("@lvl", ddlAccessLevel.SelectedItem.Value);
  9.  
  10. SqlCommand cmd = new SqlCommand(sql, conn);
  11. cmd.Parameters.AddRange(args.ToArray());
Add Comment
Please, Sign In to add comment