Asp.net grid view with image

Question

5.00/5 (1 vote)

See more:

Hi

I am designing a page which shows images on it by using grid view.
can you please help me.

my data base field are as follows:

Prod_code  (Primary key,varchar(50))
Prod_category_id(varchar(50))
Prod_name        (varchar(50))
Prod_desc(text)
Prod_image(image)
Price(money)
Status(char(2))

I am using asp.net with c# and sql server as database

can some help me with this problem .

I am able to add the products in my table but not able to retrieve it in grid view.

Posted 6-Jun-11 2:47am

preetpal kapoor

Updated 6-Jun-11 3:15am

RaviRanjanKr

v2

Add a Solution

Comments

senguptaamlan 6-Jun-11 8:50am

please share your code....

Ra-one 6-Jun-11 9:13am

Show the code where you are not able to retrieve the data from db

5 solutions

Solution 1

http://msdn.microsoft.com/en-us/library/aa479350.aspx[^]

Displaying Images from a Database in a GridView[^]
Follow these link .

Second one will give solution of your problem.

Posted 6-Jun-11 3:14am

Mohd Wasif

Updated 6-Jun-11 3:15am

v2

Solution 4

This is the aspx.cs page code

protected void btnadd_Click(object sender, EventArgs e)
    {
        string qu;
        if (fileupload.PostedFile != null &&
            fileupload.PostedFile.FileName != "")
        {
            byte[] imageSize = new byte
                          [fileupload.PostedFile.ContentLength];
            HttpPostedFile uploadedImage = fileupload.PostedFile;
            uploadedImage.InputStream.Read
               (imageSize, 0, (int)fileupload.PostedFile.ContentLength);
            conn.connect();
            qu = "insert into Prod_detail1 values ('" + txtprodid.Text + "','" + txtprodcatid.Text + "','" + txtprodname.Text + "','" + txtproddesc.Text + "',@Image,'" + txtprice.Text + "','" + txtstatus.Text + "')";
            conn.cmd = new System.Data.SqlClient.SqlCommand(qu, conn.con);
            SqlParameter UploadedImage = new SqlParameter("@Image", SqlDbType.Image, imageSize.Length);
                            UploadedImage.Value = imageSize;
                            conn.cmd.Parameters.Add(UploadedImage);
            
            conn.cmd.ExecuteNonQuery();
            fill();
        }
    }
    public void fill()
    {
        conn.con = new SqlConnection(conn.str1);
        conn.ad = new System.Data.SqlClient.SqlDataAdapter("select Prod_code,Prod_cate_id,Prod_name,Prod_desc,Prod_image,Price from Prod_detail1 where Prod_code='" + Request.QueryString["Prod_code"]+"'", conn.con);
        conn.ds = new DataSet();
        conn.ad.Fill(conn.ds);
        GridView1.DataSource = conn.dr;
        GridView1.DataBind();
        conn.con.Close();
        DisplayImage();
    }
    private void DisplayImage()
    {
        if (Request.QueryString["Prod_code"] != null)
        {
           
            conn.con.Open();
            conn.ad = new SqlDataAdapter("select Prod_image from Prod_detail1 where id='" + Request.QueryString["Prod_code"] + "'", conn.con);
            DataTable dt = new DataTable();
            conn.ad.Fill(dt);
            conn.con.Close();
            Byte[] bytes = (Byte[])dt.Rows[0]["Prod_image"];
            Response.BinaryWrite(bytes);
        }
    }

this is the aspx page code

XML

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="add_prod.aspx.cs" Inherits="add_prod" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        .style1
        {
            width: 100%;
            height: 50%;
            border: 2px solid #808000;
            background-color: #c0c0c0;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>

        <table cellpadding="2" class="style1">
            <tr>
                <td>
                    Product id:</td>
                <td>
                    <asp:TextBox ID="txtprodid" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    Product category id:</td>
                <td>
                    <asp:TextBox ID="txtprodcatid" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    Product Name:</td>
                <td>
                    <asp:TextBox ID="txtprodname" runat="server" ></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    Product description:</td>
                <td>
                    <asp:TextBox ID="txtproddesc" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    Product image:</td>
                <td>
                    <asp:FileUpload ID="fileupload" runat="server" />&nbsp;</td>
            </tr>
            <tr>
                <td>
                    Price:</td>
                <td>
                    <asp:TextBox ID="txtprice" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    Status:</td>
                <td>
                    <asp:TextBox ID="txtstatus" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
                <td>
                    <asp:Button ID="btnadd" runat="server" onclick="btnadd_Click"
                        Text="add product" />
                </td>
            </tr>
            <tr>
                <td>
                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
                        DataKeyNames="Prod_code" DataSourceID="SqlDataSource1">
                        <Columns>
                            <asp:BoundField DataField="Prod_code" HeaderText="Prod_code" ReadOnly="True"
                                SortExpression="Prod_code" />
                            <asp:BoundField DataField="Prod_cate_id" HeaderText="Prod_cate_id"
                                SortExpression="Prod_cate_id" />
                            <asp:BoundField DataField="Prod_name" HeaderText="Prod_name"
                                SortExpression="Prod_name" />
                            <asp:BoundField DataField="Prod_desc" HeaderText="Prod_desc"
                                SortExpression="Prod_desc" />
                               <asp:TemplateField HeaderText="Image">
                               <ItemTemplate>
                               <asp:Image ID="Image1" runat="server"
                                   ImageUrl='<%# Eval("Prod_code", "add_prod.aspx?Prod_code={0}")%>'/>

                               </ItemTemplate>
                               </asp:TemplateField>


                            <asp:BoundField DataField="Price" HeaderText="Price" SortExpression="Price" />
                            <asp:BoundField DataField="Status" HeaderText="Status"
                                SortExpression="Status" />
                        </Columns>
                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
                        ConnectionString="<%$ ConnectionStrings:centurydbConnectionString %>"
                        SelectCommand="SELECT * FROM [Prod_detail1]"></asp:SqlDataSource>
                </td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
        </table>

    </div>
    </form>
</body>
</html>

Now can you advise me something ravi

Posted 6-Jun-11 3:26am

preetpal kapoor

Updated 6-Jun-11 10:52am

v2

Solution 3

Read this article of msdn
http://msdn.microsoft.com/en-us/library/aa479350.aspx[^]

It may help you..............

Posted 6-Jun-11 3:23am

prem shanker verma

Solution 5

hi ravi ,
The link which you provided to me is giving some error/exception
at :

SqlDataReader dr1 = c1.cmd.ExecuteReader();

the full code is as follows:

<%@ WebHandler Language="C#" Class="Handler" %>
using System;
using System.Web;
using System.Configuration;
using System.Data.SqlClient;
public class Handler : IHttpHandler {
    connection_class c1 = new connection_class();
    public void ProcessRequest (HttpContext context)
    {
        c1.con = new SqlConnection(c1.str1);
        c1.cmd = new SqlCommand();
        c1.cmd.CommandText="select Prod_cate_id,Prod_name,Prod_desc,Prod_image,Price,Status where=Prod_code=@Prod_code";
        c1.cmd.CommandType = System.Data.CommandType.Text;
        c1.cmd.Connection = c1.con;
        SqlParameter imageid = new SqlParameter("@Prod_code",System.Data.SqlDbType.VarChar);
        imageid.Value = context.Request.QueryString["Prod_code"];
        c1.cmd.Parameters.Add(imageid);
        c1.con.Open();
        SqlDataReader dr1 = c1.cmd.ExecuteReader();
        //c1.dr = c1.cmd.ExecuteReader();
        c1.dr.Read();
        context.Response.BinaryWrite((byte[])c1.dr["Prod_image"]);
        c1.dr.Close();
        c1.con.Close();
        //context.Response.ContentType = "text/plain";
        //context.Response.Write("Hello World");
    }
 
    public bool IsReusable {
        get {
            return false;
        }
    }
}

Posted 6-Jun-11 7:48am

preetpal kapoor

Updated 6-Jun-11 10:49am

v2

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)

RaviRanjanKr · Accepted Answer · 2011-06-06T03:20:00

Solution 2

Try
Display Images In GridView From DataBase

Posted 6-Jun-11 3:20am

RaviRanjanKr

Updated 6-Jun-11 3:22am

v2