c#上传图片到SQL中,以及读取的代码

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls; using System.IO;
using System.Data.SqlClient;

public partial class tupiancaozuo : System.Web.UI.Page
{
    private string fileName = "";
    private static SqlConnection conn = null;

    protected void Page_Load(object sender, EventArgs e)
    {
        ConnectDB();

    }
    protected void Button1_Click(object sender, EventArgs e) { WriteImage(); } //得到文件名
    private string GetFile()
    {
        HttpPostedFile file = File1.PostedFile;
        fileName = file.FileName;

        return fileName;
    }
    //读取文件内容
    private byte[] ReadFile()
    {
        FileStream file = File.OpenRead(GetFile());
        byte[] content = new byte[file.Length];
        file.Read(content, 0, content.Length);
        file.Close();

        return content;
    }

    //连接数据库
    private void ConnectDB()
    {
        string connStr = "server=(local)//SQLEXPRESS;uid=sa;pwd=123;database=zonghe;";
        conn = new SqlConnection(connStr);
        conn.Open();
    }
    //写入图片到数据库中
    private void WriteImage()
    {
        SqlCommand comm = conn.CreateCommand();
        comm.CommandText = "insert into images(image,stype) values(@image,@type)";
        comm.CommandType = CommandType.Text;
        SqlParameter param = comm.Parameters.Add("@image", SqlDbType.Image);
        param.Value = ReadFile();
        param = comm.Parameters.Add("@type", SqlDbType.NVarChar);
        param.Value = GetContentType(new FileInfo(fileName).Extension.Remove(0, 1));

        if (comm.ExecuteNonQuery() == 1)
            Response.Write("Successful");
        else
            Response.Write("Fail");

        conn.Close();
    }

    //获取图片的后缀名
    private string GetContentType(string extension)
    {
        string type = "";

        if (extension.Equals("jpg") || extension.Equals("JPG"))
            type = "jpeg";
        else
            type = extension;

        return "image/" + type;
    }

    //从数据库中读取图片
    private void ReadImage()
    {
        SqlCommand comm = conn.CreateCommand();
        comm.CommandText = "select image,stype from images";
        comm.CommandType = CommandType.Text;

        SqlDataReader reader = comm.ExecuteReader();
        while (reader.Read())
        {
            Response.ContentType = reader["stype"].ToString();//读写类型  一定要设置否则浏览器会当作文本输出
            Response.BinaryWrite((byte[])reader["image"]);//图片数据
        }

        Response.Write("Successful");
        Response.End();

        conn.Close();
    }



    protected void Button2_Click(object sender, EventArgs e)
    {
        try
       {
        ReadImage();
       }
       catch(Exception ep)
       {
        conn.Close();
        Response.End();
       }
     }
}