| View previous topic :: View next topic |
| Author |
Message |
Guest
|
 Posted: Thu Apr 12, 2007 4:33 pm Post subject: Connecting DBGrid to query |
 |
|
Hi,
I succed to connect DBGrid to DataSource but I could't find the way of
connecting DBGrid to any ADOQuery. I don't want to see the complete
table, I want to see the required part of the table. Is there any way
to do this ?
Mücahit |
|
| Back to top |
|
 |
yannis
Guest
|
| Posted: Thu Apr 12, 2007 5:17 pm Post subject: Re: Connecting DBGrid to query |
|
|
mcelikag (AT) ebim (DOT) net explained :
| Quote: | Hi,
I succed to connect DBGrid to DataSource but I could't find the way of
connecting DBGrid to any ADOQuery. I don't want to see the complete
table, I want to see the required part of the table. Is there any way
to do this ?
Mücahit
|
connect Datasource to the required ADOQuery or use ADODataset
regards
YAnnis. |
|
| Back to top |
|
|
Bill Todd
Guest
|
| Posted: Thu Apr 12, 2007 8:24 pm Post subject: Re: Connecting DBGrid to query |
|
|
Set the DataSource.DataSet property to the ADOQuery.
Set the DBGrid.DataSource properety to the DataSource.
--
Bill Todd (TeamB) |
|
| Back to top |
|
|
Guest
|
| Posted: Fri Apr 13, 2007 8:11 am Post subject: Re: Connecting DBGrid to query |
|
|
On 12 Nisan, 15:17, yannis <n...@noware.non> wrote:
| Quote: | mceli...@ebim.net explained :
Hi,
I succed to connect DBGrid to DataSource but I could't find the way of
connecting DBGrid to any ADOQuery. I don't want to see the complete
table, I want to see the required part of the table. Is there any way
to do this ?
Mücahit
connect Datasource to the required ADOQuery or use ADODataset
|
I tried to connect Datasource to the required ADOQuery before, but I
didn't success, now its ok.
Many thanks for your helps.
Mucahit |
|
| Back to top |
|
|
Alain Quesnel
Guest
|
| Posted: Sun Apr 15, 2007 8:11 am Post subject: Re: Connecting DBGrid to query |
|
|
Once you have connected your DataSource to ADOQuery like Bill and have
mentioned,. use the SQL property to determine what "part" of your table you
want to display.
Ex.:
select * from mytable
where COUNTRY = 'XYZ'
will only display records for country XYZ
--
Alain Quesnel
alainsansspam (AT) logiquel (DOT) com
www.logiquel.com
<mcelikag (AT) ebim (DOT) net> wrote in message
news:1176377604.530950.146810 (AT) q75g2000hsh (DOT) googlegroups.com...
Hi,
I succed to connect DBGrid to DataSource but I could't find the way of
connecting DBGrid to any ADOQuery. I don't want to see the complete
table, I want to see the required part of the table. Is there any way
to do this ?
Mücahit |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
