using (SqlConnection myConnection = new SqlConnection("connection-string"))
{
SqlCommand cmd = new SqlCommand("usp_GetPersonImage", myConnection);
cmd.CommandType = CommandType.StoredProcedure;
myConnection.Open();
cmd.Parameters.Add("@Param1", SqlDbType.Int).Value = context.Request.QueryString["PID"];
cmd.Prepare();
try
{
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
byte[] bytes = null;
bytes = (byte[])reader[0];
context.Response.Clear();
context.Response.ClearHeaders();
context.Response.ContentType = "text/plain";
string base64String = Convert.ToBase64String(bytes,Base64FormattingOptions.None);
context.Response.Write(base64String);
}
}
catch (System.Data.SqlTypes.SqlNullValueException ex)
{
string s = ex.Message;
throw;
}
}
// Client
var ddlID = '<%= DropDownList1.ClientID %>';
var lblID = '<%= label1.ClientID %>';
function getImage() {
$('#MainContent_label1').html("");
var ddl = document.getElementById(ddlID);
var selectedID = ddl.value;
var lbl = $(this).find(lblID);
$.get(
'GetImage.ashx?PID=' + selectedID,
null,
function (data) {
$('#MainContent_label1').html("data:image/jpg;base64," + data);
$('#imgDiv').html(
'');
}
);
};
