in property of datagrid-allow paging=true -page size=accoring 2 u(5 or 10 like) in pager style property haeding -horizontal allign=accoring 2 u(left or right like) -mode=numeric or next prev then in page index changed eventdatagrid2.currentpageindex = e.newpageindex; datarent(); where void datarent() { sqldataadapter da2 = new sqldataadapter("select propertyid,postedby,postedid,city,state,zipcode,status,agentassign from adminrental where postedid='" + lable2.text + "'", cn); dataset ds2 = new dataset(); da2.fill(ds2, "as"); datagrid2.datasource = ds2; datagrid2.databind(); }