using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Data.Common;
using System.IO;
public partial class TestImage : System.Web.UI.Page
{
SqlConnection sqlCon = null;
SqlCommand sqlCmd = null;
protected void Page_Load(object sender, EventArgs e)
{
sqlCon = new SqlConnection(@"Initial Catalog=Demo; Data Source=.\S2005; Integrated security=SSPI; pooling=false");
sqlCon.Open();
if (Request.Params["LoadImage"] == "true")
{
TransferImageData();
}
}
void TransferImageData()
{
try
{
sqlCmd = new SqlCommand("uspImage", sqlCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
object oImage = sqlCmd.ExecuteScalar();
byte[] bt = (byte[])oImage;
Response.Clear();
Response.ContentType = "image/jpeg";
Response.AddHeader("content-disposition", "inline;filename=DBImage.jpg");
Response.Flush();
Response.BinaryWrite(bt);
Response.End();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
string imageFile = @"E:\Photo.jpg";
sqlCmd = new SqlCommand("uspImage", sqlCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
// The Table Field Must Be Of Type "Image"
sqlCmd.Parameters.Add("@img", File.ReadAllBytes(imageFile));
int recInserted = sqlCmd.ExecuteNonQuery();
Response.Write("Image Saved !");
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
}
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="TestImage.aspx.cs" Inherits="TestImage" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
<script type="text/javascript" language="javascript">
function ShowImage()
{
var im = document.getElementById("img");
im.src = "TestImage.aspx?LoadImage=true";
im.style.display = "inline";
return false;
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Button ID="BtnSave" runat="Server" Text="Save Image" OnClick="BtnSave_Click" />
<asp:Button ID="BtnShow" runat="Server" Text="Show Image" OnClientClick="return ShowImage();" />
<br /><br />
<asp:Image ID="img" runat="Server" style="display: none; height: 400px; width: 400px" />
</div>
</form>
</body>
</html>