In Database i Created Table ImageTable with Two Column
ID and Image
ID = type of int
and
Image is type of varbinary(MAX)
protected void btnInsertData_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile == true)
{
int id = int.Parse(txtID.Text);
/* read Image Data into byete array */
byte[] ImageData = FileUpload1.FileBytes;
/* Connect to database and Write Data into Database */
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand comm = new SqlCommand("insert into ImageTable(ID,Image) values(@ID,@Image)", con);
comm.Parameters.AddWithValue("@ID", ID);
comm.Parameters.AddWithValue("@Image", ImageData);
comm.ExecuteNonQuery();
con.Close();
}
}
protected void btnReadImageData_Click(object sender, EventArgs e)
{
int ID = int.Parse(txtID.Text);
/* Connect to database and Write Data into Database */
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand comm = new SqlCommand("select Image from ImageTable where id=1", con);
comm.Parameters.AddWithValue("@ID", ID);
object ImageBinary = comm.ExecuteScalar();
Response.BinaryWrite((byte[])ImageBinary);
con.Close();
}