Data Access options

Posted on 2004-10-28
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
    LVL 27

    Assisted Solution

    >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


    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


    - 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

    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

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
    In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
    This video discusses moving either the default database or any database to a new volume.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    846 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

    Need Help in Real-Time?

    Connect with top rated Experts

    6 Experts available now in Live!

    Get 1:1 Help Now