Resize images from a database with Handler : The Official Microsoft ASP.NET Forums

Reply

ReSonance

Member

10 Points

Resize images from a database with Handler

Dec 21, 2012 10:33 AM|LINK

Hello everyone, I am printing images from a database using DetailsVaiew and Handler, it works, but now I do not know how you can increase to view messages? read that using bitmap, but do not know how to apply it to your situation. Help please

My Detailsview:

<asp:DetailsView ID="DetailsView3" runat="server" AutoGenerateRows="False"
                    BorderWidth="0px" BorderColor="White"
                    DataSourceID="SqlDataSource3" DataKeyNames="idNews"
                    style="margin-top: 0px" GridLines="None" Height="203px" Width="109px">
                <Fields>
                        <asp:TemplateField>
                            <ItemTemplate>

                       
                             <img width=175 height=200 src="Handler2.ashx?idNews=<%# Eval("idNews") %>"/>
                                
                            </ItemTemplate>
                        </asp:TemplateField>
                    </Fields>
                </asp:DetailsView>

My handler:

namespace MySite
{
    public class Handler2 : IHttpHandler
    {
        public void ProcessRequest(HttpContext context)
        {
            string idNews = context.Request.QueryString["idNews"];
            SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["WEBNIPIConnectionString"].ConnectionString);
            connection.Open();
            SqlCommand command = new SqlCommand("select Image from TestNews where Image is NOT NULL and idNews=" + idNews, connection);
            SqlDataReader dr = command.ExecuteReader();
            if (dr.Read())
                context.Response.BinaryWrite((Byte[])dr[0]);
            connection.Close();
            context.Response.End();

        }

        public bool IsReusable
        {
            get
            {
                return false;
            }
        }
    }
}