DataTable RowFilter 過濾數據

用Rowfilter加入過濾條件

eg：

string sql = "select Name,Age,Sex from UserInfo";

DataTable dt = DataAccess.GetDataTable(sql);//外部方法（通過一條查詢語句返回一個DataTable）

dt.DefaultView.RowFilter = "Sex=女";

dt.DefaultView.RowFilter = "Age>18";

dt.DefaultView.RowFilter = "Name like '%張%'";

不過RowFilter不支持不等于(<>、!=、not like)，不過如果只是單純的對確定的字符串操作，可以用in和not in，數據庫查詢語句則不行。

?

Dim dt As DataTable = Getdata(20078, "abc")
Dim view As DataView = New DataView(dt)
view.RowFilter = "Names in('ttt','tttt')"
GridView1.DataSource = view.ToTable()?--這個才過濾成功?
GridView1.DataBind()

?

Private Function GetNewTable(ByVal dt As DataTable, ByVal filter As String) As DataTable
Dim newTable As DataTable = dt.Clone()
Dim drs As DataRow() = dt.Select(filter)
For Each dr As DataRow In drs
Dim arr As Object() = dr.ItemArray
Dim newrow As DataRow = newTable.NewRow()
For i As Integer = 0 To arr.Length - 1
newrow(i) = arr(i)
Next
newTable.Rows.Add(newrow)
Next
Return newTable
End Function

?datatable 中select在vb.net中寫法

ds.Tables("RoomType").Select("MealType=" & "'" & mgdr("MealType") & "' and Roomtypecode=" & "'" & mgdr("Roomtypecode") & "' and Availability=" & "'" & mgdr("Availability") & "' and VendorCurreny=" & "'" & mgdr("VendorCurreny") & "' and RoomAdults=" & "'" & mgdr("RoomAdults") & "' and FromDate=" & "'" & mgdr("FromDate") & "' and ToDate=" & "'" & mgdr("ToDate") & "' and Runno=" & "'" & mgdr("Runno") & "'")

也可以用String.Format 格式化

?

data.Tables("error").Columns.Remove("postXml")'移除某列數據
GridView2.DataSource = data.Tables("error")
GridView2.DataBind()