problem in datalist pagination

Hi there, your problem is there with [dbo].[GetCustomersPageWise] SP, you need to add a where condition Identical as in the first SP namely [dbo].[GetProducts] sp., as  because the first time u change the ddl the [dbo].[GetProducts] is being called and it populates the first page and as it is having the where condition it works properly but when u clicks on the pager button it call the [dbo].[GetCustomersPageWise] which does not contain the where codition for the region thats the why it fetches all the data irrespective to the region,so change the SP And your code accordingly to supply the Region parameter to the SP I hope It would be definitly work.

ALTER procedure [dbo].[GetCustomersPageWise]    @PageIndex INT = 1
      ,@PageSize INT = 5      ,@RecordCount INT OUTPUT      ,@Region tinyint = 0
AS BEGIN      SET NOCOUNT ON;      SELECT ROW_NUMBER() OVER      (
            ORDER BY [Date] desc      )AS RowNumber		,[ID]		,[Name]		,[Image]
		,[Date]     		,[Model]     INTO #Results      FROM [House_p]
      JOIN [HOuse_info]      ON [House_p].[BehCode] = [HOuse_info].[BehCode]
      WHERE [HOuse_info].Region = @Region      
      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 

--{The SP above is just for make you understand that What kind of chang I indeed Intended to suggest you It may have an error becuase I dont have these tables ...}                 Then change the code that calling your SP like

using (SqlCommand cmd = new SqlCommand("GetCustomersPageWise", _cn))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@PageIndex", pageIndex);
                    cmd.Parameters.AddWithValue("@PageSize", PageSize);
                    cmd.Parameters.Add("@RecordCount", SqlDbType.Int, 4);
                    //  ADD THIS LINE OF CODE ...
                    cmd.Parameters.AddWithValue("@Region", DDLzone1.SelectedItem.Value);
                    
                    cmd.Parameters["@RecordCount"].Direction = ParameterDirection.Output;
                    _cn.Open();
                    IDataReader idr = cmd.ExecuteReader();
                    DataList1.DataSource = idr;
                    DataList1.DataBind();                    idr.Close();
                    _cn.Close();
                    int recordCount = Convert.ToInt32(cmd.Parameters["@RecordCount"].Value);
                    this.PopulatePager(recordCount, pageIndex);                }