Dim result As New System.Data.DataTable
SqlDataAdapter.Fill(result)
If result.Rows.Count >= 2 and Then
Dim id_flag As String 'id_flag是列名
For Each drr As DataRow In result.Rows
id_flag &= '" & drr("id_flag") & "' & "or"---------这么写肯定不对,那么应该怎么写?循环到最后一行or不要。
Next
strS ql = "sel ect * from [可用数量表] where " & “(” & "id_flag" & ")"
End if
问题很简单,我就是希望循环result表的行,如果行数大于等于2,比如行数为3行,第一行的drr("id_flag") = 1,第二行的drr("id_flag") = 2 ,第三行的drr("id_flag") = 3.
然后希望strsql变为下面的。
strS ql = "sel ct * from [可用数量表] where " & “(” & id_flag = "1" or id_flag = "2" or id_flag = "3" & ")"