System.Data.SqlClient.SqlException: Invalid column name Hname.

Hi

I use pagination code for my datalist I make some change in code like this

 private void GetCustomersPageWise(int pageIndex)
    {

        {
            
            if (Request.QueryString["H_name"] != "all")
            {
                using (SqlCommand cmd = new SqlCommand("GetCustomersPageWise1", _cn))
                {

                    string BehCode = Request.QueryString["H_name"];
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@H_name", BehCode);


                    cmd.Parameters.AddWithValue("@PageIndex", pageIndex);
                    cmd.Parameters.AddWithValue("@PageSize", PageSize);
                    cmd.Parameters.Add("@RecordCount", SqlDbType.Int, 4);
                    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);
                }
            }
            else {
                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);
                    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);
                }

            }
        }
    }

and this is new StoreProcedure

USE [behtop]
GO
/****** Object:  StoredProcedure [dbo].[GetCustomersPageWise1]    Script Date: 06/10/2012 17:26:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[GetCustomersPageWise1]

@H_name nvarchar(50)
  ,@PageIndex INT = 1
      ,@PageSize INT = 5
      ,@RecordCount INT OUTPUT
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]   
     
      SELECT @RecordCount = COUNT(*)
      FROM #Results
           
      SELECT * FROM #Results
      WHERE (RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1)
      AND H_name=@H_name
     
      DROP TABLE #Results
END

but when i run web site this error occure

Exception Details: System.Data.SqlClient.SqlException: Invalid column name 'H_name'.

I have this column in my table why this error occure?

regards