🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #602

Re: TADO and DBASE?for new(in ADO)

#602
From: Viatcheslav V. Vassiliev
Date: Tue, 04 Oct 2005 07:45
62 lines
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-mail
References: <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