Article View: borland.public.cppbuilder.database.ado
Article #602Re: TADO and DBASE?for new(in ADO)
From: Viatcheslav V. Vassiliev
Date: Tue, 04 Oct 2005 07:45
Date: Tue, 04 Oct 2005 07:45
62 lines
3406 bytes
3406 bytes
Place TADOConnection component, and set its ConnectionString property. Then place TADODataSet component, set Connection property to ADOConnection1, and CommandText to sql query. Add TDataSource and set its DataSet property to ADODataSet1. Add TDBGrid and set its DataSource property to DataSource1. Finally set ADOConnection1->Connected to true and ADODataSet1->Active to true. //------------------------------------------ Regards, Vassiliev V. V. http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + ADO.Net http://www.oledbdirect.com - The fastest way to access MS SQL Server, MS Jet (Access) and Interbase (through OLEDB) "Partaud" <patartaud@wanadoo.fr> �������/�������� � �������� ���������: news:43419af8$1@newsgroups.borland.com... > Thank you > I go to try it but I don't know if I have DBase 4 or 5.And this is when I > put a ADO component on my form, I suppose. > It is the ^property o the component? > I thank you again > Patrick > "Viatcheslav V. Vassiliev" <support@oledbdirect.com> a �crit dans le > message de news: 43415e28@newsgroups.borland.com... >> Connection string is: >> >> Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\dir;Extended >> properties=dBase 5.0 >> >> Query is >> >> select * from mytable >> >> Assuming file is mytable.dbf. Jet provider uses BDE. >> >> //------------------------------------------ >> Regards, >> Vassiliev V. V. >> http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + >> ADO.Net >> http://www.oledbdirect.com - The fastest way to access MS SQL Server, >> MS Jet (Access) and Interbase (through OLEDB) >> >> >> "Partaud" <patartaud@wanadoo.fr> �������/�������� � �������� ���������: >> news:433f952a@newsgroups.borland.com... >>> Hello >>> I would connect at running time a DBase table "mytable.db" which is in >>> "mydirectory".I have read the help but at running time I don't understnd >>> what I must do I have tried but...nothing. >>> It isbecause I would open it with "prolog" but it accept only ADO bases. >>> Could you send a sample of code please to me? >>> I have look for it in help fils but nothing >>> Excuse my English >>> Thank you in advance >>> Patrick >>> >> >> > >
Technical Details
Message-ID:
<4342328f$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newscon06.news.prodigy.com!prodigy.net!logbridge.uoregon.edu!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<433f952a@newsgroups.borland.com> <43415e28@newsgroups.borland.com> <43419af8$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,35b43ee2c9d71827 X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com> Newsgroups: borland.public.cppbuilder.database.ado References: <433f952a@newsgroups.borland.com> <43415e28@newsgroups.borland.com> <43419af8$1@newsgroups.borland.com> Subject: Re: TADO and DBASE?for new(in ADO) Date: Tue, 4 Oct 2005 11:45:19 +0400 Lines: 64 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 NNTP-Posting-Host: 85.93.138.132 Message-ID: <4342328f$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1128411791 85.93.138.132 (4 Oct 2005 00:43:11 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newscon06.news.prodigy.com!prodigy.net!logbridge.uoregon.edu!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail