Advertisement
Guest User

Untitled

a guest
Jul 4th, 2017
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.22 KB | None | 0 0
  1. public class AnswerModel
  2. {
  3. public void Test()
  4. {
  5.     string connectionString = "Data Source=MyDBSOURCE;Initial Catalog=MyDataBase;Integrated Security=SSPI;MultipleActiveResultSets=True";
  6.  
  7.     string strSQLUpdateUser = "Update [User] SET UserEmail = @UserEmail, UserPassword = @UserPassword WHERE UserID = @UserID";
  8.     string strSQLUpdateUserProfil = "Update UserProfile SET UserProfileText = @UserProfileText WHERE UserID = @UserID";
  9.  
  10.     using (var sqlcon = new SqlConnection(connectionString))
  11.     {
  12.         using (var updateUserCmd = new SqlCommand(strSQLUpdateUser, sqlcon))
  13.         {
  14.  
  15.             updateUserCmd.Parameters.AddWithValue("@UserEmail", tbEmail.Text);
  16.             updateUserCmd.Parameters.AddWithValue("@UserPassword", tbAdgangskode.Text);
  17.             updateUserCmd.Parameters.AddWithValue("@UserID", idValue);
  18.  
  19.             updateUserCmd.ExecuteNonQuery();
  20.         }
  21.         using (var updateUserProfile = new SqlCommand(strSQLUpdateUserProfil, sqlcon))
  22.         {
  23.             updateUserProfile.Parameters.AddWithValue("@UserProfileText", tbProfilTekst.Text);
  24.             updateUserProfile.Parameters.AddWithValue("@UserID", idvalue);
  25.  
  26.             updateUserProfile.ExecuteNonQuery();
  27.         }
  28.     }
  29. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement