Need Design help to query the databse.

[Kiran123]

Hi,

I am workin with visual studio 2005, framework require help with windows forms.
I want to fetch data from database where i want to put a sql query which needs to be flexible in terms of where & order by clauses.
Can you suggest me any better method that I should use? The application will fetch one record from database at a time.

[opaper]

Try
1. ADO.NET SQL Command Objects
OR
2. ADO.NET Entities framework with Linq to Entities and ESQL

[Chandrakant81]

Well My databse is in Ms access & do you think ADO.NET Entities framework is worth learning for the same?

Regards,

[Vaibhav S]

If you're only bringing back 1 records at a time, why do you need an ORDER
BY?

[Zecho]

what you're describing can be done against an Access/JET/ACE or a SQL
Server database but if not done correctly, only one user will be able to
access the data at any one time. When you execute a query

SELECT name, address, city, state FROM Customers WHERE State = 'TX'
ORDER BY CountyCode, Name

you'll return all of the customers in Texas--one row at a time if you use a
DataReader. However, until you fetch the last row, the database engine will
(probably) impose "share locks" on the data rows (and pages) that will
prevent changes to the underlying rows. For this reason (and many others) we
generally fetch the rows into a server-side cursor or into a client-side
structure like a DataTable or TableAdapter using a Fill or Load method. This
releases the locks and lets other users access the data.