using System; using System.IO; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; public partial class listado_productos_sin_imagenes : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { SqlDataReader reader = null; try { SqlConnection conexion = DBManager.getConnection(); String sqlQuery = String.Format(DBQueryDefinitions.FIND_ALL_PRODUCTS_2); SqlCommand command = new SqlCommand(sqlQuery, conexion); string path = System.Configuration.ConfigurationManager.AppSettings["pathUploadImg"].ToString(); path = Server.MapPath(path); reader = command.ExecuteReader(); Response.Write("

Lista Productos Sin Imagenes

"); Response.Write(""); while (reader.Read()) { if (!Directory.Exists(path + "/" + reader["codigo"])) { Response.Write(""); } } reader.Close(); Response.Write("
CodigoDescripcion
" + reader["codigo"].ToString() + "" + reader["descripcion"].ToString() + "
"); } catch (Exception err) { if (reader != null) { reader.Close(); } Response.Write(err.Message); } finally { if (reader != null) { reader.Close(); } } } }