public void UpdateUser(string UserID, string FirstName) { User oUser = new User(); oUser.UserID = UserID; oUser.FirstName = FirstName; this.UpdateUser(oUser); } public void UpdateUser(User UserID,User FirstName) { // etc.etc. as you already have it coded. }~~Bonnie
>private string UserID; >private string FirstName; > >UserID = txtUserID.Text; >FirstName = txtFirstName.Text; > >ScrapDB.UpdateUser(UserID, FirstName); // I am not sure of this part! It throws these errors: >>
>public class User > { > public string UserID; > public string FirstName; > public string LastName; > public string PhoneExt; > public string DepartmentCode; > public string PositionName; > > } > >public void UpdateUser(User UserID,User FirstName) > >SqlConnection UpdateUserConnection = GetConnection(); >{ > > string UpdateStatement = "UPDATE UserInfo SET " > + "UserID = @UserID, " > + "FirstName = @FirstName "; > >SqlCommand UpdateCommand = new SqlCommand(UpdateStatement, UpdateUserConnection); >UpdateCommand.Parameters.Add("@UserID", UserID); >UpdateCommand.Parameters.Add("@FirstName", FirstName); > >UpdateUserConnection.Open(); > >UpdateCommand.ExecuteNonQuery(); >UpdateUserConnection.Close(); >} >>Any suggestion are most welcomed!