Hi , i am new to vb.net can anyone help me how to use recordset in vb.net.
Basically this is the asp code and i want to do this in vb.net.

sql = " select * from product "
rs.open sql, conn


while not rs.eof do
    productname  = rs("ProductName")
   Id  = rs ("productId")
rs.Movenext
loop


Regards

For Sql Server:

Dim ConnString As String = <Your Connection String>
Dim ProductName As String
Dim Id As Integer
Dim Sql As String = "Select * From Products"
Using conn As New SqlConnection(ConnString)
  Using cmd As New SqlCommand(Sql, conn)
    cmd.CommandType = CommandType.Text
    conn.Open()
    Using reader As SqlDataReader = cmd.ExecuteReader()
      While reader.Read()
        ProductName = reader("ProductName")
        Id = reader("ProductID")
      End While
    End Using
  End Using
End Using