Question

<form id="form1" runat="server">
<div>

    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataKeyNames="bookname"  Height="504px" 
        Width="289px">
        <Columns>
            <asp:TemplateField HeaderText="image">
                <ItemTemplate>
                    <asp:Image ID="Image1" runat="server" 
                        ImageUrl= <%# String.Format("~/path/to/image/" + Eval("image")) %>  />
                </ItemTemplate>
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox1" runat="server" Text= <%# Eval("image") %> ></asp:TextBox>
                </EditItemTemplate>
            </asp:TemplateField>
            <asp:BoundField DataField="bookname" HeaderText="bookname" ReadOnly="True" 
                SortExpression="bookname" />
            <asp:BoundField DataField="price" HeaderText="price" SortExpression="price" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        SelectCommand="SELECT [image], [bookname], [price] FROM [books]">
    </asp:SqlDataSource>

My Image field is saved in (SQL server 2005)...and image inserted in database through file upload button ... and now i want to show data in gridview but not display image field and other field shown in gridview very well becauese other fields are text format.

Answer 1

<asp:Image ID="Image1" runat="server" ImageUrl= <%# String.Format("~/path/to/image/{0}" , Eval("image")) %>  />

您的问题在于 < code> stringing. Format 接受参数, 您正在使用一个 concat 操作。这里我使用了 < code_ 0} - 表示在/ index 0 处的参数。对于多个参数, 您也可以使用 < code> string. Format ("{0} {1} {2} {2}, var1, var2, var3] 。。

上面我还假设 {0} 将被扩展名的文件名替换, 如 abc. png 。

<form id="form1" runat="server">
    <div>
       <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            DataKeyNames="bookname"  Height="504px" 
            Width="289px">
            <Columns>
                <asp:TemplateField HeaderText="image">
                    <ItemTemplate>
                        <asp:Image ID="Image1" runat="server" 
                            ImageUrl= <%# String.Format("~/path/to/image/{0}" , Eval("image")) %>  />
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" Text= <%# Eval("image") %> ></asp:TextBox>
                    </EditItemTemplate>
                </asp:TemplateField>
                <asp:BoundField DataField="bookname" HeaderText="bookname" ReadOnly="True" 
                    SortExpression="bookname" />
                <asp:BoundField DataField="price" HeaderText="price" SortExpression="price" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            SelectCommand="SELECT [image], [bookname], [price] FROM [books]">
        </asp:SqlDataSource>

Answer 2

我会期待某样东西,比如

ImageUrl= <%# this.ResolveUrl("~/path/to/image/" + Eval("image")) %>  />

而不是string. format

Answer 3

您的图像存储在数据库中, 您需要使用处理器来检索图像。您可以在这里获得一个参考文件 < a href=" http://www.codeproject. com/ artes/ 271590/ show- an- image- saveed- in- a- SQL- Table- on- an- ASP- Net- I" rel= “ nofollow > http://www.codeproject. com/ arts/ 271590/ show- an- image- saved- int- a- SQL- Table- on- an- ASP- Net- I < /a >

友情链接