Billeder fra SQL db i Visual Studio2013
Jeg har lavet flere sql udtræk som jeg viser i aspx sider genereret via c# i Visual Studio 2013 og det går helt fint, MEN jeg kan ikke få Visual studio til at vise billder fra SQL db, når jeg i Configure Data Source laver en test Query, så viser den fint billedet, men når jeg så kører siden fra Iexplorer 11, viser den intet billede.mit script er vist herunder:
<%@ Page Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="Frikort" %>
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
<style type="text/css">
.style1
{
font-family: "Segoe UI";
font-weight: bold;
color: #034AF3;
}
.style4
{
font-family: "Segoe UI";
font-weight: bold;
font-size: x-large;
color: #034AF3;
}
.style5
{
font-family: "Franklin Gothic Medium";
font-size: xx-large;
color: #034AF3;
font-style: italic;
font-weight: normal;
}
</style>
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<h2 class="style5">
FIND KORTHOLDER</h2>
<p>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:GalaxyConnectionString %>"
SelectCommand="SELECT Passes.First, Passes.Last, Passes.Street1, Passes.Street2, Passes.Zip, Passes.City, Passes.VisualID, Passes.SendToPrint, Passes.LastUpdatedBy, Pictures.ImageData FROM Passes INNER JOIN Pictures ON Passes.PictureID = Pictures.PictureID WHERE (Passes.VisualID = @VisualID)">
<SelectParameters>
<asp:ControlParameter ControlID="VisualID" Name="VisualID"
PropertyName="Text" DefaultValue="" />
</SelectParameters>
</asp:SqlDataSource>
<span class="style4">Indtast VisualID</span>
<asp:TextBox ID="VisualID" runat="server" Width="463px"></asp:TextBox>
</p>
<p>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="First" HeaderText="First" SortExpression="First" />
<asp:BoundField DataField="Last" HeaderText="Last" SortExpression="Last" />
<asp:BoundField DataField="Street1" HeaderText="Street1"
SortExpression="Street1" />
<asp:BoundField DataField="Street2" HeaderText="Street2"
SortExpression="Street2" />
<asp:BoundField DataField="Zip" HeaderText="Zip" SortExpression="Zip" />
<asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
<asp:BoundField DataField="VisualID" HeaderText="VisualID"
SortExpression="VisualID" />
<asp:BoundField DataField="SendToPrint" HeaderText="SendToPrint"
SortExpression="SendToPrint" />
<asp:BoundField DataField="LastUpdatedBy" HeaderText="LastUpdatedBy"
SortExpression="LastUpdatedBy" />
</Columns>
</asp:GridView>
<asp:FormView ID="FormView" runat="server" DataSourceID="SqlDataSource1">
<EditItemTemplate>
First:
<asp:TextBox ID="FirstTextBox" runat="server" Text='<%# Bind("First") %>' />
<br />
Last:
<asp:TextBox ID="LastTextBox" runat="server" Text='<%# Bind("Last") %>' />
<br />
Street1:
<asp:TextBox ID="Street1TextBox" runat="server" Text='<%# Bind("Street1") %>' />
<br />
Street2:
<asp:TextBox ID="Street2TextBox" runat="server" Text='<%# Bind("Street2") %>' />
<br />
Zip:
<asp:TextBox ID="ZipTextBox" runat="server" Text='<%# Bind("Zip") %>' />
<br />
City:
<asp:TextBox ID="CityTextBox" runat="server" Text='<%# Bind("City") %>' />
<br />
VisualID:
<asp:TextBox ID="VisualIDTextBox" runat="server"
Text='<%# Bind("VisualID") %>' />
<br />
SendToPrint:
<asp:TextBox ID="SendToPrintTextBox" runat="server"
Text='<%# Bind("SendToPrint") %>' />
<br />
LastUpdatedBy:
<asp:TextBox ID="LastUpdatedByTextBox" runat="server"
Text='<%# Bind("LastUpdatedBy") %>' />
<br />
ImageData:
<asp:TextBox ID="ImageDataTextBox" runat="server"
Text='<%# Bind("ImageData") %>' />
<br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True"
CommandName="Update" Text="Update" />
<asp:LinkButton ID="UpdateCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel" Text="Cancel" />
</EditItemTemplate>
<InsertItemTemplate>
First:
<asp:TextBox ID="FirstTextBox" runat="server" Text='<%# Bind("First") %>' />
<br />
Last:
<asp:TextBox ID="LastTextBox" runat="server" Text='<%# Bind("Last") %>' />
<br />
Street1:
<asp:TextBox ID="Street1TextBox" runat="server" Text='<%# Bind("Street1") %>' />
<br />
Street2:
<asp:TextBox ID="Street2TextBox" runat="server" Text='<%# Bind("Street2") %>' />
<br />
Zip:
<asp:TextBox ID="ZipTextBox" runat="server" Text='<%# Bind("Zip") %>' />
<br />
City:
<asp:TextBox ID="CityTextBox" runat="server" Text='<%# Bind("City") %>' />
<br />
VisualID:
<asp:TextBox ID="VisualIDTextBox" runat="server"
Text='<%# Bind("VisualID") %>' />
<br />
SendToPrint:
<asp:TextBox ID="SendToPrintTextBox" runat="server"
Text='<%# Bind("SendToPrint") %>' />
<br />
LastUpdatedBy:
<asp:TextBox ID="LastUpdatedByTextBox" runat="server"
Text='<%# Bind("LastUpdatedBy") %>' />
<br />
ImageData:
<asp:TextBox ID="ImageDataTextBox" runat="server"
Text='<%# Bind("ImageData") %>' />
<br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True"
CommandName="Insert" Text="Insert" />
<asp:LinkButton ID="InsertCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel" Text="Cancel" />
</InsertItemTemplate>
<ItemTemplate>
First:
<asp:Label ID="FirstLabel" runat="server" Text='<%# Bind("First") %>' />
<br />
Last:
<asp:Label ID="LastLabel" runat="server" Text='<%# Bind("Last") %>' />
<br />
Street1:
<asp:Label ID="Street1Label" runat="server" Text='<%# Bind("Street1") %>' />
<br />
Street2:
<asp:Label ID="Street2Label" runat="server" Text='<%# Bind("Street2") %>' />
<br />
Zip:
<asp:Label ID="ZipLabel" runat="server" Text='<%# Bind("Zip") %>' />
<br />
City:
<asp:Label ID="CityLabel" runat="server" Text='<%# Bind("City") %>' />
<br />
VisualID:
<asp:Label ID="VisualIDLabel" runat="server" Text='<%# Bind("VisualID") %>' />
<br />
SendToPrint:
<asp:Label ID="SendToPrintLabel" runat="server"
Text='<%# Bind("SendToPrint") %>' />
<br />
LastUpdatedBy:
<asp:Label ID="LastUpdatedByLabel" runat="server"
Text='<%# Bind("LastUpdatedBy") %>' />
<br />
ImageData:
<asp:Label ID="ImageDataLabel" runat="server" Text='<%# Bind("ImageData") %>' />
<br />
</ItemTemplate>
</asp:FormView>
</p>
<p>
</p>
</asp:Content>
