Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Data Access options

Posted on 2004-10-28
Medium Priority
Last Modified: 2010-04-05

I have a tables with 500,000 records. and i have many screens in my application.

someone told me that if i use data-aware component then each of them makes a seperate connection with databas....

what are the other option we can access the database and display the data.....without using data aware component...

I am using sql-server and delphi 5 enterprise.....

Question by:princemahesh
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 27

Assisted Solution

kretzschmar earned 75 total points
ID: 12441639
>someone told me that if i use data-aware component then each of them makes a
>seperate connection with databas....

thats nonsens

if u use bde use a tdatabase
if u use ado use Tadoconnection

to connect to your database

meikl ;-)


Author Comment

ID: 12441659

Thanks meikl for ur comment

Could you tell me what is common way of displaying data in a object oriented application....

do we use ado components and data aware components....for data access or is there any other way.

I am just bit confused about how object oiented principles are implemented while coading...


LVL 17

Accepted Solution

geobul earned 75 total points
ID: 12442160

- one application-wide TADOConnection component for connecting to your SQLServer (ConnectionString property, for instance)
- several dataset components (TADOQuery, TADOTable, TADODataSet, etc.) connected to the TADOConnection above (their Connection property
- several TDataSource components, each linked to one dataset component via its DataSet property
- several DataControl components like TDBGrid, each connected to one TDataSource component via its DataSource property (and DataField property for TDBEdit, etc. which display one field only).

Regards, Geo
LVL 15

Expert Comment

ID: 12445025
Personally, I don't like to use data aware components.

Rather I use an ADOQuery to pull back the data I need and then manually populate say a TListView with the information you need.
I tend to work on the prinicipal, don't do anything unless the user causes an event. I also tend to do all my validating within my applications rather than database side

Geobul is correct though, 1 ADO Connection and several dataset components (usually a READ Query and a READ/WRITE query and maybe a GENERAL query)
LVL 17

Expert Comment

ID: 12447173
mikelittlewood, me neither :-) I use TEdit, TComboBox, etc. for manipulating data but it requires lots of coding while for displaying purposes the above is just enough.

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question