如何根据TextBox
值选择DevExpress
GridView
上的完整行?
我尝试了以下代码,但它不起作用:
Dim rowHandle As Integer = GridView1.LocateByDisplayText(0, colC_Id, txtSelect.Text)
If rowHandle <> DevExpress.XtraGrid.GridControl.InvalidRowHandle Then
Dim row As System.Data.DataRow = GridView1.GetDataRow(GridView1.FocusedRowHandle)
row(0) = txtSelect.EditValue
End If
该代码未在网格control中选择一行。它对GridColumn Colc_id中的文本框中输入的文本进行了案例敏感的搜索,如果找到了匹配项,则将GridControl数据源的第二列(列索引1)中的文本更新为"当前选择的行。如果已将数据源中的字段添加到GridControl的GridColumn集合中,则更新的值将反映在GridControl中。
这是一个如何根据特定值选择GridControl的数据源是数据源的示例:
Dim myDataTable As DataTable = DirectCast(GridControl1.DataSource, DataTable)
Dim sFieldName As String = colC_Id.FieldName
Dim sColumnName As String = colC_Id.Name
Dim myDataRows As DataRow() = myDataTable.Select(sFieldName & "='" & TextBox1.Text.Replace("'", "''") & "'")
If myDataRows.Length > 0 Then
Dim iDataSourceRowIndex As Int32 = myDataTable.IndexOf(myDataRows(0))
GridView1.FocusedRowHandle = GridView1.GetRowHandle(iDataSourceRowIndex)
Else
MessageBox.Show("The text '" & TextBox1.Text & "' was not found in column '" & sColumnName &"'")
End If