使用LINQ查询的DataGridView单元搜索 [英] DataGridView cell search using a LINQ query
问题描述
我对LINQ还是比较陌生,并且在绊脚石方面做得比任何事情都多,但是我真的很喜欢到目前为止所看到的.因此,考虑到这一点,我有一个VB.NET搜索例程,下面提供了部分例程,该例程使用一组基本的嵌套循环执行搜索,以检查给定字符串(包括两端)在DataGridView中的所有Text单元格. :
I'm still relatively new to LINQ, and have done more stumbling around than anything, but I have really liked what I have seen so far. So with that in mind, I have a VB.NET search routine, part of which is provided, below, that checks all Text cells in a DataGridView for a given string (inclusive), using a basic set of nested loops to perform the search:
' Search for the first occurrence of the given string
For Each row As DataGridViewRow In dgvMembers.Rows
' Skip the new row
If row.IsNewRow Then Exit For
' Loop through all the cells in the current row
For Each cell As DataGridViewCell In row.Cells
' Skip non-text cells
If cell.GetType IsNot GetType(DataGridViewTextBoxCell) Then Continue For
' Search for our matching text
If cell.Value.ToString.ToUpper.Contains(searchText) Then
' Select the cell if we have a match
dgvMembers.CurrentCell = cell
WriteMessage("String '{0}' found.", searchText)
Exit Sub
End If
Next
Next
' If we get to this point, we didn't find anything
WriteMessage("String '{0}' NOT found.", searchText)
非常简单.现在,我的问题是:有没有办法使用LINQ复制此行为?基本上,我希望查询选择(或返回)第一个DataGridViewCell,其文本包含搜索字符串.我已经对子查询等进行了一些修补,但是我仍然难以将思想包扎在概念上(我想写T-SQL太多年了).
Pretty straightforward. Now, my question is: is there a way to replicate this behavior using LINQ? Basically I would like the query to select (or return) the first DataGridViewCell whose text contains the search string. I've done some tinkering with sub-queries and the like, but I'm still having trouble wrapping my brain around the concepts (too many years of writing T-SQL, I guess).
显然,嵌套循环可以正常工作,因此,这确实是一种好奇.提前致谢!
Obviously the nested loop works fine, so this is more of a curiosity, really. Thanks in advance!
推荐答案
我能够成功地使用此代码:
I was able to use this code with some success:
Dim qry = From theRow as DataGridViewRow In dgvMembers.Rows, _
theCell as DataGridViewCell In theRow.Cells _
Where theCell.Value.ToString.ToUpper = searchText _
Select theCell
Dim matchCell as DataGridViewCell = qry.First
dgvMembers.CurrentCell = matchCell
...等等...
这篇关于使用LINQ查询的DataGridView单元搜索的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!