How to show 10 next records on DataGrid ?

Question

I let DataGrid show 10 records of my table. when I click the last item in DataGrid , DataGrid will show 10 next records of table. But I don't know how to do this. Please help me ! Thanks a lot !

Niradhip Chakraborty · Answer

I have given the code in asp.net below the same code u can refer for windows form Bring It On - The Setup To setup a DataGrid to use the built-in paging function only requires a few property settings. You must set the following: AllowPaging=True This tells the DataGrid to use the built-in paging functionality provided by the .NET Framework PageSize=[number of records per page] This tells the DataGrid how many records should be displayed on each page OnPageIndexChanged="[name of page changing event handler]" This points the DataGrid to the event handler that is called when a page-navigation link is clicked Listing 1.1 shows the ASP.NET Web Form used to create the page Listing 1.1 - DataGrid Paging DotNetJunkies.com - Paging in the DataGrid Part 1 Sub Page_Load(Source As Object, E As EventArgs) If Not Page.IsPostBack Then BindData() End If End Sub Sub BindData() Dim ds As New DataSet Dim sda As SqlDataAdapter Dim strSQL As String Dim strCon As String strSQL = "SELECT CompanyName, ContactName, " & _ " ContactTitle, Phone, Fax FROM Customers " & _ " ORDER BY CompanyName" strCon="server=localhost;database=Northwind;uid=sa;pwd=;" sda = New SqlDataAdapter(strSQL, strCon) sda.Fill(ds, "Customers") myDataGrid.DataSource = ds.Tables("Customers") myDataGrid.DataBind() End Sub Sub myDataGrid_PageChanger(Source As Object, _ E As DataGridPageChangedEventArgs) ' Set the CurrentPageIndex before binding the grid myDataGrid.CurrentPageIndex = E.NewPageIndex BindData() End Sub .DataGrid {font:x-small Verdana, Arial, sans-serif} Border="0" Cellpadding="4" Cellspacing="0" AlternatingItemStyle-BackColor="#EFEFEF" ShowHeader="True" CssClass="DataGrid" HeaderStyle-BackColor="Black" HeaderStyle-ForeColor="White" HeaderStyle-Font-Bold="True" AllowPaging="True" PageSize="10" PagerStyle-Mode="NumericPages" OnPageIndexChanged="myDataGrid_PageChanger" /> Break It Down In Listing 1.1 I created a DataGrid and set it to display pages of ten (10) records at a time. It also threw in a few properties to alter the display of the DataGrid . There are two event handlers in this Web Form, the Page_Load() event handler, and the myDataGrid_PageChanger() event handler. It also created another page-level method, the BindData() method. When the page is loaded the first time the BindData() method is called and the DataSet is created and a Customers table is added to it. Then the DataGrid is bound to the Customers table. This will display the first ten (10) records in the Customers table (since I set PageSize=10). If the Page.IsPostBack property is true then the BindData() method is not called from the Page_Load() event handler. When the page is rendered the first time, ten (10) records are displayed with a series of page-navigation links below them. If one of the page-navigation links is clicked a PostBack is triggered. Since I used an If...Then statement in the Page_Load() event handler, the BindData() method does not get called there. Rather, the BindData() method is called from the myDataGrid_PageChanger() event handler. This is what enables the paging to work properly. Since the myDataGrid_PageChanger() event handler is specified in the OnPageIndexChanged property of the DataGrid, the DataGrid's CurrentPageIndex property is changed by the .NET Framework when a page-navigation link is clicked. The DataSet and DataTable are recreated, and the DataGrid is re-bound to the Customers table, using the CurrentPageIndex value to set the appropriate page to display. While I used NumericPages as the PagerStyle-Mode property, you could use NextPrev as the property value to display custom text for the next previous buttons. Listing 1.2 shows the same page using the NextPrev value for the PageStyle-Mode property. Listing 1.2 - Using NextPrev on a DataGrid DotNetJunkies.com - Paging in the DataGrid Part 1 Sub Page_Load(Source As Object, E As EventArgs) If Not Page.IsPostBack Then BindData() End If End Sub Sub BindData() Dim ds As New DataSet Dim sda As SqlDataAdapter Dim strSQL As String Dim strCon As String strSQL = "SELECT CompanyName, ContactName, " & _ " ContactTitle, Phone, Fax FROM Customers " & _ " ORDER BY CompanyName" strCon="server=localhost;database=Northwind;uid=sa;pwd=;" sda = New SqlDataAdapter(strSQL, strCon) dsc.Fill(ds, "Customers") myDataGrid.DataSource = ds.Tables("Customers").DefaultView myDataGrid.DataBind() End Sub Sub myDataGrid_PageChanger(Source As Object, _ E As DataGridPageChangedEventArgs) ' Set the CurrentPageIndex before binding the grid myDataGrid.CurrentPageIndex = E.NewPageIndex BindData() End Sub .DataGrid {font:x-small Verdana, Arial, sans-serif} Border="0" Cellpadding="4" Cellspacing="0" AlternatingItemStyle-BackColor="#EFEFEF" ShowHeader="True" CssClass="DataGrid" HeaderStyle-BackColor="Black" HeaderStyle-ForeColor="White" HeaderStyle-Font-Bold="True" AllowPaging="True" PageSize="10" PagerStyle-Mode="NextPrev" PagerStyle-NextPageText="Next ->" PagerStyle-PrevPageText="<- Previous" PagerStyle-Font-Bold="True" OnPageIndexChanged="myDataGrid_PageChanger" />

How to show 10 next records on DataGrid ?

Answers (1)