The Open Source Swiss Army Knife

/code/vb/
/code/vb/ + sub-categories
http://www.sirfsup.com/
web directory content
    
      

Not logged in
Chat Register Login
return to:  http:/www.sirfsup.com      /code   /vb 
Permalink: additem.txt
Title: add
article options : please login   |  raw source view  

Here is a procedure may help you
Private Sub Form_Load()
Dim g_DBINFO as ADODB.Connection
Set g_DBINFO= New ADODB.Connection
g_DBINFO.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=" & App.path & "\Data\dbinfo.mdb"
g_DBINFO.CursorLocation = adUseClient
g_DBINFO.Open
LoadListDB cboControl,g_DBINFO,"SELECT field_name FROM table_name"
end sub

Public Sub LoadListDB(cbo As ComboBox, dbc As ADODB.Connection, ByVal sm_SQL As String)
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.Open sm_SQL, dbc, adOpenStatic, adLockReadOnly
cbo.Clear
Do Until rs.EOF
Select Case rs.Fields.count
Case 1

      cbo.AddItem rs.Fields(0).Value
      cbo.itemData(cbo.NewIndex) = rs.Fields(0).Value
    Case Else
      If IsNull(rs.Fields(1).Value) Then
       cbo.AddItem CStr(rs.Fields(0).Value) + " - "
       cbo.itemData(cbo.NewIndex) = rs.Fields(0).Value
      Else
       cbo.AddItem CStr(rs.Fields(0).Value) + " - " + rs.Fields(1).Value
       cbo.itemData(cbo.NewIndex) = rs.Fields(0).Value
      End If

End Select
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
End Sub

(#711) poster : anonymous (owner)date: 2008-08-04

a8UG5a hnjyewsvghhu, [url=http://eevbxapphkft.com/]eevbxapphkft[/url], [link=http://kndcahlikzzv.com/]kndcahlikzzv[/link], http://pnafptlecilf.com/


Leave a Reply
Your Name:     anonymous
Your Email:
Website:  
Comments:

The author will be notified of your reply.
return to top