winforms - gridview row filter -


I have named gridview with 800k rows myGridView One of the columns is named NAME is and can have value in Alex (1) , where there is a current serial number for Alex. When I insert the new rank for Alex, I want to place it with the value of the name "Alex (N)" where n is the smallest number that has not been taken. I think I should filter something like this: var rows = (gridview in all objects). Select (where rows NAME.IndexOf ("Alex (") & gt; -1)

and it will send me all code for Alex (some numbers) And now I have to filter by number I think ... how to properly filter which I have not been taken to return to the smallest number yet? Can it be faster? < / Div>

First of all, I should mention that the code you pasted will not work Because this does not provide grid line archive. Also, even though this code works, it will work very slowly as it will have to filter 800k rows on the web server. Do not you think the DB server requires the necessary information Is it better to request, which is optimized for working with such questions and will be able to process your request faster?

Comments