Web Forms :: Save The File Name With The Extension Alone In Table (without The Full Path)?

am a newbie to programming so please bare with me!I introduced a file upload control on one of my pages. There is a button click event for the upload which triggers not only the upload but also an insert into a table in my database.Every aspect of the button click event for this upload is working as expected; however I do have a couple of queries because the results are not quite as I would like them. I am using asp.net 3.5 and C# in code behind page.

I have a simple table with 3 columns in my database: Username, PhotoTitle and PhotoUrl. In the button click event I grab the PhotoUrl like such -string photoUrl = FileUpload1.PostedFile.Filename; (I am using the photo url from my images folder in the application to show photos in Gridviews etc. I prefer this to storing the actual image in the database for the moment until i am a bit more experienced since i don't know much about varbinary dbtype.). When the button is clicked for the upload, the details of the photo are saved in the database table, but it's the full path of the file on my laptop which is store (C:/Documents/.../filename.jpg) opposed to "Filename.jpg" for example, which i obviously would prefer because in the application photos are displayed using the"~/images/Filename.jpg" path. How can I save the file name with the extension alone in my table (without the full path)?

The second problem is basically regarding the actual photos being uploaded. They are"saved as" inside folder for the solution as anticipated, but only on the laptop harddrive, which means that I have to manually drag each photo uploaded into the images folder within Solution Explorer, from a Windows Explorer window, in order to be able to display them in Gridviews etc (with the "~/images/Filename.jpg" call in the .aspx code). This is not acceptable of course since the site users would expect to see their photo after the upload, and they would not be able to drag the file into the ~/images/ folder. How can I get round this second slight problem; i.e. is there a way to upload photos directly in the folder so that they show directly on the solution explorer?I hope my explanations of those two little problems I have didn't confuse you all?