Filter?

How can I use a filter in ASP.Net like ASP 3.0?

Code:

---

sqlVfPur = "SELECT * FROM diverse_faktorer"       
               
                set rs0 = myconn2.execute(sqlVfPur)
                rs0.filter = "ID='1'"               
                VfPurArr(i) = rs0("Faktor")

---

This is my function in ASP.Net where I've uses oleDbDataReader.

Code:

---

Protected Sub MedieroersPris()
        Dim strCn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=" & Server.MapPath("HpSap.xls") & ";" & _
        "Extended Properties=Excel 8.0;"
        'Dim strSql As String = "SELECT pris FROM [Sheet1$] WHERE Dim <= 323"
        Dim strSql As String = "SELECT costing FROM [Sheet1$] WHERE Lgd=6 AND Material_type='St37' ORDER BY Dim ASC"

        Dim objConnection As New OleDbConnection(strCn)
        Dim objCommand As New OleDbCommand(strSql, objConnection)
        Dim objDataReader As OleDbDataReader

        objConnection.Open()
        objDataReader = objCommand.ExecuteReader()
        For i = 0 To objDataReader.FieldCount
            Do While objDataReader.Read() = True
                prisMedie(i) = CSng(objDataReader("costing"))
                i += 1
            Loop
        Next

        objDataReader.Close()
        objConnection.Close()
    End Sub

---

A dataview has a rowfilter method. You could create a DV object and set it = to a datareader table. Then you can filter the DV.

I'll post an example later if you need one.

Great, if you have an example it would be great (Lazy! ;) )

VB Code:

Dim dv as New DataView(MyDataTable)
dv.RowFilter = "ID = " & id

Do you have an example where you connect to an Access database and the filtering the selection?