How to Import data from Excel to DataGridView

The DataGridView control, along with its associated classes, has been carefully designed to provide a highly adaptable and scalable framework for effortlessly showcasing and modifying tabular data. It serves as a versatile solution for presenting data in a structured table format.

With the DataGridView control, you have the option to display data in a variety of ways. It offers the capability to exhibit information either by utilizing an underlying data source or by manually populating the control with data. This means that you can seamlessly showcase data in the DataGridView control, whether it is sourced from a database, an external file, or generated programmatically within your application.

Import data from an Excel file to a DataGridView control

The following vb.net source code shows how to Import data from an Excel file to a DataGridView control .

Full Source VB.NET
Imports System.Data.SqlClient Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim MyConnection As System.Data.OleDb.OleDbConnection Dim DtSet As System.Data.DataSet Dim MyCommand As System.Data.OleDb.OleDbDataAdapter MyConnection = New System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:\vb.net-informations.xls';Extended Properties=Excel 8.0;") MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", MyConnection) MyCommand.TableMappings.Add("Table", "Net-informations.com") DtSet = New System.Data.DataSet MyCommand.Fill(DtSet) DataGridView1.DataSource = DtSet.Tables(0) MyConnection.Close() End Sub End Class





Related Topics
  1. VB.NET DataGridView binding - Sql Server
  2. DataGridView binding - OLEDB in VB.NET
  3. DataGridView Sorting/Filtering in VB.NET
  4. DataGridView adding rows and columns in VB.NET
  1. DataGridView hiding rows and columns in VB.NET
  2. DataGridView ReadOnly rows and columns in VB.NET
  3. Adding Button to DataGridView in VB.NET
  4. Adding CheckBox to DataGridView in VB.NET
  5. Adding ComboBox to DataGridView in VB.NET
  6. Adding Image to DataGridView in VB.NET
  7. Adding ViewLink to DataGridView in VB.NET
  8. How to Paging in DataGridView
  9. How to Formatting in DataGridView
  10. How to DataGridView Template
  11. How to DataGridView Printing in VB.Net
  12. How to Export datagridview to Excel
  13. Database operations in DatagridView
  14. Delete row from datagridview by Right click
  15. DataGridView Autocomplete TextBox in VB.Net