SQL Server Database records not being fetched in some cases in ASP.Net

hi

this is Store procedure that i define in database

ALTER procedure [dbo].[storeinfo2]
@Behcode nvarchar(10)
as
begin
select Name,Image_Behcode,Description,address,about,substring([Service1]+','+[Service2]+','+[Service3]+','+[Service4]+','+[Service5]+','+[Service6]+','+[Service7]+','+[Service8],0,66)+'...' as ServiceM,([Service1]+','+[Service2]+','+[Service3]+','+[Service4]+','+[Service5]+','+[Service6]+','+[Service7]+','+[Service8]) as Keyword,Ownername,City,image,Service1,Service2,Service3,Service4,Service5,Service6,Service7,Service8

from House_Info
where  BehCode=@Behcode
end

as you see i use this code in SP

substring([Service1]+','+[Service2]+','+[Service3]+','+[Service4]+','+[Service5]+','+[Service6]+','+[Service7]+','+[Service8],0,66)+'...' as ServiceM

and

([Service1]+','+[Service2]+','+[Service3]+','+[Service4]+','+[Service5]+','+[Service6]+','+[Service7]+','+[Service8]) as Keyword

and in behind code

 HtmlMeta htmlmeta;
            string Keyword = _dr["Keyword"].ToString();
            htmlmeta = new HtmlMeta();
            htmlmeta.HttpEquiv = "Keywords";
            htmlmeta.Content = Keyword;
            this.Page.Header.Controls.Add(htmlmeta);


 lblservice.Text = _dr["serviceM"].ToString();

I used above code in many page of my website but in some page it showed  the data from database  and in some page it didn't show any thing why this happen?

BestRegards