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);
}
