I have retrieved a single row of data using sqldatareader and want to load the value of each column into a session variable. How do I do this in VB.NET? For example this is how I did it in classic ASP. Just can't quite figure out the syntax in VB.NET. Thanks!


For Each strField In UserReader.Item

   strName = strField.Name

   strValue = strField.Value

   Session(strName) = strValue

Next

You need to use a while loop:

Do While yourdatareader.read()
   strName = yourdatareader.Item("name")
   .. etc. do it for each column
Loop