how to show new image in news panel of webpage

Question

4.00/5 (1 vote)

See more:

Hi, I'm a new user of asp.net and i write code to show news is like this
default.aspx

XML

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"
                    BorderWidth="0" BorderColor="White" ShowHeader="False">
                    <Columns>
                        <asp:TemplateField>
                            <ItemTemplate>
                                 <asp:HyperLink runat="server" ID="hl" NavigateUrl='<%#"NewsDetails.aspx?Newsid="+ Eval("news_id") %>' Text='<%# Eval("news_title") %>'></asp:HyperLink>

                            </ItemTemplate>
                        </asp:TemplateField>
                    </Columns>
                </asp:GridView>

default.aspx.cs

C#

protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            getNewsDetails();
        }
    }
    protected void getNewsDetails()
    {
        try
        {
            SqlCommand cmd1 = new SqlCommand("select top 5 news_id,news_title,news_image from tbl_news where news_status=1 order by news_id desc", conn);
            conn.Open();
            SqlDataReader rdr = cmd1.ExecuteReader();

            GridView1.DataSource = rdr;
            GridView1.DataBind();

            rdr.Close();
        }
        catch (Exception ee)
        {
            Response.Write(ee.Message);
        }
        finally
        {
            conn.Close();
        }
    }

its shows properly but i need to show a new image which i store in database and myfield name is news_image. please tell me how to show image of new .png within news, or tell me different method to show newsbulletin in asp.net.

Thanks
Regards
Umesh Daiya

Posted 29-Sep-12 18:46pm

UDTWS

Updated 29-Sep-12 18:56pm

Kenneth Haugland

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandip.Nascar · Accepted Answer · 2012-09-29T19:43:00

Solution 1

You need to create a handler to show the image from database.
Here is a ode snippet,

In aspx page

<itemtemplate>
<img id="imgTest" src="showimage.ashx?newsid=<%# Eval(" news_id=") %>">
             width="100px" height="100px" title="<%# Eval("news_title") %>" />
</img></itemtemplate>

Creating the Handler (showimage.ashx)

public void ProcessRequest(HttpContext context)
{
    //establish the data connection
    using (SqlConnection connection = new                 SqlConnection(ConfigurationManager.ConnectionStrings["CONN_STRING"].ConnectionString))
    {
        //get the image through newsid passed as querystring
        SqlCommand command = new SqlCommand("Select news_image from tbl_news where newis_id = '" + context.Request.QueryString["newsid"] + "'", connection);
 
        connection.Open();
        SqlDataReader dr = command.ExecuteReader(CommandBehavior.CloseConnection);
        while (dr.Read())
        {
            if (dr["news_image"].ToString().Length > 0)
            {
                context.Response.BinaryWrite((byte[])dr["newsimage"]);
            }
        }
    }
}

This will show the image in gridvuew.

Hope this helps.
cheers

Posted 29-Sep-12 19:43pm

Sandip.Nascar

Updated 29-Sep-12 19:44pm

v2

Comments

UDTWS 30-Sep-12 5:23am

Thanks For Reply: but plz check this
showimage.ashx

<%@ WebHandler Language="C#" Class="showimage" %>

using System;
using System.Web;
using System.Data.SqlClient;

public class showimage : IHttpHandler {

public void ProcessRequest(HttpContext context)
{
//establish the data connection
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["CONN_STRING"].ConnectionString))
{
//get the image through newsid passed as querystring
SqlCommand command = new SqlCommand("Select news_image from tbl_news where news_id = '" + context.Request.QueryString["newsid"] + "'", connection);

connection.Open();
SqlDataReader dr = command.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
if (dr["news_image"].ToString().Length > 0)
{
context.Response.BinaryWrite((byte[])dr["news_image"]);
}
}
}
}
}
default.aspx
<pre lang="xml"><asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"
BorderWidth="0" BorderColor="White" ShowHeader="False" Width="100%">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:HyperLink runat="server" ID="hl" NavigateUrl='<%#"NewsDetails.aspx?Newsid="+ Eval("news_id") %>' Text='<%# Eval("news_title") %>'></asp:HyperLink>
<img id="imgTest" src="showimage.ashx?newsid=<%# Eval("news_id=") %>" width="100px" height="100px" title="<%# Eval("news_title") %>" />
</img>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView></pre>

i do this as you suggested is it right. but i have got a error message "Error 26 showimage does not implement interface member System.Web.IHttpHandler.IsReusable.
"
now what i should do to correct this i use first time this handler i did not know about it more.

Sandip.Nascar 30-Sep-12 5:39am

Add this code,

public class showimage : IHttpHandler {
{
public bool IsReusable
{
get { return false; }
}
//add your code
}

This will work. For more details, google httphandler in asp.net.
cheers