properties are quite different from fields (variables). They provide indirect access to private fields. A field will store data but a property provides a specific access point to that data....
just sounds like you need to change the default location of your website within the IIS MMC console. You'll find that in your control panel > administration tools > IIS. Find your website...
You're already seting the integer J to the count of rows returned from your query. Next you're using that value in your For statement. If you're count 0 then your For loop would do nothing...
if you have a copy of all the files from the web server then you have everything you need. The only other files I would asume he is holding on to is the Visual Studio project files and these...
I don't know of any reason why you wouldn't be able to connect to a database thats outside the site's root. I don't have VS 2005 installed now but did it no problem with VS2010.
I'm not a dreamweaver user so I'm not sure of it's behaviour when creating a new asp.net site however here is a tutorial for running aspx pages in dreamweaver 8, see if that gives you any...