I am new to .net. I am using VB .net to build an asp for a nightly script.

I have the code to read from the DB, I am using SQL server 2003. It connects, and I assume gets the data because it doesn't error....but

I have written several datagrids and understand how to get the data out of the dataset, but I want to use the SqlDataReader instead because all I need to do is combine 2 column values in order to create a path to a document directory on the server in order to suck some PDFs in.

I am unfamiliar with how to get the values out once you load them in using the datareader. I was thinking this would be simliar to recordsets, but haven't been able to figure this out.

Thanks for any help you can give.