[2005] Display record from Table

[Simply Me]

Hello! I wonder what's the equivalent value of this vb6 code in vb.net. I would like to display specific valueto textbox from table.

    rsStocks.Open "SELECT * FROM tblStocks WHERE Code = '" & txtCode.Text & "'", oConn, adOpenStatic, adLockOptimistic
    If rsStocks.RecordCount <> 0 Then
      txtSupply.Text = rsStocks.Fields("Quantity")
      txtDesc.Text = rsStocks.Fields("ProductDescription")
      'txtSellingPrice.Text = Format$(rsStocks.Fields("SellingPrice"), "P###,###,##0.00")    End If