CODEWITHSUNDEEP
c#asp.net
Rod
Rod

Reputation: 15475

Why wouldn't SqlDataSource or ObjectDataSource pull back efficiently to begin with

Why wouldn't SqlDataSource or ObjectDataSource pull back efficiently to begin with?

For example, say we're retrieving records for Northwind customers. There's 91 customers. If you use SqlDataSource or ObjectDataSource, why wouldn't it pull back just 10 at a time (by default) to begin with instead of all 91 records?

Wouldn't that promote better design?

Upvotes: 0

Views: 23

Answers (1)

Khazratbek
Khazratbek

Reputation: 1656

Use your own controls, make method to work with database, and select all records what you need, as you need, using your own conditions. SqlDataSource is for general cases, not a private case.

Upvotes: 1

Related Questions