public string deletePegawai(string id) { Koneksi kon = new Koneksi(); SqlConnection sqlcon = kon.getConnection(); string msg = string.Empty; using (sqlcon) { sqlcon.Open(); string sql = "delete from pegawai where idpegawai = @id"; SqlCommand sqlcom = new SqlCommand(sql, sqlcon); using (sqlcom) { sqlcom.Parameters.AddWithValue("@id", id); int res = sqlcom.ExecuteNonQuery(); msg = (res != 0 ? "Data has been deleted." : "Oops, something went wrong."); } sqlcon.Close(); } return(msg); }