reza4zar
دوشنبه 27 آبان 1392, 23:07 عصر
دوستان یه سوال بدجور گیر کردم کد زیر برای وارد کردن اطلاعات از اکسل به گرید :
Dim mConnection As System.Data.OleDb.OleDbConnection
Try
Dim dataset As System.Data.DataSet
Dim mcommand As System.Data.OleDb.OleDbDataAdapter
mConnection = New System.Data.OleDb.OleDbConnection("provider=microsoft.jet.oledb.4.0;data Source=c:\Txt.xlsx;Extended Properties=Excel 8.0;")
mcommand = New System.Data.OleDb.OleDbDataAdapter("Select * from [Sheet1]", mConnection)
mcommand.TableMappings.Add("table", "table1")
dataset = New System.Data.DataSet
mcommand.Fill(dataset)
DataGridView1.DataSource = dataset.Tables(0)
mConnection.Dispose()
Catch ex As Exception
mConnection.Close()
خطای زیر را می دهد:
External table is not in the expected format.
Dim mConnection As System.Data.OleDb.OleDbConnection
Try
Dim dataset As System.Data.DataSet
Dim mcommand As System.Data.OleDb.OleDbDataAdapter
mConnection = New System.Data.OleDb.OleDbConnection("provider=microsoft.jet.oledb.4.0;data Source=c:\Txt.xlsx;Extended Properties=Excel 8.0;")
mcommand = New System.Data.OleDb.OleDbDataAdapter("Select * from [Sheet1]", mConnection)
mcommand.TableMappings.Add("table", "table1")
dataset = New System.Data.DataSet
mcommand.Fill(dataset)
DataGridView1.DataSource = dataset.Tables(0)
mConnection.Dispose()
Catch ex As Exception
mConnection.Close()
خطای زیر را می دهد:
External table is not in the expected format.