C# control

daboira · #1 (**permalink**) 05-12-03, 06:53

I must to fill a combobox. My data source is an xml file. Wich is the better system to populate the combobox? I can do it with the traditional AddItem method, but I don't know if there is a better manner to do it. Thank you.

Memnoch1207 · #2 (**permalink**) 05-13-03, 15:53

i've never done it pulling from an xml file, but from a database you can do something like

Code:

Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim sql As String

set conn = "Driver={SQL SERVER};Server=myServer;Database=myDb;UID=me;PWD=****"

set sql = "SELECT name FROM tableName"

rs.Open(sql, conn, 3, 3)

do until rs.eof
   cboCombobox.AddItem(rs!name)
   rs.movenext
loop

set rs = nothing
set sql = nothing
set conn = nothing

Internet Services

Web Development

Digital Marketing

Consumer Tech