Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class AnswerModel
- {
- public void Test()
- {
- string connectionString = "Data Source=MyDBSOURCE;Initial Catalog=MyDataBase;Integrated Security=SSPI;MultipleActiveResultSets=True";
- string strSQLUpdateUser = "Update [User] SET UserEmail = @UserEmail, UserPassword = @UserPassword WHERE UserID = @UserID";
- string strSQLUpdateUserProfil = "Update UserProfile SET UserProfileText = @UserProfileText WHERE UserID = @UserID";
- using (var sqlcon = new SqlConnection(connectionString))
- {
- using (var updateUserCmd = new SqlCommand(strSQLUpdateUser, sqlcon))
- {
- updateUserCmd.Parameters.AddWithValue("@UserEmail", tbEmail.Text);
- updateUserCmd.Parameters.AddWithValue("@UserPassword", tbAdgangskode.Text);
- updateUserCmd.Parameters.AddWithValue("@UserID", idValue);
- updateUserCmd.ExecuteNonQuery();
- }
- using (var updateUserProfile = new SqlCommand(strSQLUpdateUserProfil, sqlcon))
- {
- updateUserProfile.Parameters.AddWithValue("@UserProfileText", tbProfilTekst.Text);
- updateUserProfile.Parameters.AddWithValue("@UserID", idvalue);
- updateUserProfile.ExecuteNonQuery();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement