如何从Microsoft Access数据库检索图像并将其显示在图像控件中? [英] How do I retrieve an image from a Microsoft Access database and display it in an image control?

问题描述

其他编码员.
我有点问题，我需要从Microsoft Access数据库中检索图像(专辑封面图片)并将其显示在图像控件中.我可以使用以下代码从数据库(放置在网格视图控件中)检索文本字段:

lblRow1AlbumPrice1.Text = GridView1.Rows [0] .Cells [8] .Text;

但专辑封面位于附件数据类型下，因此我不知道代码的方式或内容.

这是gridview控件中的数据库:

< asp:GridView ID ="GridView1" runat =服务器" AutoGenerateColumns ="False" DataKeyNames ="ID" DataSourceID ="SqlDataSource1">
<列> < asp:BoundField DataField ="ID" HeaderText ="ID" InsertVisible ="False" ReadOnly ="True" SortExpression ="ID"/>
< asp:BoundField DataField ="AlbumName" HeaderText ="AlbumName" SortExpression ="AlbumName"/>
< asp:BoundField DataField ="Artist" HeaderText ="Artist" SortExpression ="Artist"/>
< asp:BoundField DataField ="ContributingArtists" HeaderText ="ContributingArtists" SortExpression ="ContributingArtists"/>
< asp:BoundField DataField ="Genre" HeaderText ="Genre" SortExpression ="Genre"/>
< asp:BoundField DataField ="Year" HeaderText ="Year" SortExpression ="Year"/>
< asp:BoundField DataField ="AmountOfStock" HeaderText ="AmountOfStock" SortExpression ="AmountOfStock"/>
< asp:BoundField DataField ="ShippingWeight" HeaderText ="ShippingWeight" SortExpression ="ShippingWeight"/>
< asp:BoundField DataField ="Price" HeaderText ="Price" SortExpression ="Price"/>
< asp:BoundField DataField ="AlbumArt" HeaderText ="AlbumArt" SortExpression ="AlbumArt"/>

< asp:SqlDataSource ID ="SqlDataSource1" runat =服务器" ConnectionString =<％$ ConnectionStrings:ConnectionString6％>" ProviderName =<％$ ConnectionStrings:ConnectionString6.ProviderName％>" SelectCommand ="SELECT [ID]，[唱片集名称]，[艺术家]，[贡献艺术家]，[流派]，[年份]，[数量]，[运输重量]，[价格]，[唱片艺术]来自[音乐(CD)] >

Hi there fellow coders.
I kind of have a problem, I need to retrieve an image (an album art picture) from a Microsoft access database and display it in an image control. I can retrieve text fields from a database (Placed in a grid view control) with the following code:

lblRow1AlbumPrice1.Text = GridView1.Rows[0].Cells[8].Text;

but the Album Art is under an attachment data type, so I don’t know how or what the code will be.

this is the database within a gridview control:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="SqlDataSource1">
<columns> <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True" SortExpression="ID" />
<asp:BoundField DataField="AlbumName" HeaderText="AlbumName" SortExpression="AlbumName" />
<asp:BoundField DataField="Artist" HeaderText="Artist" SortExpression="Artist" />
<asp:BoundField DataField="ContributingArtists" HeaderText="ContributingArtists" SortExpression="ContributingArtists" />
<asp:BoundField DataField="Genre" HeaderText="Genre" SortExpression="Genre" />
<asp:BoundField DataField="Year" HeaderText="Year" SortExpression="Year" />
<asp:BoundField DataField="AmountOfStock" HeaderText="AmountOfStock" SortExpression="AmountOfStock" />
<asp:BoundField DataField="ShippingWeight" HeaderText="ShippingWeight" SortExpression="ShippingWeight" />
<asp:BoundField DataField="Price" HeaderText="Price" SortExpression="Price" />
<asp:BoundField DataField="AlbumArt" HeaderText="AlbumArt" SortExpression="AlbumArt" />

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString6 %>" ProviderName="<%$ ConnectionStrings:ConnectionString6.ProviderName %>" SelectCommand="SELECT [ID], [AlbumName], [Artist], [ContributingArtists], [Genre], [Year], [AmountOfStock], [ShippingWeight], [Price], [AlbumArt] FROM [Music (CD)]">

推荐答案

ConnectionStrings:ConnectionString6％>" ProviderName =<％

ConnectionStrings:ConnectionString6 %>" ProviderName="<%

ConnectionStrings:ConnectionString6.ProviderName％ >"SelectCommand =" SELECT [ID]，[AlbumName]，[Artist]，[ContributingArtists]，[Genre]，[Year]，[AmountOfStock]，[ShippingWeight]，[Price]，[AlbumArt] FROM [Music( CD)]>

ConnectionStrings:ConnectionString6.ProviderName %>" SelectCommand="SELECT [ID], [AlbumName], [Artist], [ContributingArtists], [Genre], [Year], [AmountOfStock], [ShippingWeight], [Price], [AlbumArt] FROM [Music (CD)]">

通过这些链接，您可能会有所了解..


C#从数据库保存和加载图像 [ ^ ]


http://www.ezineasp.net/post/ASP-Net-Stream-and-Display-Image-from-MS-Access-Database.aspx [

go through these links you may get some idea..


C# Save and Load Image from Database[^]


http://www.ezineasp.net/post/ASP-Net-Stream-and-Display-Image-from-MS-Access-Database.aspx[^]

这篇关于如何从Microsoft Access数据库检索图像并将其显示在图像控件中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！