DataSet versus DataReader. Which one to use? Thank You.

[Shapper]

Hello,

I want to retrive N records from a database (I am using SQL and Access
in 2 different projects):

id class text
1 book book comments
2 paper paper comments
....

I will filter records according to "class" field values.
I will allways get ONLY 2 to 4 records which [text] field I will display
in different places of my page.

Should I use a dataset or a datareader?
I read somewhere that for such cases a datareader is better but I am not
sure. What do you think?

Thank You,
Miguel

 

[Steve C. Orr [MVP, MCSD]]

For a scenario as simple as you describe, a DataReader would be the most
efficient solution.

 

[Shapper]

Thanks Steve.

Cheers,
Miguel

For a scenario as simple as you describe, a DataReader would be the most
efficient solution.

Hello,

I want to retrive N records from a database (I am using SQL and Access in
2 different projects):

id class text
1 book book comments
2 paper paper comments
...

I will filter records according to "class" field values.
I will allways get ONLY 2 to 4 records which [text] field I will display
in different places of my page.

Should I use a dataset or a datareader?
I read somewhere that for such cases a datareader is better but I am not
sure. What do you think?

Thank You,
Miguel