ASP、将图片存入SQL(备忘录)

// 保存

protected void Button3_Click(object sender, EventArgs e)

    {

        FileStream fs = null;

        SqlConnection conn = new SqlConnection("Data Source=--IP--; Initial Catalog=--数据库--; User ID=--数据库帐号--;Pwd=--数据库密码--");

        SqlCommand comm = new SqlCommand("insert into Bin values(@values_)", conn);

 

        fs = new FileStream(Server.MapPath("c.jpg"), FileMode.Open, FileAccess.Read);

        byte[] blob = new byte[fs.Length];

        fs.Read(blob, 0, blob.Length);

        fs.Close();

        SqlParameter p = new SqlParameter("@values_", SqlDbType.VarBinary, blob.Length);

        p.Value = blob;

        comm.Parameters.Add(p);

        conn.Open();

        comm.ExecuteNonQuery();

        if (int.Parse(comm.ExecuteNonQuery().ToString()) > 0)

        {

            Label3.Text = "成功";

        }

        else

        { Label3.Text = "失败"; }

        conn.Close();

 

 

}

 

//读取

    protected void Button4_Click(object sender, EventArgs e)

    {

        Byte[] blob = null;

        FileStream fs = null;

        SqlConnection conn = new SqlConnection("Data Source=--IP--; Initial Catalog=--数据库--; User ID=--数据库帐号--;Pwd=--数据库密码--");

        SqlCommand comm = new SqlCommand("select pic from bin where id=8", conn);

        conn.Open();

        SqlDataReader dr = comm.ExecuteReader();

        dr.Read();

        blob = new Byte[dr.GetBytes(0, 0, null, 0, int.MaxValue)];

        dr.GetBytes(0, 0, blob, 0, blob.Length);

        dr.Close();

        conn.Close();

        fs = new FileStream(Server.MapPath("x1.jpg"), FileMode.Create, FileAccess.Write);//保存在程序路径下

        fs.Write(blob, 0, blob.Length);

        fs.Close();

        Image3.ImageUrl = "x1.jpg";//从程序路径下 读到图片框中

    }

 

我还是菜鸟...第一次写 写的不好 别笑我！

 

 

 

 

--加油、自己--