Collection Class

http://msdn.microsoft.com/en-us/library/6tc79sx1(VS.80).aspx

What is n-Tier Architecture?

http://www.developerfusion.co.uk/show/3058/2/

DataPager Paging Issue

just do only

1. Add a OnPreRender to the DataPager

2. In the OnPreRender, Bind the listview again to the dataset

as my Function name is

private void getDetail()
{
clsListView obj = new clsListView();
DataTable dt = obj.getDetails();
LV_Getail.DataSource = dt;
LV_Getail.DataBind();
}


protected void Pager_PreRender(object sender, EventArgs e)
{
getDetail();
}


protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
getDetail();

}

for disable right click in pages

write this function body on load
oncontextmenu="javascript:return false"

ASP.NET Application Life Cycle Overview for IIS 5.0 and 6.0

http://msdn.microsoft.com/en-us/library/ms178473.aspx

Crumb Trail

==>Table Structure
CREATE TABLE [dbo].[Tbl_ForumCategory](
[CategoryID] [bigint] IDENTITY(1,1) NOT NULL,
[CategoryName] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IsPublish] [bit] NULL CONSTRAINT [DF_Tbl_ForumCategory_IsPublish] DEFAULT (0),
[CreationDate] [datetime] NULL CONSTRAINT [DF_Tbl_ForumCategory_CreationDate] DEFAULT (getdate()),
[ModificationDate] [datetime] NULL CONSTRAINT [DF_Tbl_ForumCategory_ModificationDate] DEFAULT (getdate()),
CONSTRAINT [PK4] PRIMARY KEY NONCLUSTERED
(
[CategoryID] ASC
) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[Tbl_ForumTopic](
[TopicID] [bigint] IDENTITY(1,1) NOT NULL,
[FK_CategoryID] [bigint] NULL CONSTRAINT [DF_Tbl_ForumTopic_FK_CategoryID] DEFAULT (0),
[TopicName] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TopicView] [int] NULL CONSTRAINT [DF_Tbl_ForumTopic_TopicView] DEFAULT (0),
[IsPublish] [bit] NULL CONSTRAINT [DF_Tbl_ForumTopic_IsPublish] DEFAULT (1),
[CreationDate] [datetime] NULL CONSTRAINT [DF_Tbl_ForumTopic_CreationDate] DEFAULT (getdate()),
[ModificationDate] [datetime] NULL CONSTRAINT [DF_Tbl_ForumTopic_ModificationDate] DEFAULT (getdate()),
[CreatedBy] [bigint] NULL CONSTRAINT [DF_Tbl_ForumTopic_CreatedBy] DEFAULT (1),
CONSTRAINT [PK2] PRIMARY KEY NONCLUSTERED
(
[TopicID] ASC
) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[Tbl_ForumPost](
[PostID] [bigint] IDENTITY(1,1) NOT NULL,
[FK_CategoryID] [bigint] NULL,
[FK_TopicID] [bigint] NOT NULL,
[FK_QuestionID] [bigint] NULL CONSTRAINT [DF_Tbl_ForumPost_FK_QuestionID] DEFAULT (0),
[ParentPostID] [bigint] NOT NULL,
[PostTitle] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PostDescription] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TypeOfPost] [bit] NULL,
[UserType] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsPublish] [bit] NULL,
[CreationDate] [datetime] NULL CONSTRAINT [DF_Tbl_ForumPost_CreationDate] DEFAULT (getdate()),
[Modificationdate] [datetime] NULL CONSTRAINT [DF_Tbl_ForumPost_Modificationdate] DEFAULT (getdate()),
[CreatedBy] [bigint] NOT NULL,
[AbuseComments] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsAbuseReport] [int] NULL,
[AbuseUser] [int] NULL,
[IsBlockedUser] [bit] NULL,
CONSTRAINT [PK3] PRIMARY KEY NONCLUSTERED
(
[PostID] ASC
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

==>Procedure

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
--set QUOTED_IDENTIFIER OFF
--Proc_ForumCrumbTrail 1
ALTER Proc [dbo].[Proc_ForumCrumbTrail]
@PostID int

AS
BEGIN
CREATE TABLE #TempPost (
POSTID BIGINT IDENTITY(1,1) NOT NULL,
PostString varchar(8000))

CREATE TABLE #TempPostNew (
POSTID BIGINT ,
PostString varchar(8000))

Declare @HomePageLink varchar(100),@HomePage varchar(100),@QuestionPage varchar(100),@TopicPage varchar(100) ,@PostPage varchar(100)
Declare @strForumCrumbTail varchar(8000)
Declare @strForumCrumbTailPost varchar(8000)
Declare @strPostString varchar(8000)
Declare @CategoryID varchar(10),@TopicID varchar(10),@ParentPostID varchar(100),@TempPostID varchar(10)
Declare @CategoryName varchar(20),@TopicName varchar(20),@PostName varchar(20)
SET @strForumCrumbTailPost = ''
SET @strForumCrumbTail = ''
set @CategoryID=''
set @TopicID=''
set @QuestionPage='ForumListQuestion.aspx'
set @TopicPage ='ForumTopicList.aspx'
set @PostPage ='ForumListAllPostByPostID.aspx'
set @HomePage ='ForumCategoryList.aspx'
set @HomePageLink = 'Home'
select @CategoryID=FK_CategoryID,@TopicID=FK_TopicID,@ParentPostID=ParentPostID
from tbl_ForumPost where PostID=@PostID

if(@CategoryID = '')
BEGIN
select @CategoryID=FK_CategoryID,@TopicID=TopicID
from tbl_ForumTopic where TopicID=@PostID
set @ParentPostID =''
END

if(@CategoryID !='')
BEGIN
select @CategoryName=CategoryName from tbl_ForumCategory where CategoryID=@CategoryID
set @strForumCrumbTail = ''+@CategoryName + ''
END

if(@TopicID !='')
BEGIN
select @TopicName=TopicName from tbl_ForumTopic where TopicID=@TopicID
set @strForumCrumbTail = @strForumCrumbTail+' >> '+''+@TopicName + ''
END

if(@PostID !='')
BEGIN
if(@ParentPostID > 0)
BEGIN
While(@ParentPostID > 0)
Begin
select @TempPostID = PostID,@ParentPostID = ParentPostID,@PostName=PostTitle from tbl_ForumPost where PostID= @ParentPostID
set @strPostString = ''+@PostName + '' + ' >> '
INSERT INTO #TempPost(PostString)values(@strPostString)
End

END
END

INSERT INTO #TempPostNew(POSTID,PostString)
select POSTID,PostString from #TempPost ORDER BY 1 desc

SELECT @strForumCrumbTailPost = @strForumCrumbTailPost + PostString FROM #TempPostNew

if(@strForumCrumbTailPost <>'')
BEGIN
set @strForumCrumbTail = @HomePageLink+' >> '+ @strForumCrumbTail + ' >> '+ @strForumCrumbTailPost
SELECT substring(@strForumCrumbTail,0,len(@strForumCrumbTail)-2)
END

ELSE
BEGIN
set @strForumCrumbTail = @HomePageLink+' >> '+ @strForumCrumbTail
SELECT @strForumCrumbTail
END


END

javascript: Validate date and time like(12:12:12am and 12:12:12 pm)

var d1 = document.getElementById(FinalControlID2).value.split('/'); from date
var d2 = document.getElementById(FinalControlID3).value.split('/');todate
var d3 = document.getElementById("hidTodayDate").value.split('-');

var TodayDate = new Date(d3[1]+'/'+d3[0]+'/'+d3[2]);
var StartTime = document.getElementById(FinalControlID5).value;
var EndTime = document.getElementById(FinalControlID6).value;

if(StartTime != "" && EndTime != "")
{
var StartTime = new Date(d1[1]+'/'+d1[0]+'/'+d1[2] + ' ' +StartTime);
var EndTime = new Date(d2[1]+'/'+d2[0]+'/'+d2[2] + ' ' +EndTime);

var StartTime = TodayDate.setTime(StartTime)
var EndTime = TodayDate.setTime(EndTime)

if(StartTime == EndTime)
{
alert("Start Time and End Time can not be same!")
document.getElementById(FinalControlID6).focus();
return false;
}
// alert(StartTime > EndTime)
if(StartTime > EndTime)
{
alert("End Time should not be less than Start time!")
document.getElementById(FinalControlID6).focus();
return false;
}
}