Dude i think you should use gridview to display ur result and there you have a property to set paging which will make ur life easy

my sql query cann't be done using gridview

and i want show my search result as pragraph

so , i cannt use gridview


is there any way to paging my result

if you are using dataset or datatable to retieve the data from database you can use pageddatasource.it is very simple to use.just you need give data to it,set the properties like page count,pageindex,currentindex,allowpaging(not remember all proporties but u can easily find the required ..)....let me know if you need more inf...