Database conn. and filter in .Net

[hpl]

I wish to use the filter in ASP.Net, how will this code be in .Net?

set myconn2 = server.createobject("ADODB.connection")
myconn2.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&server.mappath("priser.mdb")
sqlPrisPur = "SELECT * FROM pris_pur" 	
set rs0 = myconn2.execute(sqlPrisPur)
rs0.filter = "ID='9'"		
PrisPurArr(i) = rs0("pris")
rs0.close

I've found out how to bind information to a drpList, but what if it is binding to a label or a text field?

Protected Sub bindDimensioner()
         Dim strCn As String = "Provider=Microsoft.jet.oledb.4.0;"
        strCn += "Data Source=" & Server.MapPath("priser04.mdb") & ";"
        Dim cn As OleDbConnection = New OleDbConnection(strCn)
        Dim cmdText As String = "Select dimId as dimID, dimension FROM MedieDim WHERE matId=" & intMatNr & " ORDER BY dimension ASC"
        Dim cmd As OleDbCommand = New OleDbCommand(cmdText, cn)
        cmd.Connection.Open()
        Dim1.DataSource = cmd.ExecuteReader()
        Dim1.DataValueField = "dimId"
        Dim1.DataTextField = "Dimension"
        Dim1.DataBind()
        cmd.Connection.Close()
    End Sub