Click here to Skip to main content
14,601,062 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

                 [FileUpload1.PostedFile.ContentLength];

  HttpPostedFile uploadedImage = FileUpload1.PostedFile;

  uploadedImage.InputStream.Read

     (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();

 cmd.Parameters.Add(ImageName);

 

 SqlParameter UploadedImage = new SqlParameter

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

 UploadedImage.Value = imageSize;

 cmd.Parameters.Add(UploadedImage);

 con.Open();

 int result = cmd.ExecuteNonQuery();

 con.Close();

 if (result > 0)

 Label1.Text = "File Uploaded";

 Image1.DataBind();

 }
}
Posted
Updated 23-May-13 0:02am
v2
Comments
   
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

Hi...
its may help ful to u,see this link.

How to store & retrieve images in mysql database using asp.net 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