La source ne contient aucun DataRow.

System.Data.DataSetExtensions
à System.Data.DataTableExtensions.LoadTableFromEnumerable[T](IEnumerable`1 source, DataTable table, Nullable`1 options, FillErrorEventHandler errorHandler) à System.Data.DataTableExtensions.CopyToDataTable[T](IEnumerable`1 source) à uc_annonces.Page_Load(Object sender, EventArgs e)
SELECT tmp.*, titre_annonce2(tmp.id,tmp.`type`,tmp.nature,tmp.surface_dispo,tmp._vnom) titre_annonce, 0 as is_selected FROM ((SELECT a.id,a.ref,a.`type`,a.nature,a.url, IF((SELECT IFNULL(count(app.id),0) FROM annonce_premium app WHERE app.annonce=a.id AND app.etat='VAL' AND (now() BETWEEN app.date_debut AND app.date_fin)) > 0, 1,0) as _exclu, v.nom as _vnom,v.cp as _vcp, a.surface_dispo, a.divisible, a.surface_dispo surface, IF(a.divisible=1 AND a.surface_min IS NOT NULL AND a.surface_min<>'' AND a.surface_min>0 AND a.surface_min<>a.surface_dispo, a.surface_min,null ) surface_min,IF(a.`type`='VEN',a.prix_vente,a.loyer) tarif,a.vue_immersive, a.lat, a.lng ,0 distance,0 around_result, a.both_type,a.video,a.video_main,IF(a.`type`='VEN' AND a.prix_vente IS NOT NULL AND a.prix_vente > 0 ,1, IF(a.`type`<>'VEN' AND a.loyer IS NOT NULL AND a.loyer > 0 ,1, 0) ) tarif_set FROM annonce a INNER JOIN ville v ON a.ville=v.id_ville INNER JOIN departement d ON v.dep=d.id_departement INNER JOIN region r ON d.id_region=r.id_region WHERE a.etat='VAL' AND (ISNULL(a.date_end) OR a.date_end >= now()) AND a.online=1 AND ( ((v.cp = 91300 OR v.parent=91300) AND SOUNDEX('Massy')=SOUNDEX(v.nom)) ) AND (SELECT IFNULL(count(app.id),0) FROM annonce_premium app WHERE app.annonce=a.id AND app.etat='VAL' AND (now() BETWEEN app.date_debut AND app.date_fin)) > 0 ORDER BY IFNULL(a.date_update,a.date_create) DESC ) UNION (SELECT a.id,a.ref,a.`type`,a.nature,a.url, IF((SELECT IFNULL(count(app.id),0) FROM annonce_premium app WHERE app.annonce=a.id AND app.etat='VAL' AND (now() BETWEEN app.date_debut AND app.date_fin)) > 0, 1,0) as _exclu, v.nom as _vnom,v.cp as _vcp, a.surface_dispo, a.divisible, a.surface_dispo surface, IF(a.divisible=1 AND a.surface_min IS NOT NULL AND a.surface_min<>'' AND a.surface_min>0 AND a.surface_min<>a.surface_dispo, a.surface_min,null ) surface_min,IF(a.`type`='VEN',a.prix_vente,a.loyer) tarif,a.vue_immersive, a.lat, a.lng ,0 distance,0 around_result, a.both_type,a.video,a.video_main,IF(a.`type`='VEN' AND a.prix_vente IS NOT NULL AND a.prix_vente > 0 ,1, IF(a.`type`<>'VEN' AND a.loyer IS NOT NULL AND a.loyer > 0 ,1, 0) ) tarif_set FROM annonce a INNER JOIN ville v ON a.ville=v.id_ville INNER JOIN departement d ON v.dep=d.id_departement INNER JOIN region r ON d.id_region=r.id_region WHERE a.etat='VAL' AND (ISNULL(a.date_end) OR a.date_end >= now()) AND a.online=1 AND ( ((v.cp = 91300 OR v.parent=91300) AND SOUNDEX('Massy')=SOUNDEX(v.nom)) ) AND (SELECT IFNULL(count(app.id),0) FROM annonce_premium app WHERE app.annonce=a.id AND app.etat='VAL' AND (now() BETWEEN app.date_debut AND app.date_fin)) = 0 AND a.vue_immersive=1 ORDER BY IFNULL(a.date_update,a.date_create) DESC ) UNION (SELECT a.id,a.ref,a.`type`,a.nature,a.url, IF((SELECT IFNULL(count(app.id),0) FROM annonce_premium app WHERE app.annonce=a.id AND app.etat='VAL' AND (now() BETWEEN app.date_debut AND app.date_fin)) > 0, 1,0) as _exclu, v.nom as _vnom,v.cp as _vcp, a.surface_dispo, a.divisible, a.surface_dispo surface, IF(a.divisible=1 AND a.surface_min IS NOT NULL AND a.surface_min<>'' AND a.surface_min>0 AND a.surface_min<>a.surface_dispo, a.surface_min,null ) surface_min,IF(a.`type`='VEN',a.prix_vente,a.loyer) tarif,a.vue_immersive, a.lat, a.lng ,0 distance,0 around_result, a.both_type,a.video,a.video_main,IF(a.`type`='VEN' AND a.prix_vente IS NOT NULL AND a.prix_vente > 0 ,1, IF(a.`type`<>'VEN' AND a.loyer IS NOT NULL AND a.loyer > 0 ,1, 0) ) tarif_set FROM annonce a INNER JOIN ville v ON a.ville=v.id_ville INNER JOIN departement d ON v.dep=d.id_departement INNER JOIN region r ON d.id_region=r.id_region WHERE a.etat='VAL' AND (ISNULL(a.date_end) OR a.date_end >= now()) AND a.online=1 AND ( ((v.cp = 91300 OR v.parent=91300) AND SOUNDEX('Massy')=SOUNDEX(v.nom)) ) AND (SELECT IFNULL(count(app.id),0) FROM annonce_premium app WHERE app.annonce=a.id AND app.etat='VAL' AND (now() BETWEEN app.date_debut AND app.date_fin)) = 0 AND a.vue_immersive=0 ORDER BY IFNULL(a.date_update,a.date_create) DESC ) ) AS tmp