I am using
DataView.Rowfilter for getting one single row from a table for particular condition.
It's taking too much time, because I'm referring a table of thousand records around five hundred times...
Is there any other way to reduce the time for same functionality?
If we use for loop whether it will reduce the time?