I want to display in an asp:GridView an "Images" column. The idea is to provide a thumbnails of the image with link to real size image. For some rows, this may alternatively be a PDF document. I'd like the link to be to the PDF. The PDF or image are stored in a SQL database.
Now I have error in Handler (.ashx) file:
"Invalid attempt to read when no data is present."
This is my code :
ASP:
<asp:GridView ID="GridView1" runat="server"
AutoGenerateColumns="False" DataKeyNames="ID"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="assessment_id" HeaderText="assessment_id"
InsertVisible="False" ReadOnly="True"
SortExpression="assessment_id" />
<asp:BoundField DataField="a_mime" HeaderText="a_mime" SortExpression="a_mime" />
<asp:TemplateField HeaderText="a_data">
<ItemTemplate>
<asp:Image ID="Image1" runat="server" ImageUrl='<%# "Handler.ashx?ID=" + Eval("ID")%>'/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:testConnectionString %>"
SelectCommand="SELECT [assessment_id], [a_data], [a_mime] FROM [Assessments]">
</asp:SqlDataSource>
The Handler ASHX:
<%@ WebHandler Language="C#" Class="Handler" %>
public class Handler : IHttpHandler {
public void ProcessRequest (HttpContext context)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["testConnectionString"].ConnectionString;
// Create SQL Command
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select a_data from Assessments where assessment_id =@ID";
cmd.CommandType = System.Data.CommandType.Text;
cmd.Connection = con;
SqlParameter ImageID = new SqlParameter("@ID", System.Data.SqlDbType.Int);
ImageID.Value = Convert.ToInt32(context.Request.QueryString["assessment_id"]);
cmd.Parameters.Add(ImageID);
con.Open();
SqlDataReader dReader = cmd.ExecuteReader();
dReader.Read();
context.Response.BinaryWrite((byte[])dReader["a_data"]);
dReader.Close();
con.Close();
}
If it is possible, please help me. If it's time-consuming, please provide a link to an example or blog post.