首页 > 代码库 > net9:图片文件转换成二进制流存入SQL数据库,以及从数据库中读取二进制流输出文件
net9:图片文件转换成二进制流存入SQL数据库,以及从数据库中读取二进制流输出文件
原文发布时间为:2008-08-10 —— 来源于本人的百度文章 [由搬家工具导入]
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;
public partial class Default4 : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["imgDataConn"].ConnectionString);
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
Guid gid = Guid.NewGuid();
conn.Open();
SqlCommand cmd = new SqlCommand("Insert into imgdata(gid,filedata) values(@gid,@filedata)", conn);
cmd.Parameters.Add("@gid", SqlDbType.UniqueIdentifier).Value = http://www.mamicode.com/gid;
cmd.Parameters.Add("@filedata",SqlDbType.Image).Value=http://www.mamicode.com/FileUpload1.FileBytes;
cmd.ExecuteNonQuery();
conn.Close();
Session["gid"]=gid;
}
protected void Button2_Click(object sender, EventArgs e)
{
conn.Open();
SqlCommand cmd = new SqlCommand("Select filedata from imgdata where gid='" + Session["gid"].ToString() + "'", conn);
byte[] fbt = (byte[])cmd.ExecuteScalar();
conn.Close();
Response.OutputStream.Write(fbt, 0, fbt.Length);
Response.End();
}
}
net9:图片文件转换成二进制流存入SQL数据库,以及从数据库中读取二进制流输出文件