connect combo box to database

[sachin Bhise]

i want to connect combo box of my vb.net project to a table in database.how should i achieve it please help me..pls illustrate full syntax for that connection.

[DilbagSingh]

Dim adp As New OleDbDataAdapter("select * from tblEmplyee", con)
ds = New DataSet
adp.Fill(ds)
ComboBox1.DataSource = ds.Tables(0)
ComboBox1.DisplayMember = "EmpName"
ComboBox1.ValueMember = "EmpID"

[sachin Bhise]

thanks dilbag..i will try it and later tell you whether its workin or not...

[Gobi nath]

Dim strquery As String
Dim cn As SqlConnection
Dim cmd As SqlCommand
Dim dr As SqlDataReader
strquery = "select * from tblNewbill"
cn = New SqlConnection(strconnectionstring)
cmd = New SqlCommand(strquery, cn)
cn.Open()
dr = cmd.ExecuteReader
Do While dr.Read
cbobox1.Items.Add(dr.Item(0))

Loop

[sachin Bhise]

its not giving any errors but at the same time its not working also...