• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 296
  • Last Modified:

Data Access options

Hi

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.....

Mahesh
0
princemahesh
Asked:
princemahesh
2 Solutions
 
kretzschmarCommented:
>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 ;-)

0
 
princemaheshAuthor Commented:
Hi

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...

Mahesh


0
 
geobulCommented:
Hi,

- 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
0
 
mikelittlewoodCommented:
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)
0
 
geobulCommented:
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.
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now