Hello,

 This is my situation:

 I have three columns  and image name column (4 colums in total) to be inserted into SQL SERVER database. I  want upload image and store into web folder  called "publicfolder" which I did but also I wnat that image name to be inserted into table in MS SQL SERVER 2000 as well as retrieve image from image folder using image name from database . I will appreciate your help:

This is my code:

ASP.NET 2.0

VB.NET:

 inserting into database:

SqlDataSource1.InsertParameters.Add("Email", TxtEmail.Text.ToString())

 End Sub

'Try

 If upImage.HasFile Then

Dim SavePath As String = (Server.MapPath("~/Publicfolder/") & "\" & upImage.FileName)

 lblImgname.Text = upImage.FileName

 Response.Write("Image File Name <b>" & upImage.FileName & "</b> <br>")

 End If

Catch ex As Exception

 Throw ex

 End Try

End Sub

Display data and image on asp page:

</td></tr>

Thanks in advance.

 Hi,

Check the Follwoing link.

http://www.aspsnippets.com/post/2009/02/21/Display-Images-from-Database-using-ASPNet.aspx

Hello Vora,

 I look at the link but that is not what I was looking for. I have not problem loading image directly into database, but I want is may I was not clear, here is what I need to do:

 I have page that users have to use to provide their name and email as well as thier picture:

I have a table with four columns: firstname, lastname, email and imagename

1. image stored into a folder called" publicfolder" locate web root

2. insert data for firstname, lastname , email and image pathname into the table.

3. retrieve firstname , lastname, email, and imagename from table . and imagename from table should also get image from "publicfolder" folder in web root.

4. display all on GRiedview.

Thanks

4. while  

Hi

           You just save the file name in database so that you can retrieve the imagefilename and bind it to any data display controls like datalist or grid view.

you can save filename in database with relation to userid i.e have 2 columns in database

ImageName nvarchar(20),

user id int not null..

 when ur saving the file in Image folder Pmap ,use this format

lbluploadresume.Text=Session["uid"].ToString()+"_"+Path.GetFileName(File1.PostedFile.FileName);

{

File1.PostedFile.SaveAs(Server.MapPath("~/Documents/"+lbluploadresume.Text));

///s=Server.MapPath("~/Documents/"+Label1.Text.ToString());

}

and save the lbluploadresume.text in database so that you with the uploaded filename userid will be attached so that if u have same filename for different users the new file will replace the old one.

when Your are retreiving the Image  use this code

<Img src='Foldername/<%#DataBinder.Eval(Container.DataItem,"ImageName")%>'