将图片保存到表中并用ajax技术获取图片

创建用于保存图片的表：
create table stockImages
( imageid int primary key identity(1,1),
  [filename] varchar(50),
  img varbinary(max))
插入本地图片：
insert into stockImages
select '风景',bulkcolumn
from openrowset(bulk 'd:\\img.jpg',single_blob) as x
创建存储过程，检索图片，将二进制数据包含在XML文档片段中：
create proc getImage @id int
as
declare @xmlResult xml
set @xmlResult=(select  * from stockImages where imageid=@id for xml auto,elements,root('Items'),binary base64)
select @xmlResult
使用一般处理文件获取检索到得XML文档并发送到客户端：
<%@ WebHandler Language="C#" Class="ImageHandler" %>
using System;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Xml;
public class ImageHandler : IHttpHandler {
   
    public void ProcessRequest (HttpContext context) {
        string connectionString =
           ConfigurationManager.ConnectionStrings[
           "uploadConnectionString"].ConnectionString;
        SqlConnection connection = new SqlConnection(connectionString);
        SqlCommand cmd = new SqlCommand("getImage", connection);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@id", SqlDbType.Int).Value = context.Request.QueryString["id"];
        try
        {
            connection.Open();
            SqlDataReader reader = cmd.ExecuteReader();
            while (reader.Read())