Click here to Skip to main content
14,639,066 members
Rate this:
Please Sign up or sign in to vote.
See more:
i am using this code for image upload but image is not storing in database and also not showing the picture but when i press the button its shows file uploaded...
please help me...

   string strImageName = TextBox3.Text.ToString(); 
 if (FileUpload1.PostedFile != null && 

     FileUpload1.PostedFile.FileName != "")


   byte[] imageSize = new byte


  HttpPostedFile uploadedImage = FileUpload1.PostedFile;


     (imageSize, 0, (int)FileUpload1.PostedFile.ContentLength);

 // Create SQL Connection 

  con = new SqlConnection(connstring);



 // Create SQL Command 


 SqlCommand cmd = new SqlCommand();

 cmd.CommandText = "INSERT INTO Images(ImageName,Image)" +

                   " VALUES (@ImageName,@Image)";

 cmd.CommandType = CommandType.Text;

 cmd.Connection = con;

 SqlParameter ImageName = new SqlParameter

                     ("@ImageName", SqlDbType.VarChar, 50);

 ImageName.Value = strImageName.ToString();



 SqlParameter UploadedImage = new SqlParameter

               ("@Image", SqlDbType.Image, imageSize.Length);

 UploadedImage.Value = imageSize;



 int result = cmd.ExecuteNonQuery();


 if (result > 0)

 Label1.Text = "File Uploaded";


Updated 23-May-13 0:02am
Debug line by line ans see if you are getting all values correctly.
Rate this:
Please Sign up or sign in to vote.

Solution 1

after browsing the file from file upload

if you want to take the file in to byte.
just write

byte[] fileBytes=FileUpload1.filebytes;

then pass the fileBytes variable to your cmd parameter which is of byte TYPE.
Hope this helps..!
Rate this:
Please Sign up or sign in to vote.

Solution 2

its may help ful to u,see this link.

How to store & retrieve images in mysql database using c#[^]

thank u.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100