Quick Search for:  in language:    
ADO,tutorial,programmers,know,nothing,good,te
   Code/Articles » |  Newest/Best » |  Community » |  Jobs » |  Other » |  Goto » | 
CategoriesSearch Newest CodeCoding ContestCode of the DayAsk A ProJobsUpload
Visual Basic Stats

 Code: 3,290,928. lines
 Jobs: 177. postings

 How to support the site

 
Sponsored by:

 
You are in:
 

Does your code think in ink?
Login





Latest Code Ticker for Visual Basic.
Diamond Creator - Shows How to Use For Loops
By David Thielke on 11/17


AutoCAD_VB_Bloc kShop1
By Mark Acuna on 11/17


AutoCAD2Excel_V BAExamples2003
By Mark Acuna on 11/17


Click here to see a screenshot of this code!Send message by Address IP
By alireza on 11/17

(Screen Shot)

Click here to see a screenshot of this code!XP Theme Support for Built-in VB Controls
By Vlad Vissoultchev on 11/17

(Screen Shot)

Click here to see a screenshot of this code!Mezclador
By Ronny Fretel on 11/17

(Screen Shot)

Simple Scrolling Banner
By Mike Hayes @Staticnetwork. co.uk on 11/17


Click here to see a screenshot of this code!A simple web browser with a few features
By Mike Hayes @Staticnetwork. co.uk on 11/17

(Screen Shot)

Move a form with any object
By Mike Hayes @Staticnetwork. co.uk on 11/17


Click here to put this ticker on your site!


Add this ticker to your desktop!


Daily Code Email
To join the 'Code of the Day' Mailing List click here!

Affiliate Sites



 
 
   

ADO Tutorial For Absolute Beginners

Print
Email
 

Submitted on: 10/14/2000 8:31:59 AM
By: Jerry Barnes  
Level: Beginner
User Rating: By 43 Users
Compatibility:VB 6.0

Users have accessed this article 59015 times.
 
 
     This is an ADO DB tutorial for programmers who know nothing about ADO. It is a good template to following when making your own project. I hope that it helps.
 
winzip iconDownload article

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.

Virus note:All files are scanned once-a-day by Planet Source Code for viruses,but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:
1)Re-scan downloaded files using your personal virus checker before using it.
2)NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
3)Scan the source code with Minnow's Project Scanner

If you don't have a virus scanner, you can get one at many places on the net including:McAfee.com

 
Terms of Agreement:   
By using this article, you agree to the following terms...   
1) You may use this article in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.   
2) You MAY NOT redistribute this article (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.   
3) You may link to this article from another website, but ONLY if it is not wrapped in a frame. 
4) You will abide by any additional copyright restrictions which the author may have placed in the article or article's description.


Other 4 submission(s) by this author

 

 
Report Bad Submission
Use this form to notify us if this entry should be deleted (i.e contains no code, is a virus, etc.).
Reason:
 
Your Vote!

What do you think of this article(in the Beginner category)?
(The article with your highest vote will win this month's coding contest!)
Excellent  Good  Average  Below Average  Poor See Voting Log
 
Other User Comments
11/6/2000 6:28:12 PM:John Weldon
I was very surprised to find the code easy to read. The proper naming conventions were used throughout the code which made it user friendly. Thanks for your explanation and demonstration of ADO programming!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
11/14/2000 11:35:34 AM:Andrew McManus
When you add a new record, instead of closing and opening the recordset again, you can use rsRecordSet.Requery.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
11/14/2000 2:22:26 PM:Jerry Barnes
Good point. I wrote this tutorial to get a better understanding of ADO. At the time, I thought it was easier to open and close the recordset. I may do an update when some changes such as yours (and use an HTML presentation like my Class Module Tutorial). Thanks for your input. Thanks
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
12/6/2000 3:15:21 PM:CRUZANA
Hey the code is very useful and cool!! it's a major InPuT!!!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
12/7/2000 8:41:20 PM:Pissedoff
You guys will probably laugh at this, but how do I get rid of this invalid key problem? I am using vb5, and none of the code I get from this site works.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
1/20/2001 2:51:38 PM:Philip
No other words.......Excellent
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/29/2001 12:16:31 AM:sanjay
i tried this example and it works excellent
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
4/6/2001 11:50:48 AM:wacook
I have an error when using a modified version of the ADOTutorial you wrote. Your code was very helpful.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
7/14/2001 2:25:01 PM:Geno
This is well commented and extremely helpful for string writing. Thanks
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
7/16/2001 5:37:56 PM:Rob
Finally someone out there that understands that there are those of us that are good programmers, just not always in the same language that they are. I was looking for a way to write programs that I have already done in cold fusion, in a stand alone application. this saved the day for me. Thanx
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
7/25/2001 8:44:36 AM:John Russell
Well done. Very clearly presented information which I found very useful.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/1/2001 10:33:39 AM:janilane
Thanks Jerry Barnes, I finally a code that doesn't have an error on ADO introduction, thanks for considering us new programmers by submitting beginner articles that would help us a lot. thank you again...
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
11/27/2001 3:52:56 AM:Paul Pardee
I have been searching for days for such an example. EXCELLENT WORK! Perfectly commented! THANK YOU!!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
1/5/2002 5:45:58 PM:DaveW
Really neat!! Gets ya cookin early! Thank you.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/20/2002 10:26:49 AM:wayne braun
Thank You! Thank You! Thank You! This gave me much needed help.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/14/2002 9:20:41 AM:woweee
this is code is awesome men !!!!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
5/4/2002 6:06:09 PM:James
In response to the VB5 and invalid key question, you need to open the VBP file and remove the line starting with 'Retained = '
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
5/14/2002 9:13:11 AM:lai tang
first time i ever commented on a code and this is worth it! man you are a life saver
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
5/21/2002 7:27:26 AM:gary
fantastic, got me working
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
6/1/2002 5:47:23 PM:Harsh Sabharwal
Hey, I am going to download your code. But my enquiry is "how to save IMAGE with data". e.g. Address book Printing. In this we need to save information of person + photograph. Please guide me.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
8/23/2002 2:06:44 PM:cheong
I have a question and I hope you can offer some insight. Do you know a simple way to use ADO to connect to a DBF file and store the data from the file in a recordset? Thank you
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
10/30/2002 4:42:52 AM:
I have been trying to use ADO but failed. i hope this will help
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
11/14/2002 10:49:10 AM:
EXCELLENT job.. keep it up!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
1/7/2003 11:27:31 AM:
I think the help is excellent! But I got a runtime error in the line: connRecovery.Open strConnect The database I'm reading is in access 2000, don't know if that's the problem.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
7/29/2003 4:16:06 PM:
I have now made changes in the program, now work good. Her your send this change ? I have not Your e-mail.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
10/26/2003 1:07:37 PM:
thanks you save my day, ur not just good programmer but a verygood programmer with character.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
Add Your Feedback!
Note:Not only will your feedback be posted, but an email will be sent to the code's author in your name.

NOTICE: The author of this article has been kind enough to share it with you.  If you have a criticism, please state it politely or it will be deleted.

For feedback not related to this particular article, please click here.
 
Name:
Comment:

 

Categories | Articles and Tutorials | Advanced Search | Recommended Reading | Upload | Newest Code | Code of the Month | Code of the Day | All Time Hall of Fame | Coding Contest | Search for a job | Post a Job | Ask a Pro Discussion Forum | Live Chat | Feedback | Customize | Visual Basic Home | Site Home | Other Sites | About the Site | Feedback | Link to the Site | Awards | Advertising | Privacy

Copyright© 1997 by Exhedra Solutions, Inc. All Rights Reserved.  By using this site you agree to its Terms and Conditions.  Planet Source Code (tm) and the phrase "Dream It. Code It" (tm) are trademarks of Exhedra Solutions, Inc.