DataGridView binding - OLEDB in VB.NET
The DataGridView can display data in Bound mode and unbound mode and Virtual mode. The easiest way to get started using the DataGridView control is to use it in basic data binding scenarios. The DataGridView control can display rows of data from a data source. When you specify a data source for the DataGridView, by default it will construct columns for you automatically. This will be created based on the data types in the data source.
The following vb.net program shows how to bind an OLEDB dataset in a DataGridView.
Imports System.Data.OleDb Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="Your .mdb path";" Dim sql As String = "SELECT * FROM Authors" Dim connection As New OleDbConnection(connectionString) Dim dataadapter As New OleDbDataAdapter(sql, connection) Dim ds As New DataSet() connection.Open() dataadapter.Fill(ds, "Authors_table") connection.Close() DataGridView1.DataSource = ds DataGridView1.DataMember = "Authors_table" End Sub End Class
- VB.NET DataGridView binding - Sql Server
- DataGridView Sorting/Filtering in VB.NET
- DataGridView adding rows and columns in VB.NET
- DataGridView hiding rows and columns in VB.NET
- DataGridView ReadOnly rows and columns in VB.NET
- Adding Button to DataGridView in VB.NET
- Adding CheckBox to DataGridView in VB.NET
- Adding ComboBox to DataGridView in VB.NET
- Adding Image to DataGridView in VB.NET
- Adding ViewLink to DataGridView in VB.NET
- How to Paging in DataGridView
- How to Formatting in DataGridView
- How to DataGridView Template
- How to DataGridView Printing
- How to Export datagridview to Excel
- How to Import data from Excel to DataGridView
- Database operations in DatagridView
- Delete row from datagridview by Right click
- DataGridView Autocomplete TextBox in VB.Net