请教一个DataView 和 DataSet 的问题

[zwl]

在DataView中已过滤掉无用的数据，

但要求返回已过滤掉无用记录的 DataSet 怎么实现呢？

试了好多次了，请教？

[zwl]

顶一下！

[Samen168]

首先需要明确过滤只是对DataView有效，如果你通过table去取数据还是原来的
真的需要返回过滤后的数据只有创建一个新的DataSet把得到的行加进去了

[Knight94]

to 但要求返回已过滤掉无用记录的 DataSet 怎么实现呢？

用同样的filter来进行查找，例如：
DataRow[] dr = yourDataTable.Select( yourDv.RowFilter, null, null, DataViewRowState.ModifiedCurrent );

DataTable dtClone = yourDataTable.Clone();//Clone datatable structure
DataSet ds = new DataSet();
ds.Tables.Add( dtClone );
ds.Merge( dr );

[landy_shasha]

学习，~~~~~~~~

[gezichong]

Private Sub GetRowsByFilter()

Dim customerTable As DataTable = New DataTable("Customers")

' Add columns
customerTable.Columns.Add("id", GetType(Integer))
customerTable.Columns.Add("name", GetType(String))

' Set PrimaryKey
customerTable.Columns("id").Unique = True
customerTable.PrimaryKey = New DataColumn() _
{customerTable.Columns("id")}

' add ten rows
Dim id As Integer
For id = 1 To 10
customerTable.Rows.Add( _
New Object() {id, String.Format("customer{0}", id)})
Next id
customerTable.AcceptChanges()

' add another ten rows
For id = 11 To 20
customerTable.Rows.Add( _
New Object() {id, String.Format("customer{0}", id)})
Next id

Dim expression As String
Dim sortOrder As String

expression = "id > 5"
' Sort descending by CompanyName column.
sortOrder = "name DESC"

' Use the Select method to find all rows matching the filter.
Dim foundRows As DataRow() = _
customerTable.Select(expression, sortOrder, _
DataViewRowState.Added)

PrintRows(foundRows, "filtered rows")

foundRows = customerTable.Select()
PrintRows(foundRows, "all rows")
End Sub

Private Sub PrintRows(ByVal rows() As DataRow, ByVal label As String)
Console.WriteLine("\n{0}", label)
If rows.Length <= 0 Then
Console.WriteLine("no rows found")
Exit Sub
End If

Dim row As DataRow
Dim column As DataColumn
For Each row In rows
For Each column In row.Table.Columns
Console.Write("\table {0}", row(column))
Next column
Console.WriteLine()
Next row
End Sub

[tshark]

VB...学习中

[zwl]

感谢 Knight94 Samen168 gezichong 三位的帮助，问题已解决