Ad:

VB.NET Discussion Thread
Unsolved
Views: 6653

Aug 28th, 2007

importing data from excel to comboBox

Expand Post »

hi every one after connecting to an excel file I want to import the firts row into a combobox
in the connection function I added thhis
MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * from[sheet1$]", MyConnection)
MyCommand.TableMappings.Add("Table", "Attendence")

DtSet = New System.Data.DataSet
MyCommand.Fill(DtSet)
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
ComboBox1.datasource= DtSet.Tables(0) i think this is error

and when I run my combo box will get filled with nSystem.Data.DataRowView

by the way I want only th first row to get imported in my cobo box how is the sql query

thanks in advance

Similar Threads

Exporting Data from App To Excel c# in C#
Retriving data from excel sheet into an asp page in ASP
Get data out of excel file stored as an image in MS SQL
sending data to and receiving data from excel in VB.NET
Export data to Excel Template in MS Access and FileMaker Pro

apchidara

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

18 posts
since Aug 2007

Permalink

Aug 28th, 2007

Re: importing data from excel to comboBox

Hi,

Here is a link to Ken Getz's really good artile on manipulating Exel with
VB.NET. It includes the logic you need to extract things such as worksheets
which would allow you to create your ComboBox:

http://msdn.microsoft.com/library/d...ml/ExcelObj.asp

shikeb

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

26 posts
since Jul 2007

Permalink

Aug 30th, 2007

Re: importing data from excel to comboBox

hi
this link is empty and also I searched I could not find the information I wanted please send me the exact link if you know . I would like to know how can I import the data column I want in my excel sheet , in the combo box .
thanks again

apchidara

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

18 posts
since Aug 2007

Permalink

Aug 30th, 2007

Re: importing data from excel to comboBox

Quote ...

and when I run my combo box will get filled with nSystem.Data.DataRowView

You set the data source but not the display member. The display member is the name of the column in the data table that you want to show in the list.

vb.net Syntax (Toggle Plain Text)
ComboBox1.DataSource = dt.Tables( 0 )
ComboBox1.DisplayMember = "Name"
ComboBox1.DataSource = dt.Tables( 0 )
ComboBox1.DisplayMember = "Name"

Hamrick

Reputation Points: 180

Solved Threads: 34

Posting Whiz

Offline

322 posts
since Jun 2007

Permalink

Aug 30th, 2007

Re: importing data from excel to comboBox

apchidara, please can you let me have a fully working link - I am working on an application that needs to do a lot of work with Excel.

TaoistTotty

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

46 posts
since Aug 2007

Permalink

Aug 31st, 2007

Re: importing data from excel to comboBox

Click to Expand / Collapse Quote originally posted by TaoistTotty ...

apchidara, please can you let me have a fully working link - I am working on an application that needs to do a lot of work with Excel.

hi :
which code you need the excel connection code?

apchidara

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

18 posts
since Aug 2007

Permalink

Aug 31st, 2007

Re: importing data from excel to comboBox

hey hamrik
I did it for one comboBox it works and the second I wanted it to be filled with the other column and I put the name of that culumn but u know what ? the combo box will get filled with the previous column that means both ae the same here is the code:

Dim ComboBox2 As ComboBox
ComboBox1.DataSource = DtSet.Tables(0)
ComboBox1.DisplayMember = "Iso Standards"
ComboBox2.DataSource = DtSet.Tables(0)
ComboBox2.DisplayMember = "MVB Standard"

apchidara

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

18 posts
since Aug 2007

Permalink

Aug 31st, 2007

Re: importing data from excel to comboBox

There's no reason that should happen unless you did something else later in the code that changes the bindings.

Hamrick

Reputation Points: 180

Solved Threads: 34

Posting Whiz

Offline

322 posts
since Jun 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: Shortcut

Next Thread in VB.NET Forum Timeline: Creating Table using SQL query from wondows Form

DaniWeb Message

Cancel Changes

User Name
Password