combobox prob

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

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

VB Code:

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

Quote:

---

Originally Posted by pvbangera

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

VB Code:

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???? :confused: :confused: :confused: :confused: :confused: :confused: :confused:

I am comfortable with it. :)

Quote:

---

Originally Posted by pvbangera

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

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

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

Quote:

---

Originally Posted by 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

---

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

try my code if that what you needed. :)