inserting image file into mysql but it insert null values...how to convert image to binary as well as binary to image

Hi
In mysql table create a column with datatype Blob. Then in the form submiting event..

protected void Button1_Click(object sender, EventArgs e)
 {
     HttpPostedFile postedFile=FileUpload1.PostedFile;
     Stream stream = postedFile.InputStream;
     BinaryReader bReader=new BinaryReader(stream);
     byte[] bytes=bReader.ReadBytes((int)stream.Length);

     //STORE THIS STRING IN THE BLOB COLUMN IN MYSQL
     string blob=Convert.ToBase64String(bytes);


     // For testing--- to show the image back to browser
     byte[] bytes1 = Convert.FromBase64String(blob);
     Response.ContentType = postedFile.ContentType;
     Response.OutputStream.Write(bytes1, 0, bytes1.Count());



 }

convert your posted file to a blob string as shown above and store in the database (you may need to store the content type as well in another column). Retrive from the database , convert the string to byte array. This byte array you may direct to output stream or handle in some way to display in a control. Hope this helps