public string Update(UpdateUser u) { string Message = ""; SqlConnection con = new SqlConnection("Data Source=ARIFBUDIMANAR;Initial Catalog=crudDB;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"); con.Open(); SqlCommand cmd = new SqlCommand("Update Usertab set Name = @Name, Email = @Email where UserID = @UserID", con); cmd.Parameters.AddWithValue("@UserID", u.UID); cmd.Parameters.AddWithValue("@Name", u.Name); cmd.Parameters.AddWithValue("@Email", u.Email); int res = cmd.ExecuteNonQuery(); if (res == 1) { Message = "Berhasil Update Data"; } else { Message = "Gagal Update Data"; } return(Message); }
public string Update(UpdateUser u) { string Message = ""; SqlConnection con = new SqlConnection("Data Source=DESKTOP-Q6TINDB; Initial Catalog=WCF;Persist Security Info=True;User ID=sa; Password=123ricki"); con.Open(); SqlCommand cmd = new SqlCommand("Update UserTab set Name = @Name, Email = @Email where UserID= @UserID", con); cmd.Parameters.AddWithValue("@UserID", u.UID); cmd.Parameters.AddWithValue("@name", u.Name); cmd.Parameters.AddWithValue("@Email", u.Email); int res = cmd.ExecuteNonQuery(); if (res == 1) { Message = "Successfuly Updated"; } else { Message = "Failed to Update"; } return(Message); }