I am making a software for my business
I have easily connected my access database to add new records in it's tables
but don't know how to show these tables with updated data in another form.
Please suggest any way!
here is a code snippet for you. try this.
here a listview control is used to display values from some selected columns.
here conn is the connection object. replace used ones with your object names
Dim str as string
Dim rs as New ADODB.Recordset
Dim li as ListItem
str="select ecode,ename,salary from employee order by ecode"
if rs.recordcount>0 then
while not rs.eof()
if rs.state=adstateopen then rs.close