by Christopher (3 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Sat 18th March 2006
Date Added: Mon 8th February 2021
Rating: (1 Votes)
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
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]
No comments have been posted about Code for adding items in the list and conecting to the database using adodb connection.. Why not be the first to post a comment about Code for adding items in the list and conecting to the database using adodb connection..