gridview image column problem

Posted by jame on Stack Overflow See other posts from Stack Overflow or by jame
Published on 2009-09-22T04:49:21Z Indexed on 2010/04/03 6:03 UTC
Read the original article Hit count: 249

Filed under:
|

Work on vs05 C# asp.net .My SQL Syntax is :****

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Images]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Images]
GO

CREATE TABLE [dbo].[Images] (
    [ID] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
    [ImageName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [Image] [image] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

I want to show this Images table values in a grid view.....I do it ...but the image value can not show ....asp.net syntax for gridview is

<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False">
            <Columns>
                <asp:BoundField DataField="ImageName" HeaderText="ImageName" />
                <asp:TemplateField HeaderText="Image">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" Text='<%# Eval("Image") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Image ID="Image1" runat="server" ImageUrl='<%# Eval("Image") %>' />
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
        </asp:GridView>

i write the below code on pageload event. i want images table values must shown when the page is load...

string strSQL = "Select  *  From Images";
    DataTable dt = clsDB.getDataTable(strSQL);
    this.GridView2.DataSource = dt;
    this.GridView2.DataBind();

Why not i get the image on my image column of the gridview.....what's the problem is how to solve?

© Stack Overflow or respective owner

Related posts about ASP.NET

Related posts about c#