paging inside the div

ALTER PROCEDURE [dbo].[sp_allnames]

(

@article_Category varchar(1)

)

create table #tmp

(

id int identity(1,1),

Main_article varchar(100),

sub_article varchar(500),

brief_Article varchar(max),

filter varchar(100),

article_list_cnt int,

a_tag varchar(500)

)

create table #tmp_brief

(

Main_article varchar(100),

sub_article varchar(500),

brief_Article varchar(max),

id int

)

insert into #tmp_brief

select hl.lookup_description,category,brief_article,artical_id from hpp2_articles ha

join HPP2_Content_Master hcm on ha.Content_Id = hcm.Content_Id

join HPP_Lookup hl on ha.page_name = hl.lookup_value and hl.lookup_code ='P_HPP_ArtclSubCategory'

where ArticalCategory ='P' and ha.active_flag ='Y'

--group by hl.lookup_description,category

order by hl.lookup_description

insert into #tmp

(Main_article,sub_article,article_list_cnt)

select 'All Categories','',0 --union all

--select 'default','',0

insert into #tmp

(Main_article,sub_article)

select distinct hl.lookup_description,category from hpp2_articles ha

join HPP2_Content_Master hcm on ha.Content_Id = hcm.Content_Id

join HPP_Lookup hl on ha.page_name = hl.lookup_value and hl.lookup_code ='P_HPP_ArtclSubCategory'

where ArticalCategory = @article_Category and ha.active_flag ='Y'

--group by hl.lookup_description,category

order by hl.lookup_description

--update #tmp

--set brief_Article = ''+sub_article+'

'

--select * from #tmp_brief

declare @Main_article varchar(100), @sub_article varchar(500),@brief_Article varchar(max),@article_id int

DECLARE Article_Cursor CURSOR FOR

SELECT Main_article,sub_Article FROM #tmp

/*SELECT main_Article,sub_Article,brief_Article,id

FROM #tmp_brief

*/

OPEN Article_Cursor

FETCH NEXT FROM Article_Cursor into @Main_article,@sub_article--,@brief_Article,@article_id

WHILE @@FETCH_STATUS = 0

BEGIN

set @brief_Article = null

--select @Main_article,@sub_article,@brief_Article,@article_id

select @brief_Article = isnull(@brief_Article,'') + '

• +convert(varchar,id)+'" target="_blank">'+brief_Article+''

  from #tmp_brief where main_Article = @Main_article and sub_article = @sub_article

  if(ISNULL(@brief_Article,'') <> '')

  Begin

  --'

  
  '

  update #tmp

  set brief_Article = ''+sub_article+''+

  case when ltrim(rtrim(sub_article))='Diet' then '

  + ltrim(rtrim(sub_article)) +'11">
  '

  when ltrim(rtrim(sub_article))='Fitness' then '

  + ltrim(rtrim(sub_article)) +'">
  '

  when ltrim(rtrim(sub_article))='Lifestyle' then '

  + ltrim(rtrim(sub_article)) +'">
  '

  when ltrim(rtrim(sub_article))='Antenatal Tests ' then '

  + ltrim(rtrim(sub_article)) +'">
  '

  when ltrim(rtrim(sub_article))='Birth and Beyond' then '

  + ltrim(rtrim(sub_article)) +'">
  '

  when ltrim(rtrim(sub_article))='First Trimester' then '

  + ltrim(rtrim(sub_article)) +'">
  '

  when ltrim(rtrim(sub_article))='Labor and Delivery' then '

  + ltrim(rtrim(sub_article)) +'">
  '

  when ltrim(rtrim(sub_article))='Medical Review' then '

  + ltrim(rtrim(sub_article)) +'">
  '

  when ltrim(rtrim(sub_article))='Pre-conception' then '

  + ltrim(rtrim(sub_article)) +'">
  '

  when ltrim(rtrim(sub_article))='Third Trimester' then '

  + ltrim(rtrim(sub_article)) +'">
  '

  end

  +'

  + ltrim(rtrim(sub_article)) +'10">'+@brief_Article+'
  '

  where Main_article = @Main_article and sub_article = @sub_article

  /*ISNULL(#tmp.brief_Article,'') + ' ' +ha.brief_article

  from #tmp_brief tb

  inner join hpp2_articles ha on ha.category = tb.sub_article and ha.artical_id = tb.id

  join HPP2_Content_Master hcm on ha.Content_Id = hcm.Content_Id

  join HPP_Lookup hl on ha.page_name = hl.lookup_value and hl.lookup_code ='P_HPP_ArtclSubCategory'

  --join #tmp_brief tb on tb.Main_article = #tmp.Main_article and tb.sub_article = #tmp.sub_article

  where ha.category = #tmp.Main_article

  and hl.lookup_description = #tmp.sub_article

  and tb.Main_article = @Main_article

  and tb.sub_article = @sub_article

  and tb.id = @article_id*/

  --and hcm.ArticalCategory = @article_Category

  End

  FETCH NEXT FROM Article_Cursor into @Main_article,@sub_article--,@brief_Article,@article_id

  END

  CLOSE Article_Cursor;

  DEALLOCATE Article_Cursor;

  --declare @list_data varchar(max)

  --select @list_data = @list_data + ''+sub_article+'

  • '+brief_Article+'
  ' from #tmp

  update #tmp

  set filter = '.'+Main_article where Main_article <> 'All Categories'

  update #tmp

  set filter = '*'

  where Main_article = 'All Categories'

  --update #tmp

  --set filter = 'default'

  --where Main_article = 'default'

  update #tmp

  set a_tag = ''+LTRIM(RTRIM(Main_article))+''

  where Main_article = 'All Categories'

  update #tmp

  set a_tag = '+LTRIM(RTRIM(REPLACE(Main_article,' ','')))+'">'+LTRIM(RTRIM(Main_article))+''

  where Main_article <> 'All Categories'

  select distinct Main_article,filter,a_tag from #tmp

  select LTRIM(RTRIM(Replace(Main_article,' ',''))) 'Main_article','isotope-item article_panel ' + LTRIM(RTRIM(REPLACE(REPLACE(filter,' ',''),'.',''))) 'filter',sub_article,

  brief_Article

  from #tmp

  select * from #tmp

   

  END

   ------------------------------------------------------------------end of procedure---------------------------------------

public void BindAllArticles()