我尝试使用ObjectDataSource的GridView的从SQL数据库中获取的图像。在数据库中,一个的DataField被宣布为"varbinary的"数据类型。
现在我的GridView,它不显示我的形象,而不是我的文字"System.Byte []"
我想知道如何解决它。
<p style="margin-left: 160px">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="inum" DataSourceID="SqlDataSource1" CellPadding="4"
ForeColor="#333333" GridLines="None">
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<Columns>
<asp:BoundField DataField="inum" HeaderText="inum" InsertVisible="False" ReadOnly="True"
SortExpression="inum" />
<asp:BoundField DataField="iname" HeaderText="iname" SortExpression="iname" />
<asp:TemplateField HeaderText="image">
<ItemTemplate>
<asp:image ID="image1" runat="server"
ImageUrl='<%# "Handler.ashx?inum=" + Eval("inum")%>'/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#999999" />
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:SomeDataBase1 %>"
SelectCommand="SELECT inum, iname, image FROM ft"
ConflictDetection="CompareAllValues"
DeleteCommand="DELETE FROM [ft] WHERE [inum] = @original_inum AND (([iname] = @original_iname) OR ([iname] IS NULL AND @original_iname IS NULL)) AND (([image] = @original_image) OR ([image] IS NULL AND @original_image IS NULL))"
InsertCommand="INSERT INTO [ft] ([inum], [iname], [image]) VALUES (@inum, @iname, @image)"
OldValuesParameterFormatString="original_{0}"
UpdateCommand="UPDATE [ft] SET [iname] = @iname, [image] = @image WHERE [inum] = @original_inum AND (([iname] = @original_iname) OR ([iname] IS NULL AND @original_iname IS NULL)) AND (([image] = @original_image) OR ([image] IS NULL AND @original_image IS NULL))">
<DeleteParameters>
<asp:Parameter Name="original_inum" Type="String" />
<asp:Parameter Name="original_iname" Type="String" />
<asp:Parameter Name="original_image" Type="Object" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="iname" Type="String" />
<asp:Parameter Name="image" Type="Object" />
<asp:Parameter Name="original_inum" Type="String" />
<asp:Parameter Name="original_iname" Type="String" />
<asp:Parameter Name="original_image" Type="Object" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="inum" Type="String" />
<asp:Parameter Name="iname" Type="String" />
<asp:Parameter Name="image" Type="Object" />
</InsertParameters>
</asp:SqlDataSource>
后面的代码...