The given code will help to get database value in your combobox.
public con as new adodb.connection
public rs as new adodb.recordset
rs.Open "Select (data field to load in combobox) from (tablename) ", con, adOpenForwardOnly, adLockReadOnly
While rs.EOF = False
Combo1.AddItem rs!(data field to load in combobox)
rs.MoveNext
Wend
public con as new adodb.connection
public rs as new adodb.recordset
rs.Open "Select (data field to load in combobox) from (tablename) ", con, adOpenForwardOnly, adLockReadOnly
While rs.EOF = False
Combo1.AddItem rs!(data field to load in combobox)
rs.MoveNext
Wend
Comments
Post a Comment