Link to home
Start Free TrialLog in
Avatar of princemahesh
princemahesh

asked on

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
SOLUTION
Avatar of kretzschmar
kretzschmar
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of princemahesh
princemahesh

ASKER

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


ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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)
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.