datatable的select方法究竟怎么用？（vb.net）

[cocoboy12345]

我用下面的方法总是出错，望高手们给指点一下啊？
Dim mytable As Data.DataTable
Dim myrow As Data.DataRow
Dim tiaojian As String
然后我在窗体的load事件中写了：
SqlDataAdapter1.Fill(DataSet11)
mytable = DataSet11.Tables.Item(0)
tiaojian="数量=1"
这样应该是把数据载入到了mytable这样表中了吧，我用myrow=mytable.select(tiaojian)总是要出错？

[haike]

跟踪一下,看你的DataTable有没有行.或者你的ColumnName有错.

[cocoboy12345]

datatable有数据的啊？我另外用一个datagrid可以正常显示数据的啊

[tantj]

mytable = DataSet11.Tables[0];
myrow = mytable.Select("xxx=2");

[cocoboy12345]

显示错误：类型“system.data.datarow的1维数组的值无法转化维system.data.datarow”

[CloneCenter]

Select方法返回一个DataRow的数组，所以你定义的myrow类型是不对的。
MSDN中的例子：

Private Sub GetRowsByFilter()
    
    Dim table As DataTable = DataSet1.Tables("Orders")

    ' Presuming the DataTable has a column named Date.
    Dim expression As String
    expression = "Date > '1/1/00'"
    Dim foundRows() As DataRow

    ' Use the Select method to find all rows matching the filter.
    foundRows = table.Select(expression)

    Dim i As Integer
    ' Print column 0 of each returned row.
    For i = 0 to foundRows.GetUpperBound(0)
       Console.WriteLine(foundRows(i)(0))
    Next i
End Sub