Dim mydataset As New DataSet
Dim rs_raw As String = "select aa,bb from A1 order by aa"
Dim da As New SqlClient.SqlDataAdapter
da.SelectCommand = New SqlClient.SqlCommand(rs_raw, conn)
da.Fill(mydataset)
DataGridView1.DataSource = mydataset.Tables(0)

我想查找DataGridView1第一列数据里某个字符或前字符，请问怎样找法。

Private Sub TextBox2_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox2.TextChanged
Dim i As Integer
Dim aa As Integer = Len(TextBox2.Text)
For i = 0 To DataGridView1.Rows.Count - 1
If Len(DataGridView1.Rows(i).Cells(0).Value) > aa Then
If Mid(DataGridView1.Rows(i).Cells(0).Value, 1, aa) = Mid(TextBox2.Text, 1, aa) Then
DataGridView1.CurrentCell = DataGridView1.Rows(i).Cells(0)
Exit Sub
End If
End If
Next
End Sub

上面的找法，如果数据有3万条以上就会很慢，我想用有关mydataset.Tables(0)的查找，怎样可以实现呢？

查找知道了

Dim a As String
a = UCase(TextBox2.Text) &　"%"
mydataset.Tables(0).Select("aa" Like a)

但是又有一个问题,DataGridView1的光标不会跑到查找到的行.

怎样获取到我查找位置在第几行呢?

[此贴子已经被作者于2007-8-16 10:10:25编辑过]

DataGridView1.CurrentCell = DataGridView1.Rows(i).Cells(0)

这样不行吗？

就是没法确定行数,DataGridView1.Rows(i).Cells(0) i的值拿不到！