upload image to sql server

[y_mmohd]

I want to upload an image to sqlserver, i use fileupload control and upload the image. But when I retrieve it to gideview it appears as a text: System.Byte[] How can i solve this problem.. thanks

[eyeseetee]

I always say that it is better to store the file location of the image in your database rather then the actual image. This means that your database doesnt become bloated and at the same time you can retrieve the image in almost the same way.

[y_mmohd]

Could you explaine more what you mean. Im using the following code to upload the file is there any mistake. Dim imageBytes(FileUpload1.PostedFile.InputStream.Length) As Byte FileUpload1.PostedFile.InputStream.Read(imageBytes, 0, imageBytes.Length) myCommand.Parameters.AddWithValue("@ImageData", imageBytes) thanks

[Michael Bookatz]

I used to think that way however .. have a look at the following thread ... http://www.codeproject.com/Lounge.aspx?msg=2769169#xx2769169xx[^]

[sumit7034]

Have u Tried this... FileUpload1.FileBytes;