ASP. NET

Aspnetpager component

 

I. component parameters used

Total recordcount

Startrecordindex start Record Number (used in Stored Procedures)

Endrecordindex end record number (used in Stored Procedures)

Ii. Usage

Protected void page_load (Object sender, eventargs E)
{
If (session ["admin_user"] = NULL)
{
Response. Redirect ("login. aspx ");
Response. End ();
}
Else
{
Newssystem = new newssystem ();
Aspnetpager1.recordcount = newssystem. get_newsnum ();
}
}
Protected void aspnetpager1_pagechanged (Object sender, eventargs E)
{
Bindata ();
}
Public void bindata ()
{
Newssystem = new newssystem ();
News_list.datasource = newssystem. get_news (aspnetpager1.startrecordindex, aspnetpager1.endrecordindex );
News_list.databind ();
}

 

 

Attached stored procedure:

 

Alter procedure FY

(@ Startindex int,

@ Endindex int,

@ Docount INT)

As

Set nocount on

If (@ docount = 1)

Select count (*) from xt_article

Else

Begin

Declare @ indextable table (ID int identity (1, 1), nid int)

Set rowcount @ endindex

Insert into @ indextable (NID) Select ID from xt_article order by ID ASC

Select * From xt_article o, @ indextable t where O. ID = T. Nid

And T. ID between @ startindex and @ endindex order by T. ID

End

Set nocount off