DataGridView
Try 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:\coded\Vehicle\Vehicles.xls';Extended Properties=Excel 8.0;") MyCommand = New System.Data.OleDb.OleDbDataAdapter _ ("select * from [Sheet1$]", MyConnection) MyCommand.TableMappings.Add("Table", "TestTable") 'DtSet = New System.Data.DataSet MyCommand.Fill(DataSet1) DataGridView1.DataSource = DataSet1.Tables(0) MyConnection.Close() Catch ex As Exception MsgBox(ex.ToString) End Try
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)