how to retrive binary data in mssql on listview eval

I want to bind a image (which is stored in binary format column name image(varbinary)) in list view in c#.. i am trying this two but not working..

--%>                 <%--<asp:Image ID="Image10" runat="server" Height="100px" ImageUrl='<%# "ShowImage.ashx?id=" + Eval("image") %>' GenerateEmptyAlternateText="True" Visible='<%# ShowImg(Eval("image")) %>' />--%>

here is the code:

"SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:VeteransDirectoryConnectionString %>" SelectCommand=
"SELECT [EventID], [OrganizationName], [Title], [DescriptionShort], [DescriptionLong], [Location], [EventDate], [URL], (CASE WHEN URL IS NULL OR URL = '' THEN CAST(0 AS bit) ELSE CAST(1 AS bit) END) AS URLLink, [FileName], (CASE WHEN FileName IS NULL OR FileName = '' THEN CAST(0 AS bit) ELSE CAST(1 AS bit) END) AS FileLink, [EventTime],image FROM [t_Event] WHERE ([EventID] = @EventID)">
"EventID" QueryStringField="eventid" Type="Int32" />
"padding: 0px 10px 20px 10px;">
"ListView1" runat="server" DataKeyNames="EventID" DataSourceID="SqlDataSource1">
No data for this event was found.
class="listCalLabel">Organization:
"OrganizationNameLabel" runat="server" Text='<%# Eval("OrganizationName") %>' CssClass="listCalText" />
class="listCalLabel">Event:
"TitleLabel" runat="server" Text='<%# Eval("Title") %>' CssClass="listCalText" />
class="listCalLabel">Short Description:
"DescriptionShortLabel" runat="server" Text='<%# Eval("DescriptionShort") %>' CssClass="listCalText" />
class="listCalLabel">Long Description:
"DescriptionLongLabel" runat="server" Text='<%# Eval("DescriptionLong") %>' CssClass="listCalText" />
class="listCalLabel">Location:
"LocationLabel" runat="server" Text='<%# Eval("Location") %>' CssClass="listCalText" />
class="listCalLabel">Event Date:
"EventDateLabel" runat="server" Text='<%# Eval("EventDate", "{0:MM/dd/yyyy}") %>' CssClass="listCalText" />
class="listCalLabel">Event Time:
"EventTimeLabel" runat="server" Text='<%# Eval("EventTime") %>' CssClass="listCalText" />
class="listCalLabel">"lblURL" runat="server" Visible='<%# Eval("URLLink") %>' Text="Additional Info (website):" >
"URLHyperLink" runat="server" Text='<%# Eval("URL") %>' NavigateUrl='<%# Eval("URL") %>' Visible='<%# Eval("URLLink") %>' Target="_blank" CssClass="listLink" />
class="listCalLabel">"lblFile" runat="server" Visible='<%# Eval("FileLink") %>' Text="Additional Info (file):">
"URLFile" runat="server" Text='<%# Eval("FileName") %>' NavigateUrl='<%# "EventFiles/" + Eval("FileName") %>' Visible='<%# Eval("FileLink") %>' Target="_blank" CssClass="listLink" />
<%-- '<%# string.Format("data:image/gif;base64,{0}",Convert.ToBase64String((byte[])Eval("image")))%>'/>--%>
<%--"Image10" runat="server" Height="100px" ImageUrl='<%# "ShowImage.ashx?id=" + Eval("image") %>' GenerateEmptyAlternateText="True" Visible='<%# ShowImg(Eval("image")) %>' />--%>
"itemPlaceholderContainer" runat="server" style="">
"server" id="itemPlaceholder" />

"">

"btnOK" runat="server" OnClientClick="window.close(); return false;" Text="Close Event Detail" CssClass="btn btn-default" />

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bikesh Srivastava10y ago
hi,
use like this..
MemoryStreamstream=newMemoryStream();
image.Save(stream,ImageFormat.Png);
BinaryReaderstreamreader=newBinaryReader(stream);
byte[]data=streamreader.ReadBytes(stream.Length);
Manoj Maharana10y ago
thank you midhun for your support..
Midhun Tp10y ago
Hi Manoj,
I have attached a file. Please check it. Not sure about the data coming from mysql database. Treated it as a Base64 binary string. The basic logic should be like the one in the file. You can make necessary edits to match the file format.
Delpin Susai Raj10y ago
http://technico.qnownow.com/display-images-from-database-in-asp-net-gridview-using-httphandler/
Delpin Susai Raj10y ago
http://www.aspsnippets.com/articles/Display-Images-from-SQL-Server-Database-using-ASP.Net.aspx

Delpin Susai Raj10y ago

ProductImage.ashx must page as

ProductImage.aspx