Rowfilter and variable

[hpl]

I have a DataView where I use the Rowfilter property. How do I set the value of a variable to the value that I get by using the rowfilter?

....
Dim objAdapter As OleDbDataAdapter = New OleDbDataAdapter( _
                "SELECT Dimension,Pris FROM [dbi$]", objConnection)
            Dim objDS As DataSet
            Dim objDV As DataView


            objDS = New DataSet()
            objAdapter.Fill(objDS, "pris")
            objDV = New DataView(objDS.Tables("pris"))
            objDV.RowFilter = "Dimension=26"

            Dim hpny As String
            hpny = objDV.ToString
            Response.Write(hpny)

As you can see I've tried ToString, but this only retures System.Data.DatView

[pvb]

How do I set the value of a variable to the value that I get by using the rowfilter?

This doesn't make any sense. You use the RowFilter to filter the results in a dataset leaving you with a DataView. That DataView, objDV in your example, IS the filtered result of applying the RowFilter. There's no variable to set or get, that DataView contains filtered rows of data that you can iterate thru or use as a datasource or whatever.