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

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› ASP.NET›ASP.NET编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

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 = "请选择您要上传的文件";
 }
 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 = "OK!你已经成功上传你的图片";//提示上传成功

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

 }
}

读取：