I am saving image file into the database as binarydata and retrieving the image file from the database. I am using response.write() to display the image file.
The problem is response.write() clearing all the label,button,textbox fields in my page.But i need button in my page to increase the count.
CODE:
protected void btnsave2_Click(object sender, EventArgs e)
{
imag++;
byte[] imagebyte = new byte[FileUpload1.PostedFile.InputStream.Length + 1];
FileUpload1.PostedFile.InputStream.Read(imagebyte, 0, imagebyte.Length);
cmd = new MySqlCommand("Insert Into db_image (Image,ImageId) values (@imag,@imageid)", con);
cmd.Parameters.AddWithValue("imag", imagebyte);
cmd.Parameters.AddWithValue("imageid", imag.ToString());
cmd.ExecuteNonQuery();
}
protected void btnretr2_Click(object sender, EventArgs e)
{
cmd = new MySqlCommand("Select Image from db_image where ImageId='" +txt_imageid.Text.Trim()+ "' ", con);
dr = cmd.ExecuteReader();
while (dr.Read())
{
Response.BinaryWrite((byte[])dr["Image"]);
}
}
Help me.