How to insert, delete, update and display data with MS Access database

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register or Login
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

How to insert, delete, update and display data with MS Access database

Hello again guys,
I have a problem with Access database, I have two database with 12 table. I have connected the database using Datasaurces Wizard in VB 2005 xpress edition. The problem is how I want to retrive the data using SQL Statement and along with that how I am going to insert, delete, update and display the data in the Textbox, Richtextbox and Datagrid. That all, TQ.

Re: How to insert, delete, update and display data with MS Access database

If u r using vb, use adodc component.
u can add adodc component by pressing CTRL+T, add this component in form, right click and select properties. cnfigure ur db connection.
finally add ur text box and configure their property according to ur db data but the source connection for these boxes should be adodc.