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

  • Thread starter Thread starter Laiju Skaria
  • Start date Start date
L

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
 
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
 
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
 
Joyjit Mukherjee said:
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.
Click to expand...
And it is dynamic - when records are added to table, DataView automatically
reflects them.
 
Back
Top