vb C# 中 datatable 模糊查询如何写。like语句 。急急急。
现在我的代码是这样的。红色标注部分是我想实现模糊查询,但是这样写不对。如下:
''' <summary>
''' </summary>
''' <param name="B3cdin"></param>
''' <returns></returns> Where tbl.B1CD Like B3cdin + "%" _
''' <remarks></remarks>
Public Function GetListDataWithB3cd(ByVal B3cdin As String) As wData.WppDataSet.VTMTN035MST_01DataTable
Dim result As New WppDataSet.VTMTN035MST_01DataTable
If String.IsNullOrEmpty(B3cdin) Then
Dim filter = _
From tbl In getCommonDataSet().VTMTN035MST_01.AsEnumerable() _
Order By _
tbl.TENPOCD, _
tbl.B3KBN, _
tbl.GRAPH, _
tbl.B3CD
For Each row2 In filter
result.ImportRow(row2)
Next
Else
Dim filter = _
From tbl In getCommonDataSet().VTMTN035MST_01.AsEnumerable() _
Where tbl.B1CD Like B3cdin + "%" _ Order By _
tbl.TENPOCD, _
tbl.B3KBN, _
tbl.GRAPH, _
tbl.B3CD
For Each row2 In filter
result.ImportRow(row2)
Next
End If
Return result
End Function