Article View: borland.public.cppbuilder.database.ado
Article #626Re: ADO begginer
From: poojo hackma
Date: Mon, 31 Oct 2005 20:26
Date: Mon, 31 Oct 2005 20:26
30 lines
2319 bytes
2319 bytes
Wow! Great post! This thread was very helpful, and it saved me hours of work! On step 14, I noticed you used TDataSource and TDBGrid instead of ADO's TADODataSet and TADOTable. Why not stick with all ADO components? Is this just personal preference, or is there something more? (Remember: I am a newbie at this) "Viatcheslav V. Vassiliev" wrote... > 1. Create new project. > 2. Drop TADOConnection on main form. > 3. Press "ConnectionString button" (...). > 4. Press "Build". > 5. Choose "Microsoft Jet 4.0 OLE DB provider". Press "Next" > 6. Set Data Source to "C:\Temp\Test.mdb" or to .mdb file you have. > 7. Press Check Connection - it should be successfull. > 8. Press OK. > 9. Set LoginPrompt property to False; > 10. Set Connected property to True. > 11. Drop TADOTable on the form and set its Connection property to > ADOConnection1. > 12. Set TableName to "YourTableName" - table name that exists in your > database. > 13. Set Active property to True. > 14. Add TDataSource and TDBGrid on the form, connect them to ADOTable1 as > usual (set DataSource1's DataSet property to ADOTable1 and DBGrid1's > DataSource property to DataSource1). > > Now you should see your table in grid. >
Technical Details
Message-ID:
<43667ddf$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!news-out.newsfeeds.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mailReferences:
<42bb2437@newsgroups.borland.com> <42bba97c@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,9b3472ac92b88f2e X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII-7-bit From: "poojo hackma" <poojo.com/mail> Newsgroups: borland.public.cppbuilder.database.ado References: <42bb2437@newsgroups.borland.com> <42bba97c@newsgroups.borland.com> Subject: Re: ADO begginer Date: Mon, 31 Oct 2005 14:26:11 -0600 Lines: 32 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2670 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 X-RFC2646: Format=Flowed; Response X-Antivirus: avast! (VPS 0544-0, 10/31/2005), Outbound message X-Antivirus-Status: Clean NNTP-Posting-Host: 12.45.133.147 Message-ID: <43667ddf$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1130790367 12.45.133.147 (31 Oct 2005 12:26:07 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!news-out.newsfeeds.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail