moss2076

Hi everyone, im brand new to VB and i need to know how to make VB interact with databases.

I know how to set up the data and text boxes to display info from a table, but cant work out the basic functions -

eg - database called - dbtest.mdb
1 table called - details
2 fields called - name, age

I need to know how to program functions to allow VB to Add new record, delete, search, etc.

Any help or samples would be greatly appreciated!!

Tom

wfunk

Quote:

---

Originally Posted by moss2076
Hi everyone, im brand new to VB and i need to know how to make VB interact with databases.

I know how to set up the data and text boxes to display info from a table, but cant work out the basic functions -

eg - database called - dbtest.mdb
1 table called - details
2 fields called - name, age

I need to know how to program functions to allow VB to Add new record, delete, search, etc.

Any help or samples would be greatly appreciated!!

Tom

---

Hi Tom,

There are several options or approaches the most popular of which is using an ADO connection.I would recommend visiting http://www.vbtutor.net/vbtutor.html and checking out chapter 21 (depending on how new you actually are,,, this is a good free starting point). All of the Add, Edit search etc things are covered in a quick fashion.

Willie

00100b

You might want to check out this forum's Frequently Asked Database Questions thread as well.

tom2knox

hope this helps you...

SURESH MENON