A faster way to find an item in a bindingsource and return its index

[desanti]

Hello ! I'm using entity framework 6 with sql server 2008r2. I have a bindingsource :

Mybindingsource.datasource=(From t in context.myobjects order by t.name select t).ToList

Now , I want to search inside the bindingsource , and get the found item's index. I'm using this code :

Function findindex(startposition as integer) As integer
Dim p as Myobject
Dim i as integer
For i=startposition to Mybindingsource.count-1
p=MyBindingsource.item(i)
if p.value=3 then return i
Next
return 0
End Function

This code is working , but when the bindingsource contains too many itmes , is very slow. Is there any faster way ? Thank you !

[Lost User]

desanti wrote:

This code is working , but when the bindingsource contains too many itmes , is very slow. Is there any faster way ?

Yes, select by primary key instead of an index.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

[desanti]

Sorry , I need to get the index of found item in bindingsource.

[Lost User]

Than you will have to deal with a slow bindingsource.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.