public string Delete(DeleteUser d) { string Message = ""; SqlConnection con = new SqlConnection("Data Source=LAPTOP-HGH9CCBA;Initial Catalog=MyTestDB;Persist Security Info=True;User ID=sa;Password=311000;Pooling=False"); con.Open(); SqlCommand cmd = new SqlCommand("delete UserTab where UserID = @UserID", con); cmd.Parameters.AddWithValue("@UserID", d.UID); int res = cmd.ExecuteNonQuery(); if (res == 1) { Message = "Succesfully deleted"; } else { Message = "Failed to delete"; } return(Message); }
public string Delete(DeleteUser d) { string msg = ""; con.Open(); SqlCommand cmd = new SqlCommand("Delete UserTab where UserID = @UserID", con); cmd.Parameters.AddWithValue("@UserID", d.UID); int res = cmd.ExecuteNonQuery(); if (res == 1) { msg = "Successfully Deleted"; } else { msg = "Failed to Deleted"; } return(msg); }
public string Delete(DeleteUser d) { string msg = ""; SqlConnection con = new SqlConnection("Data Source=DESKTOP-LDV7NOV;Initial Catalog=WCFService1;Integrated Security=True"); con.Open(); SqlCommand cmd = new SqlCommand("delete UserTab where UserID = @UserID", con); cmd.Parameters.AddWithValue("@UserID", d.UID); int res = cmd.ExecuteNonQuery(); if (res == 1) { msg = "Successfully deleted"; } else { msg = "Failed to delete"; } return(msg); }
public string Delete(DeleteUser d) { string msg = ""; SqlConnection con = new SqlConnection("Data Source=TEPOS;Initial Catalog=TestDB;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"); con.Open(); SqlCommand cmd = new SqlCommand("delete UserTab where UserID = @UserID", con); cmd.Parameters.AddWithValue("@UserID", d.UID); int res = cmd.ExecuteNonQuery(); if (res == 1) { msg = "Berhasil Hapus"; } else { msg = "Gagal Hapus"; } return(msg); }
public string Delete(DeleteUser d) { string msg = ""; SqlConnection con = new SqlConnection("Data Source=DESKTOP-0QLRLVG;Initial Catalog=CrudDB;Persist Security Info=True;User ID=sa; Password=albana123"); con.Open(); SqlCommand cmd = new SqlCommand("delete dbo.UserTab where UserId = @UserId", con); cmd.Parameters.AddWithValue("@UserId", d.UID); int res = cmd.ExecuteNonQuery(); if (res == 1) { msg = "Successfully deleted"; } else { msg = "Failed to deleted"; } return(msg); }
public string Delete(DeleteUser d) { string msg = ""; SqlConnection con = new SqlConnection("Data Source=DESKTOP-9BLFC43\\AFANDISQL;Initial Catalog=PatWcf;Persist Security Info=True;User ID=sa; Password=Nurafandi09"); con.Open(); SqlCommand cmd = new SqlCommand("delete UserTab where UserID = @UserID", con); cmd.Parameters.AddWithValue("@UserID", d.UID); int res = cmd.ExecuteNonQuery(); if (res == 1) { msg = "Successfully deleted"; } else { msg = "Failed to deleted"; } return(msg); }
public string Delete(DeleteUser d) { string msg = ""; SqlConnection con = new SqlConnection("Data Source=DESKTOP-CM1O7BQ;Initial Catalog=MyTestDB;User ID=sa;Password=123"); con.Open(); SqlCommand cmd = new SqlCommand("delete UserTab where UserID = @UserID", con); cmd.Parameters.AddWithValue("@UserID", d.UID); int res = cmd.ExecuteNonQuery(); if (res == 1) { msg = "Successfully Updated"; } else { msg = "Failed to Update"; } return(msg); }
public string Delete(DeleteUser d) { string msg = ""; SqlConnection con = new SqlConnection("Data Source=DESKTOP-9DIL2HS; Initial Catalog = MyTestDB; Persist Security Info = True; User ID = sa; Password = bramantyo; Pooling = False"); con.Open(); SqlCommand cmd = new SqlCommand("delete UserTab where UserID = @UserID", con); cmd.Parameters.AddWithValue("@UserID", d.UID); int res = cmd.ExecuteNonQuery(); if (res == 1) { msg = "Successfully deleted"; } else { msg = "Failed to delete"; } return(msg); }
public string Delete(DeleteUser d) { string msg = ""; SqlConnection con = new SqlConnection("Data Source=DESKTOP-KT69I3S;Initial Catalog=WCFService;Persist Security Info=True;User ID=sa;Password=ifan99"); con.Open(); SqlCommand cmd = new SqlCommand("Delete UserTable where UserID = @UserID", con); cmd.Parameters.AddWithValue("@UserID", d.UID); int res = cmd.ExecuteNonQuery(); if (res == 1) { msg = "Successfully Deleted"; } else { msg = "Failed to Delete"; } return(msg); }