help with ado, new to it

I'm new to using database with VB. I know how to use the ado control that you put on the form and bind all the text boxes, combo's, etc, but I would like to know how to code it into the program to make the program more dynamic. I did a search, but it was hard for me to find information. I was wondering if you guys can refer me to websites or tutorials that teach you how to connect, add, edit, delete data, etc using ado. You guys help will be much appreciated. Thanks.

Do you want to bind the controls dynamically to the recordset? Then do it this way:

VB Code:

Set Text1.DataSource = Adodc1
Set Text1.DataField = "[Field_Name_To_Bind]"

You can do this with all of your controls.

If you want to create a database connection and a recordset via code, and bind that to the controls, you have to set a reference to 'Microsoft Active Data Objects 2.6' library. Then you could open an ADODB.Connection object (Tip: if you don't know how to make a connectionstring, use a data control to create the connectionstring, copy it and paste it into the connection). After making a connection, you can query the opened database with ADODB.Recordset object.

Find the First Post of " Tutorials and Tips " u can get all details.

if u need more check the following site
http://pages.cpsc.ucalgary.ca/~carma...databases.html
Otherwise Go to Google.com and type " ADO VB Add Record" u can get more links

good luck

Thanks you guys for the help.