move rows in a dataview

[Sam]

Hi,
How can I move a row in my dataview to the first position ?

Thx

 

[Ken Tucker [MVP]]

Hi,

Sorting the dataview will reorder the records. You might have to
add a column to the datatable for sorting


Dim strConn As String
Dim ds As New DataSet
Dim strSQL As String
Dim daEmployees As OleDbDataAdapter
Dim conn As OleDbConnection
strConn = "Provider = Microsoft.Jet.OLEDB.4.0;"
strConn &= "Data Source = Northwind.mdb;"

conn = New OleDbConnection(strConn)
da = New OleDbDataAdapter("Select * From Categories", conn)
da.Fill(ds, "Categories")

Dim dcSort As New DataColumn("First", GetType(Integer))
ds.Tables("Categories").Columns.Add(dcSort)

Trace.WriteLine("Before sort")
Dim dv As New DataView(ds.Tables("Categories"))
For Each drvCategories As DataRowView In dv
Trace.WriteLine(drvCategories.Item("Description"))
Next

For Each drvCategories As DataRowView In dv
drvCategories.Item("First") = 1
Next

dv.Item(4).Item("First") = 0
dv.Sort = "First"
Trace.WriteLine("After sort")
For Each drvCategories As DataRowView In dv
Trace.WriteLine(drvCategories.Item("Description"))
Next


Ken
---------------------


Hi,
How can I move a row in my dataview to the first position ?

Thx