返回首页

我尝试使用ObjectDataSource的GridView的从SQL数据库中获取的图像。在数据库中,一个的DataField被宣布为"varbinary的"数据类型。

现在我的GridView,它不显示我的形象,而不是我的文字"System.Byte []"

我想知道如何解决它。

回答

评论会员:游客 时间:2012/02/06
|Tejas_Vaishnav:你有转换的字节[]数组的图像数据的图像,然后显示网格视图在GridView的行的数据绑定事件,你写你的代码
supriya chaladi:首先转换成图像格式的数据,然后将其绑定到GridView的
可以发布你的代码
评论会员:saeed1364 时间:2012/02/06
loginadmin insertbookadmin =新loginadmin()
??

如果(FileUpload1.HasFile)
 0;{
(BinaryReader读卡器=新BinaryReader(FileUpload1.PostedFile.InputStream)的)
& #160; {

为byte [] imageData里= reader.ReadBytes(FileUpload1.PostedFile.ContentLength)
  ; imageData里=新的字节[FileUpload1.PostedFile.ContentLength]
HttpPostedFile uploadedImage = FileUpload1.PostedFile
 0; uploadedImage.InputStream.Read
 60; (imageData里,0,(INT)FileUpload1.PostedFile.ContentLength的);
/ /保存到数据库的二进制
如果(insertbookadmin.insertbook(imageData里)
{
}
}
评论会员:Thiyagarajan.rk 时间:2012/02/06
您使用此代码,我使用它的工作......在数据库中存储的图像后,您使用此...

aspx页面...

<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>
后面的代码...

{C}