Filling a combo box

[giannis]

Sorry because i dont speak english very well.
I am a newbie at VB and i have the bellow question:
How can i fill a combo box with data from a SQL clause ?
Can you explain me ? Is there any way to do this without code?
If need code , what code must i write ?

 

[Tiago Salgado]

You need something like this:

Dim da as SqlDataAdapter= New SqlDataAdapter("SELECT ID,Name FROM Table",
your_db_conn)
Dim ds As New DataSet

da.Fill(ds,"TableName")

combobox1.DataSource = ds
combobox1.ValueMember = "ID"
combobox1.DisplayMember = "Name"

Try something like this.


--

Tiago Salgado

http://weblogs.pontonetpt.com/tiagosalgado
http://www.foruns.org
http://www.portugal-a-programar.org
http://www.revista-programar.info

 

[giannis]

You need something like this:

Dim da as SqlDataAdapter

I receive the error "Type SqlDataAdapter is not defined "

 

[RobinS]

Be sure you have references set up correctly. You can import them at the
top of your routine.

Imports System.Data
Imports System.Data.SqlClient 'this is probably the one you're missing

Or double-click on "My Project", go to the "References" tab, and add them
there.

Robin S.
------------------------------

 

[pfc_sadr]

you need to not use DOTNET

Microsoft is going to invent visual fred again this summer

 

[giannis]

You need something like this:

Dim da as SqlDataAdapter= New SqlDataAdapter("SELECT ID,Name FROM
Table", your_db_conn)

My Dataset is a mdb database. What must i write as "your_db_conn" ?

 

[RobinS]

My Dataset is a mdb database. What must i write as "your_db_conn" ?

It's your connection to the database.

Robin S.