Imports Data from XLS file to DataGridView VB 2005

Tháng Chín 11, 2008 at 1:59 sáng Để lại phản hồi

I have XLS file which have format

Adress Name Adress Name Adress Name
Adr1 Name1 Adr2 Name2 Adr3 Name3
Adr4 Name4 Adr5 Name5 Adr6 Name6

this data is read and input DataGridView which have format

Adress Name
Adr1 Name1
Adr2 Name2
Adr3 Name3
Adr4 Name4
Adr5 Name5
Adr6 Name6

Dim strConnectionString As String = String.Empty

strConnectionString = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\FILES\Test.xls;Extended Properties=”"Excel 8.0;HDR=No;IMEX=1″”"

Dim cnCSV As New OleDbConnection(strConnectionString)

cnCSV.Open

Dim cmdSelect As New OleDbCommand(SELECT F1, F2 FROM [Sheet1$] union (SELECT F3, F4 FROM [Sheet1$] union SELECT F5, F6 FROM [Sheet1$]), cnCSV)

Dim daCSV As New OleDbDataAdapter

daCSV.SelectCommand = cmdSelect

Dim dtCSV As New DataTable

daCSV.Fill(dtCSV)

cnCSV.Close

Me.dataGridView1.DataSource = dtCSV

Entry filed under: VB.NET. Tags: .

Select SQL Column name contains “.” characters Get XLS Sheet Name (VB2005)

Gửi phản hồi

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Thay đổi )

Twitter picture

You are commenting using your Twitter account. Log Out / Thay đổi )

Facebook photo

You are commenting using your Facebook account. Log Out / Thay đổi )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


 

Tháng Chín 2008
T2 T3 T4 T5 T6 T7 CN
« Tháng 8   Tháng 10 »
1234567
891011121314
15161718192021
22232425262728
2930  

Follow

Get every new post delivered to your Inbox.