Det virker ikke... poster lige hele koden:
billede.aspx: (vil jeg gerne kunne skrive: billede.aspx?pageID=5)
<%@ Page Language="C#" %>
<script runat="server">
// Insert page code here
//
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<asp:Image id="Image1" runat="server" Width="217px" Height="195px"></asp:Image>
<!-- Insert content here -->
</form>
<br />
<br />
<img style="WIDTH: 553px; HEIGHT: 261px" height="81" src="getimage.aspx" width="553" />
</body>
</html>
--------------------------------------------------------------------------
getimage.aspx:
<%@ Page Language="C#" %>
<%@ import Namespace="System.Data.OleDb" %>
<script runat="server">
// Insert page code here
//
void Page_Load(object sender, EventArgs e) {
int pageID;
if ( Request.QueryString["pageID"] != null ) {
pageID = int.Parse( Request.QueryString["pageID"] );
}
else { pageID = 1; }
string SQL = "SELECT * FROM tblFile WHERE FileID ="+ pageID+";";
// Create Connection object
OleDbConnection dbConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("FileUpload.mdb") + ";");
// Create Command Object
OleDbCommand dbComm = new OleDbCommand(SQL, dbConn);
// Open Connection
dbConn.Open();
// Execute command and receive DataReader
OleDbDataReader dbRead = dbComm.ExecuteReader();
// Read row
dbRead.Read();
// Clear Response buffer
Response.Clear();
// Set ContentType to the ContentType of our file
Response.ContentType = (string)dbRead["ContentType"];
// Write data out of database into Output Stream
Response.OutputStream.Write((byte[])dbRead["FileData"], 0, (int)dbRead["FileSize"]);
// Close database connection
dbConn.Close();
// End the page
Response.End();
}
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<!-- Insert content here -->
</form>
</body>
</html>
