DataSet Select or Dataview Filter gives max performance????

[Laiju Skaria]

Hello all..
i've got 2 options 2 filter my data in a dataset....either user Select
method of the dataset or create a dataview and then apply the filter
criteria....Which gives the maximum performance...can anybody help??

smiles,
Laiju

 

[Joyjit Mukherjee]

Hi,

both techniques does the same thing. However, using dataview has an edge
because

1. It is available in design time also.
2. It can be used to bind data.
3. Creating the view once through the ctor ensures an index is created for
the column you filter for only once.


Regards
Joyjit

 

[Laiju Skaria]

Thanks Joyjit...Actually i had implemeted it using dataview itself...but
after seeing some posts on this channel...i got confused again....anyway
thanks for the info....

best regards,
Laiju

 

[Miha Markic [MVP C#]]

Hi,

both techniques does the same thing. However, using dataview has an edge
because

1. It is available in design time also.
2. It can be used to bind data.
3. Creating the view once through the ctor ensures an index is created
for
the column you filter for only once.

And it is dynamic - when records are added to table, DataView automatically
reflects them.