VB.NET for beginners : How to create simple application paging and sorting in a datagridview examples for beginners.
VB.NET How - How to create simple application to paging and sorting data from MySQL Database (other database) in a DataGridView using .NET language? this session will show you how a DataGridView Class will allow customization of cells, rows, columns, and borders through the use of its properties.
Please Read :
If you still confused with this tutorial, please see video how to create DataGridView Paging Example below :
Please Read :
- VB.NET Insert, Update, Delete Data From DataGridView Using MySQL Database
- How to Export DataGridView to PDF Using DataTable MySQL Database
- How to Filter DataGridView Using TextBox and MySQL Database
Paging DataGridView
Create a new project, rename it with "PagingDataGridView" and at the Form1.vb just design look like this form :
Source Code DataGridView Paging Example
just write all source code below to sorting or paging our value from MySQL Database :
Imports System.Data.Odbc ' using ODBC namespace
Public Class Form1
Dim conn As OdbcConnection ' declare for our connection
Dim Da As OdbcDataAdapter ' declare for Data Adapter
Dim Ds As DataSet ' declare for dataset
Dim Filter As Integer ' for max value to show the data/paging
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
' load data button
' you must have a Database before
' i use MySQL database for this application
' i'll create connection using Odbc
' set connection using ODBC
conn = New OdbcConnection("DSN=k13new;MultipleActiveResultSets=True")
' create SQL query to show data from MySQL Database
Dim sql As String = "SELECT * FROM biodata order by idsiswa"
Da = New OdbcDataAdapter(sql, conn)
Ds = New DataSet
' open connection
conn.Open()
Da.Fill(Ds, Filter, 15, "biodata")
' max Count of data will show at one page is 15
' close connection
conn.Close()
DataGridView1.DataSource = Ds
DataGridView1.DataMember = "biodata"
End Sub
Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
' prev button
Filter = Filter - 15
If Filter <= 0 Then
Filter = 0
End If
Ds.Clear()
Da.Fill(Ds, Filter, 15, "biodata")
End Sub
Private Sub Button3_Click(sender As Object, e As EventArgs) Handles Button3.Click
' next button
Filter = Filter + 15
Ds.Clear()
Da.Fill(Ds, Filter, 15, "biodata")
End Sub
End Class
If you still confused with this tutorial, please see video how to create DataGridView Paging Example below :
COMMENTS