combobox prob

[shei786]

hi,
i want to know how i can populate my combobox using data directly from database (sql server ) and after how can i store the selectedindex (ie item selected by user) in another table. if u have any codes, post it here for me. i badly need help. HELP ME PLTZZZZZ!


thks. but do u have the equivalent code in vb.net please.a m using vb.net + sql server

[pvbangera]

You have to loop across a recordset or an array to populate the combo.

Dim rs as DAO.Recordset
rs = db.OpenRecordset("MyTable")
With rs
  .MoveLast
  .MoveFirst
  Do While Not .EOF
    MyCombo.Items.Add(.Fields("ListName").Value)
    If Not .EOF Then .MoveNext
  End Do
End With
MyCombo.Text = txtUserSelectedValue.Text

[kleinma]

You have to loop across a recordset or an array to populate the combo.

Dim rs as DAO.Recordset
rs = db.OpenRecordset("MyTable")
With rs
  .MoveLast
  .MoveFirst
  Do While Not .EOF
    MyCombo.Items.Add(.Fields("ListName").Value)
    If Not .EOF Then .MoveNext
  End Do
End With
MyCombo.Text = txtUserSelectedValue.Text

why O why would you be using DAO????

[pvbangera]

I am comfortable with it.

[kleinma]

I am comfortable with it.

well you should look into ADO.NET, not only is if faster than ADO, its worlds faster than DAO, DAO isn't even supported by MS anymore

[pvbangera]

will u suggest ne site or link to e-book for learning ADO.Net. I dont even know ADO.

[kleinma]

you can find lots of info here
http://msdn.microsoft.com/data/Default.aspx

[mar_zim]

hi,
i want to know how i can populate my combobox using data directly from database (sql server ) and after how can i store the selectedindex (ie item selected by user) in another table. if u have any codes, post it here for me. i badly need help. HELP ME PLTZZZZZ!


thks. but do u have the equivalent code in vb.net please.a m using vb.net + sql server

hey you ask this question here. http://vbforums.com/showthread.php?t=327348

try my code if that what you needed.