• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Code for adding items in the list and conecting to the database using adodb connection.

Code for adding items in the list and conecting to the database using adodb connection.

Code for adding items in the list and conecting to the database using adodb connection.

API Declarations


' Create a database using microsoft access and the Filename is category and create table and name it as tblCategory"
' add combobox control and name it as cboCategory

dim cn as new adodb.connection
dim rs as adodb.recordset




Rate Code for adding items in the list and conecting to the database using adodb connection.

• 1
• 2
• 3
• 4
• 5

(2(2 Vote))

cn.provider = "Microsoft.Jet.Oledb.4.0"
cn.open app.path & "\Category.mdb"
 if cn.state = adstateopen then
        set rs = new adodb.recordset
       rs.open "Select * from tblCategory",cn,adopendynamic,adlockoptimistc
 
end if 

End sub

Private sub cbocategory_Dropdown()
  cbocategory.clear
  rs.requery
  
  do while not rs.eof
      cbocategory.addtem rs![name of the fields]
      rs.movenext
  loop

end sub

'guides lang po para sa mga beginners.

'''''''''''''''''''''
'christopher benasa'''
'''''''''''''''''''''

'for some comments and suggestion email me at [email protected]