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" <zz********@freemail.grwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...

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 ?

[giannis]

Tiago Salgado wrote:

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.
------------------------------
"giannis" <zz********@freemail.grwrote in message
news:ua****************@TK2MSFTNGP04.phx.gbl...

Tiago Salgado wrote:

>You need something like this:

Dim da as SqlDataAdapter

I receive the error "Type SqlDataAdapter is not defined "

[pfc_sadr]

you need to not use DOTNET

Microsoft is going to invent visual fred again this summer


On Feb 13, 12:11 pm, "giannis" <[e-mail]:

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 ?

[giannis]

Tiago Salgado wrote:

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]

"giannis" <zz********@freemail.grwrote in message
news:OI**************@TK2MSFTNGP04.phx.gbl...

Tiago Salgado wrote:

>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" ?

It's your connection to the database.

Robin S.