使用asp.net和C#如何存取Sql Server2000中的Image(16)类型的字段

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.Configuration;
using System.IO;
using System.Drawing;

public partial class ImgRead : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        ImgDataRead();
    }
    private void ImgDataRead()
    {
        int ImgID = Convert.ToInt32(Request.QueryString["id"]);

        SqlConnection Con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);

        String SqlCmd = "SELECT * FROM ImageStore WHERE ID = @ImageID";
        SqlCommand CmdObj = new SqlCommand(SqlCmd, Con);
        CmdObj.Parameters.Add("@ImageID", SqlDbType.Int).Value = ImgID;
        Con.Open();
        SqlDataReader SqlReader = CmdObj.ExecuteReader();
        SqlReader.Read();
        Response.ContentType = (string)SqlReader["ImageContentType"];//设定输出文件类型       
        //输出图象文件二进制数制
        
        Response.OutputStream.Write((byte[])SqlReader["ImageData"],0,Convert.ToInt32(SqlReader["ImageSize"]));
        Response.BufferOutput = true;
        Con.Close();   

    }
}

写入image数据

using System;
using System.Data;
using System.Configuration;
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.IO;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    Int32 FileLength = 0;
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        HttpPostedFile UpFile = UP_File.PostedFile;//HttpPostedFile对象，用于读取图象文件属性   
        FileLength = UpFile.ContentLength;

        try
        {
            if (FileLength == 0)
            {
                lblMessage.Text = "<b>请选择您要上传的文件</b>";
            }
            else
            {
                Byte[] FileByteArray = new byte[FileLength];   //图象文件临时储存Byte数组   
                Stream StreamObj = UpFile.InputStream;//建立数据流对像   
                //读取图象文件数据，FileByteArray为数据储存体，0为数据指针位置、FileLnegth为数据长度   
                StreamObj.Read(FileByteArray, 0, FileLength);

                SqlConnection Con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
                String SqlCmd = "INSERT INTO ImageStore (ImageData,ImageContentType,ImageDescription,ImageSize) VALUES (@Image,@ContentType,@ImageDescription,@ImageSize)";
                SqlCommand CmdObj = new SqlCommand(SqlCmd, Con);
                CmdObj.Parameters.Add("@Image", SqlDbType.Binary, FileLength).Value = FileByteArray;
                CmdObj.Parameters.Add("@ContentType", SqlDbType.VarChar, 50).Value = UpFile.ContentType;//记录文件类型       
                //把其它单表数据记录上传       
                CmdObj.Parameters.Add("@ImageDescription", SqlDbType.VarChar, 200).Value = txtDescription.Text;
                //记录文件长度，读取时使用       
                CmdObj.Parameters.Add("@ImageSize", SqlDbType.BigInt, 8).Value = UpFile.ContentLength;
                Con.Open();
                CmdObj.ExecuteNonQuery();
                Con.Close();
                lblMessage.Text = "<p><b>OK!你已经成功上传你的图片</b>";//提示上传成功   

            }
        }
        catch (Exception ex)
        {
            lblMessage.Text = ex.Message.ToString();
        }

    }
}

读取：

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.Configuration;
using System.IO;
using System.Drawing;

public partial class ImgRead : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        ImgDataRead();
    }
    private void ImgDataRead()
    {
        int ImgID = Convert.ToInt32(Request.QueryString["id"]);

        SqlConnection Con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);

        String SqlCmd = "SELECT * FROM ImageStore WHERE ID = @ImageID";
        SqlCommand CmdObj = new SqlCommand(SqlCmd, Con);
        CmdObj.Parameters.Add("@ImageID", SqlDbType.Int).Value = ImgID;
        Con.Open();
        SqlDataReader SqlReader = CmdObj.ExecuteReader();
        SqlReader.Read();
        Response.ContentType = (string)SqlReader["ImageContentType"];//设定输出文件类型       
        //输出图象文件二进制数制
        
        Response.OutputStream.Write((byte[])SqlReader["ImageData"],0,Convert.ToInt32(SqlReader["ImageSize"]));
        Response.BufferOutput = true;
        Con.Close();   

    }
}