how can i use sql skip and take like linq skip and take method? [closed]

ArraleTah

New Member
i have listview data pager and i use objectdatasource for data. i connect sql directly without linq. But the problem is all data comes from my database. when i click to datapager "page 2" data should come part by part. is it possible ? \[code\]<asp:DataPager ID="pagerPersonel" PageSize="10" PagedControlID="lstPersonel" runat="server"> <Fields> <asp:NextPreviousPagerField ShowFirstPageButton="true" ShowNextPageButton="false" ShowPreviousPageButton="true" PreviousPageText="Geri" FirstPageText="?lk Sayfa" ButtonType="Link" /> <asp:NumericPagerField ButtonCount="5" ButtonType="Link" CurrentPageLabelCssClass="current" /> <asp:NextPreviousPagerField ShowFirstPageButton="false" ShowNextPageButton="true" ShowPreviousPageButton="false" ShowLastPageButton="true" LastPageText="Son Sayfa" NextPageText="?leri" ButtonType="Link" /> </Fields> </asp:DataPager> <asp:ObjectDataSource EnablePaging="True" StartRowIndexParameterName="startRow" MaximumRowsParameterName="maxRow" ID="osdPersonel" runat="server" SelectMethod="PersonelListesi" SelectCountMethod="PersonelSayisi" TypeName="EtsTur.Model.Dao.PersonelDAO"> </asp:ObjectDataSource>\[/code\]
 
Back
Top