using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Data;
using System.Data.SqlClient;
using System.Web.UI.WebControls;
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["imagId"]);
if (id > 0)
{
SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=F:\Examples\ImageExamples\Images1\ImageStoringAndRetrivingUsingImageConrtol\App_Data\Database1.mdf;Integrated Security=True;User Instance=True");
SqlCommand cmd = new SqlCommand("SELECT * FROM Images WHERE ImgId=@ImgId", conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@ImgId", id);
using (conn)
{
conn.Open();
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.Read())
{
Byte[] imgData = (byte[])rdr["ImgBin"];
Response.ContentType = (rdr["ImgType"].ToString());
Response.OutputStream.Write(imgData, 0, imgData.Length);
}
}
}
}
}
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.