16,554
社区成员
发帖
与我相关
我的任务
分享
Dim ds1 As DataSet = objManagerId.GetCarstorehouse(Me.ddlProvince.SelectedValue, Me.ddlCity.SelectedItem.Text, "", 1)
我想从ds1筛选出"location_type=1"的数据,怎样从dataSet 中筛选???
我做的思路是:
Dim ds1 As DataSet = objManagerId.GetCarstorehouse(Me.ddlProvince.SelectedValue, Me.ddlCity.SelectedItem.Text, "", 1)
Dim dr As DataRow() = ds1.Tables(0).Select(" where location_type=1")
Dim ds As New DataSet
ds.Tables(0).Rows.Add(dr)
但是报错: Dim dr As DataRow() = ds1.Tables(0).Select(" where location_type=1") 语法对不对????
我知道C#中可以这样写,不知道VB中行不???
急!!!
Dim dt As New DataTable
Dim DataRow As DataRow
'--关键代码--
dt = ds.Tables(0).Clone
'--
For Each DataRow In ds.Tables(0).Select("location_type=1")
dt.ImportRow(DataRow)
Next
Dim dr As DataRow() = ds1.Tables(0).Select("location_type=1")