Storing And Displaying Images On ASP.NET Web Forms Website

Question

The website I am building holds 571 houses with information about each house. Each house has a image associated with it. The information is coming from a SQL database table called houses. I am using a custom pager to filter the 571 houses with 5 results per page. I am using a repeater control to do this so I don't have multiple aspx pages. My question is I want to store the folder with the 571 images in a location (stored on a network drive) and set a path to the specific image in that folder for each house in the database table column called image and display the images for each house while using the repeater control. I have looked at a lot of tutorials but nothing is helping me. Please don't post any links to tutorials because I have looked at them all. If you have done anything like this before please post your experience because this is new to me. Source code below.

Database Structure

[Id]          NCHAR (10)     NOT NULL,
[Name]        NVARCHAR (MAX) NULL,
[Townland]    NVARCHAR (MAX) NULL,
[Near]        NVARCHAR (MAX) NULL,
[Status]      NVARCHAR (MAX) NULL,
[Built]       NVARCHAR (MAX) NULL,
[Description] NVARCHAR (MAX) NULL,
[Families]    NVARCHAR (MAX) NULL,
[Image]       VARCHAR (200)  NULL,
CONSTRAINT [PK_Houses] PRIMARY KEY CLUSTERED ([Id] ASC)

Example Table Data

enter image description here

Houses.aspx


    
    
    
    
    
        
            
                Search Houses

                
                    Welcome to Houses of Mayo search page. Enter details below to search for a specific house. Additionally you can use advanced search or search by map.
                
                
                    
                        Name of House:
                        
                    
                    

                    
                        Townland:
                        
                    
                    

                    
                        Near:
                        
                    
                    

                    Advanced Search
                    
                        

                        
                            Associated Families:
                            
                        
                        

                        
                            Keyword:
                            
                        
                        

                    
                
                

                

                


                Houses By Alphabetical Order

                
                    
                        
                            
                                
                                    
                                
                                    
                                        
                                
                                    ID: 
                                    
                                    

                                    Name of House: 
                                    
                                    

                                    Townland: 
                                    
                                    

                                    Near: 
                                    
                                    

                                    Status/Public Access: 
                                    
                                    


                                    Date Built:

Houses.aspx.cs

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

namespace Houses_of_Mayo.images
{
    public partial class Houses : System.Web.UI.Page
    {
        private int PageSize = 5;

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                this.GetHousesPageWise(1);
            }
        }

        private void GetHousesPageWise(int pageIndex)
        {
            string constring = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            using (SqlConnection con = new SqlConnection(constring))
            {
                using (SqlCommand cmd = new SqlCommand("GetHousesPageWise", con))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@PageIndex", pageIndex);
                    cmd.Parameters.AddWithValue("@PageSize", PageSize);
                    cmd.Parameters.Add("@RecordCount", SqlDbType.Int, 4);
                    cmd.Parameters["@RecordCount"].Direction = ParameterDirection.Output;
                    con.Open();
                    IDataReader idr = cmd.ExecuteReader();
                    rptData.DataSource = idr;
                    rptData.DataBind();
                    idr.Close();
                    con.Close();
                    int recordCount = Convert.ToInt32(cmd.Parameters["@RecordCount"].Value);
                    this.PopulatePager(recordCount, pageIndex);
                }
            }
        }

        private void PopulatePager(int recordCount, int currentPage)
        {
            double dblPageCount = (double)((decimal)recordCount / Convert.ToDecimal(PageSize));
            int pageCount = (int)Math.Ceiling(dblPageCount);
            List pages = new List();
            if (pageCount > 0)
            {
                for (int i = 1; i <= pageCount; i++)
                {
                    pages.Add(new ListItem(i.ToString(), i.ToString(), i != currentPage));
                }
            }
            rptPager.DataSource = pages;
            rptPager.DataBind();
        }

        protected void Page_Changed(object sender, EventArgs e)
        {
            int pageIndex = int.Parse((sender as LinkButton).CommandArgument);
            this.GetHousesPageWise(pageIndex);
        }

        public override void VerifyRenderingInServerForm(Control control)
        {
            return;
        }
    }
}

Store Procedure

CREATE PROCEDURE GetHousesPageWise
      @PageIndex INT = 1
      ,@PageSize INT = 5
      ,@RecordCount INT OUTPUT
AS
BEGIN
      SET NOCOUNT ON;
      SELECT ROW_NUMBER() OVER
      (
            ORDER BY [Name] ASC
      )AS RowNumber
      ,[Id]
      ,[Name]
      ,[Townland]
      ,[Near]
      ,[Status]
      ,[Built]
     INTO #Results
      FROM [Houses]

      SELECT @RecordCount = COUNT(*)
      FROM #Results

      SELECT * FROM #Results
      WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1

      DROP TABLE #Results
end

Houses.aspx

enter image description here

Arun Raj · Accepted Answer

Change stored procedure's select query

SELECT ROW_NUMBER() OVER
      (
            ORDER BY [Name] ASC
      )AS RowNumber
      ,[Id]
      ,[Name]
      ,[Townland]
      ,[Near]
      ,[Status]
      ,[Built]
,[Image] 
     INTO #Results
      FROM [Houses]

and use

Storing And Displaying Images On ASP.NET Web Forms Website

Answers (2)

Related Questions