importing data from excel sheet to datagridView

  • Thread starter Thread starter friend
  • Start date Start date
F

friend

Hello all,
When I import the data from excel to datagridview in my project first
row is missing when displayed in the datagridivew

Excel data:

Field content 1234
10386524178 3434
31497645790 3434
61417861227 3434
21555680106 3434
66547895251 3434
7309310634 3434
6202733735 3434
50444214805 3434


after importing into datagridview:

Field content F1
10386524178 3434
31497645790 3434
61417861227 3434
21555680106 3434
66547895251 3434
7309310634 3434
6202733735 3434
50444214805 3434

if i write any string the first row then it gets displayed but if i
write any integer then it gets replaced by F1

Here is my code:

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= " & Table1.xls &
";Extended Properties=Excel 8.0;")
MyCommand = New System.Data.OleDb.OleDbDataAdapter
("select * from [Tabelle1$]", MyConnection)
MyCommand.TableMappings.Add("Table", "TestTable")
DtSet = New System.Data.DataSet
MyCommand.Fill(DtSet)
DataGridView1.DataSource = DtSet.Tables(0)


How to resolve this...Thanks for any help
 
Hi,

This sounds like the hdr option in the connection string,

http://www.connectionstrings.com/excel

Cor


Hello all,
When I import the data from excel to datagridview in my project first
row is missing when displayed in the datagridivew
Click to expand...
Excel data:
Click to expand...
Field content 1234
10386524178 3434
31497645790 3434
61417861227 3434
21555680106 3434
66547895251 3434
7309310634 3434
6202733735 3434
50444214805 3434
Click to expand...
after importing into datagridview:
Click to expand...
Field content F1
10386524178 3434
31497645790 3434
61417861227 3434
21555680106 3434
66547895251 3434
7309310634 3434
6202733735 3434
50444214805 3434
Click to expand...
if i write any string the first row then it gets displayed but if i
write any integer then it gets replaced by F1
Click to expand...
Here is my code:
Click to expand...
               Dim MyConnection As System.Data.OleDb.OleDbConnection
               Dim DtSet As System.Data.DataSet
               Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
Click to expand...
               MyConnection = New System.Data.OleDb.OleDbConnection
("provider=Microsoft.Jet.OLEDB.4.0; data source= " & Table1.xls &
";Extended Properties=Excel 8.0;")
               MyCommand = New System.Data.OleDb.OleDbDataAdapter
("select * from [Tabelle1$]", MyConnection)
               MyCommand.TableMappings.Add("Table", "TestTable")
               DtSet = New System.Data.DataSet
               MyCommand.Fill(DtSet)
               DataGridView1.DataSource = DtSet.Tables(0)
Click to expand...
How to resolve this...Thanks for any help
Click to expand...
Click to expand...

It doesnt work with HDR option in the connection string
 
Hi,

This sounds like the hdr option in the connection string,

http://www.connectionstrings.com/excel

Cor


Hello all,
When I import the data from excel to datagridview in my project first
row is missing when displayed in the datagridivew
Click to expand...
Excel data:
Click to expand...
Field content 1234
10386524178 3434
31497645790 3434
61417861227 3434
21555680106 3434
66547895251 3434
7309310634 3434
6202733735 3434
50444214805 3434
Click to expand...
after importing into datagridview:
Click to expand...
Field content F1
10386524178 3434
31497645790 3434
61417861227 3434
21555680106 3434
66547895251 3434
7309310634 3434
6202733735 3434
50444214805 3434
Click to expand...
if i write any string the first row then it gets displayed but if i
write any integer then it gets replaced by F1
Click to expand...
Here is my code:
Click to expand...
               Dim MyConnection As System.Data.OleDb.OleDbConnection
               Dim DtSet As System.Data.DataSet
               Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
Click to expand...
               MyConnection = New System.Data.OleDb.OleDbConnection
("provider=Microsoft.Jet.OLEDB.4.0; data source= " & Table1.xls &
";Extended Properties=Excel 8.0;")
               MyCommand = New System.Data.OleDb.OleDbDataAdapter
("select * from [Tabelle1$]", MyConnection)
               MyCommand.TableMappings.Add("Table", "TestTable")
               DtSet = New System.Data.DataSet
               MyCommand.Fill(DtSet)
               DataGridView1.DataSource = DtSet.Tables(0)
Click to expand...
How to resolve this...Thanks for any help
Click to expand...
Click to expand...

It doesnt work with HDR option in the connection string
 
You need to be super super anal with Excel connection strings.

Are there spaces in the filename?

99 times out of 100, its because there is something off with your excel
connection string.

Every single quote , semi colon ...anything and everything has to be
correct.

Post your full (not variable driven) connection string...........




Hi,

This sounds like the hdr option in the connection string,

http://www.connectionstrings.com/excel

Cor


Hello all,
When I import the data from excel to datagridview in my project first
row is missing when displayed in the datagridivew
Click to expand...
Excel data:
Click to expand...
Field content 1234
10386524178 3434
31497645790 3434
61417861227 3434
21555680106 3434
66547895251 3434
7309310634 3434
6202733735 3434
50444214805 3434
Click to expand...
after importing into datagridview:
Click to expand...
Field content F1
10386524178 3434
31497645790 3434
61417861227 3434
21555680106 3434
66547895251 3434
7309310634 3434
6202733735 3434
50444214805 3434
Click to expand...
if i write any string the first row then it gets displayed but if i
write any integer then it gets replaced by F1
Click to expand...
Here is my code:
Click to expand...
Dim MyConnection As System.Data.OleDb.OleDbConnection
Dim DtSet As System.Data.DataSet
Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
Click to expand...
MyConnection = New System.Data.OleDb.OleDbConnection
("provider=Microsoft.Jet.OLEDB.4.0; data source= " & Table1.xls &
";Extended Properties=Excel 8.0;")
MyCommand = New System.Data.OleDb.OleDbDataAdapter
("select * from [Tabelle1$]", MyConnection)
MyCommand.TableMappings.Add("Table", "TestTable")
DtSet = New System.Data.DataSet
MyCommand.Fill(DtSet)
DataGridView1.DataSource = DtSet.Tables(0)
Click to expand...
How to resolve this...Thanks for any help
Click to expand...
Click to expand...

It doesnt work with HDR option in the connection string
 
You need to be super super anal with Excel connection strings.

Are there spaces in the filename?

99 times out of 100, its because there is something off with your excel
connection string.

Every single quote , semi colon ...anything and everything has to be
correct.

Post your full (not variable driven) connection string...........




Hi,

This sounds like the hdr option in the connection string,

http://www.connectionstrings.com/excel

Cor


Hello all,
When I import the data from excel to datagridview in my project first
row is missing when displayed in the datagridivew
Click to expand...
Excel data:
Click to expand...
Field content 1234
10386524178 3434
31497645790 3434
61417861227 3434
21555680106 3434
66547895251 3434
7309310634 3434
6202733735 3434
50444214805 3434
Click to expand...
after importing into datagridview:
Click to expand...
Field content F1
10386524178 3434
31497645790 3434
61417861227 3434
21555680106 3434
66547895251 3434
7309310634 3434
6202733735 3434
50444214805 3434
Click to expand...
if i write any string the first row then it gets displayed but if i
write any integer then it gets replaced by F1
Click to expand...
Here is my code:
Click to expand...
Dim MyConnection As System.Data.OleDb.OleDbConnection
Dim DtSet As System.Data.DataSet
Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
Click to expand...
MyConnection = New System.Data.OleDb.OleDbConnection
("provider=Microsoft.Jet.OLEDB.4.0; data source= " & Table1.xls &
";Extended Properties=Excel 8.0;")
MyCommand = New System.Data.OleDb.OleDbDataAdapter
("select * from [Tabelle1$]", MyConnection)
MyCommand.TableMappings.Add("Table", "TestTable")
DtSet = New System.Data.DataSet
MyCommand.Fill(DtSet)
DataGridView1.DataSource = DtSet.Tables(0)
Click to expand...
How to resolve this...Thanks for any help
Click to expand...
Click to expand...

It doesnt work with HDR option in the connection string
 
You need to be super super anal with Excel connection strings.

Are there spaces in the filename?

99 times out of 100, its because there is something off with your excel
connection string.

Every single quote , semi colon ...anything and everything has to be
correct.

Post your full (not variable driven) connection string...........


Hi,
Click to expand...
This sounds like the hdr option in the connection string,
http://www.connectionstrings.com/excel
Click to expand...
Cor
Click to expand...

news:2f269168-2770-41fe-93b9-9bb0669b0e33@s21g2000vbb.googlegroups.com....
Click to expand...
Hello all,
When I import the data from excel to datagridview in my project first
row is missing when displayed in the datagridivew
Excel data:
Field content 1234
10386524178 3434
31497645790 3434
61417861227 3434
21555680106 3434
66547895251 3434
7309310634 3434
6202733735 3434
50444214805 3434
after importing into datagridview:
Field content F1
10386524178 3434
31497645790 3434
61417861227 3434
21555680106 3434
66547895251 3434
7309310634 3434
6202733735 3434
50444214805 3434
if i write any string the first row then it gets displayed but if i
write any integer then it gets replaced by F1
Here is my code:
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= " & Table1.xls &
";Extended Properties=Excel 8.0;")
MyCommand = New System.Data.OleDb.OleDbDataAdapter
("select * from [Tabelle1$]", MyConnection)
MyCommand.TableMappings.Add("Table", "TestTable")
DtSet = New System.Data.DataSet
MyCommand.Fill(DtSet)
DataGridView1.DataSource = DtSet.Tables(0)
How to resolve this...Thanks for any help
Click to expand...
Click to expand...

It doesnt work with HDR option in the connection string- Hide quoted text-

- Show quoted text -
Click to expand...

solved..thanks
 
You need to be super super anal with Excel connection strings.

Are there spaces in the filename?

99 times out of 100, its because there is something off with your excel
connection string.

Every single quote , semi colon ...anything and everything has to be
correct.

Post your full (not variable driven) connection string...........


Hi,
Click to expand...
This sounds like the hdr option in the connection string,
http://www.connectionstrings.com/excel
Click to expand...
Cor
Click to expand...

news:2f269168-2770-41fe-93b9-9bb0669b0e33@s21g2000vbb.googlegroups.com....
Click to expand...
Hello all,
When I import the data from excel to datagridview in my project first
row is missing when displayed in the datagridivew
Excel data:
Field content 1234
10386524178 3434
31497645790 3434
61417861227 3434
21555680106 3434
66547895251 3434
7309310634 3434
6202733735 3434
50444214805 3434
after importing into datagridview:
Field content F1
10386524178 3434
31497645790 3434
61417861227 3434
21555680106 3434
66547895251 3434
7309310634 3434
6202733735 3434
50444214805 3434
if i write any string the first row then it gets displayed but if i
write any integer then it gets replaced by F1
Here is my code:
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= " & Table1.xls &
";Extended Properties=Excel 8.0;")
MyCommand = New System.Data.OleDb.OleDbDataAdapter
("select * from [Tabelle1$]", MyConnection)
MyCommand.TableMappings.Add("Table", "TestTable")
DtSet = New System.Data.DataSet
MyCommand.Fill(DtSet)
DataGridView1.DataSource = DtSet.Tables(0)
How to resolve this...Thanks for any help
Click to expand...
Click to expand...

It doesnt work with HDR option in the connection string- Hide quoted text-

- Show quoted text -
Click to expand...

solved..thanks
 
Back
Top