Hi sir how to create paging inside the div.. actually I am fetching the data from database (sql server) with the help of stored procedure and the add to the placeholder control in asp.net. I want to display only 5 links at a time and then user click on next number it will display another five link..i want to create like this only so please suggest sir how is it possible in asp.net
--------------------------------------------------------------------stored procedure-------------------------------------------------------------------------------------
ALTER PROCEDURE [dbo].[sp_allnames]
(
@article_Category varchar(1)
)
AS
BEGIN
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
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
(Main_article,sub_article)
select distinct hl.lookup_description,category from hpp2_articles ha
where ArticalCategory = @article_Category and ha.active_flag ='Y'
--update #tmp
--set brief_Article = '<strong>'+sub_article+'</strong><ul class="diet-content-ul" >'
--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
set @brief_Article = null
--select @Main_article,@sub_article,@brief_Article,@article_id
select @brief_Article = isnull(@brief_Article,'') + '<li><a class="iframe" href="Articles.aspx?id='+convert(varchar,id)+'" target="_blank">'+brief_Article+'</a></il>'
from #tmp_brief where main_Article = @Main_article and sub_article = @sub_article
if(ISNULL(@brief_Article,'') <> '')
Begin
--'<div class="diet-col-content" style="padding-top: 0px;"><img src="../images/HPP2/newsfeed/Diet_Articles.jpg" class="diet-plan-thumb" alt="" /></div>'
update #tmp
set brief_Article = '<strong>'+sub_article+'</strong>'+
case when ltrim(rtrim(sub_article))='Diet' then '<div class="diet-col-content" style="padding-top: 0px;" id="'+ ltrim(rtrim(sub_article)) +'11"><img src="../images/HPP2/newsfeed/Diet_Articles.jpg" class="diet-plan-thumb" alt="" /></div>'
when ltrim(rtrim(sub_article))='Fitness' then '<div class="diet-col-content" style="padding-top: 0px;" id="'+ ltrim(rtrim(sub_article)) +'"><img src="../images/HPP2/newsfeed/Fitness_Articles.jpg" class="diet-plan-thumb" alt="" /></div>'
when ltrim(rtrim(sub_article))='Lifestyle' then '<div class="diet-col-content" style="padding-top: 0px;" id="'+ ltrim(rtrim(sub_article)) +'"><img src="../images/HPP2/newsfeed/Lifestyle_Articles.jpg" class="diet-plan-thumb" alt="" /></div>'
when ltrim(rtrim(sub_article))='Antenatal Tests ' then '<div class="diet-col-content" style="padding-top: 0px;" id="'+ ltrim(rtrim(sub_article)) +'"><img src="../images/HPP2/newsfeed/Antenatal Tests_Articles.jpg" class="diet-plan-thumb" alt="" /></div>'
when ltrim(rtrim(sub_article))='Birth and Beyond' then '<div class="diet-col-content" style="padding-top: 0px;" id="'+ ltrim(rtrim(sub_article)) +'"><img src="../images/HPP2/newsfeed/Birth and Beyond_articles.jpg" class="diet-plan-thumb" alt="" /></div>'
when ltrim(rtrim(sub_article))='First Trimester' then '<div class="diet-col-content" style="padding-top: 0px;" id="'+ ltrim(rtrim(sub_article)) +'"><img src="../images/HPP2/newsfeed/1stTrimister_Article.jpg" class="diet-plan-thumb" alt="" /></div>'
when ltrim(rtrim(sub_article))='Labor and Delivery' then '<div class="diet-col-content" style="padding-top: 0px;" id="'+ ltrim(rtrim(sub_article)) +'"><img src="../images/HPP2/newsfeed/labor and Delivery_Articles.jpg" class="diet-plan-thumb" alt="" /></div>'
when ltrim(rtrim(sub_article))='Medical Review' then '<div class="diet-col-content" style="padding-top: 0px;" id="'+ ltrim(rtrim(sub_article)) +'"><img src="../images/HPP2/newsfeed/Medical Review_Articles.jpg" class="diet-plan-thumb" alt="" /></div>'
when ltrim(rtrim(sub_article))='Pre-conception' then '<div class="diet-col-content" style="padding-top: 0px;" id="'+ ltrim(rtrim(sub_article)) +'"><img src="../images/HPP2/newsfeed/2ndTrimister.jpg" class="diet-plan-thumb" alt="" /></div>'
when ltrim(rtrim(sub_article))='Third Trimester' then '<div class="diet-col-content" style="padding-top: 0px;" id="'+ ltrim(rtrim(sub_article)) +'"><img src="../images/HPP2/newsfeed/3rdTrimister.jpg" class="diet-plan-thumb" alt="" /></div>'
end
+'<ul class="diet-content-ul" id="'+ ltrim(rtrim(sub_article)) +'10">'+@brief_Article+'</ul>'
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 #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
END
CLOSE Article_Cursor;
DEALLOCATE Article_Cursor;
--declare @list_data varchar(max)
--select @list_data = @list_data + '<strong>'+sub_article+'</strong><ul class="diet-content-ul" ><li><a class="iframe2" target="_blank" href="ExerciseDescription.aspx?id='+1+'" style="text-decoration: none; font-size: 12px; font-family: Arial, Helvetica, sans-serif">'+brief_Article+'</a></li>' from #tmp
set filter = '.'+Main_article where Main_article <> 'All Categories'
set filter = '*'
where Main_article = 'All Categories'
--set filter = 'default'
--where Main_article = 'default'
set a_tag = '<a href="#" data-filter="*">'+LTRIM(RTRIM(Main_article))+'</a>'
set a_tag = '<a href="#" data-filter=".'+LTRIM(RTRIM(REPLACE(Main_article,' ','')))+'">'+LTRIM(RTRIM(Main_article))+'</a>'
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
public void BindAllArticles()
{
DataSet dsDiv = new DataSet();
dsDiv = bl.GetMainArticleList("P");
for (int i = 0; i < dsDiv.Tables[1].Rows.Count; i++)
string a = dsDiv.Tables[1].Rows[i]["Main_article"].ToString();
if (dsDiv.Tables[1].Rows[i]["Main_article"].ToString() != "AllCategories")
HtmlGenericControl myDiv = new HtmlGenericControl("div");
myDiv.ID = dsDiv.Tables[1].Rows[i]["Main_article"].ToString() + i.ToString();
HtmlGenericControl myul = new HtmlGenericControl("ul");
HtmlGenericControl myli = new HtmlGenericControl("li");
myul.Style.Add("width", "100%");
myli.Style.Add("width", "100%");
myli.Style.Add("list-style-type", "none");
//myli.Style.Add("white-space", "nowrap");
myul.Attributes.Add("class", "diet-col");
myul.Controls.Add(myli);
HtmlGenericControl li_div = new HtmlGenericControl("div");
li_div.Attributes.Add("class", "diet-col-content");
li_div.InnerHtml = dsDiv.Tables[1].Rows[i]["brief_Article"].ToString();
myli.Controls.Add(li_div);
myDiv.Attributes.Add("class", dsDiv.Tables[1].Rows[i]["filter"].ToString());
//myDiv.Style.Add("display", "inline");
//myDiv.InnerHtml = "Inside DIV Inside DIV";//dsDiv.Tables[1].Rows[i]["sub_article"].ToString();
//myDiv.Controls.Add(img);
myDiv.Controls.Add(myul);
plh1.Controls.Add(myDiv);
}