"btnAdd" name="btnAdd" runat="server" Text="上传" onclick="btnAdd_Click"> 上传.aspx.cs string connstr = @"Data Source=WANGRUI-PC\WANGRUI;Initial Catalog=JingDong;Persist Se" /> 
快捷搜索:  as  1111

Asp.net实现将图片以二进制代码形式存入数据库

上传.aspx

"UpPhoto" name="UpPhoto" runat="server" type="file">"btnAdd" name="btnAdd" runat="server" Text="上传"

onclick="btnAdd_Click">

上传.aspx.cs

string connstr = @"Data Source=WANGRUI-PC\WANGRUI;Initial Catalog=JingDong;Persist Security Info=True;User ID=sa;Password=admin";

using (SqlConnection conn = new SqlConnection(connstr)){

conn.Open();using (SqlCommand cmd = conn.CreateCommand())

{//得到图象并把图象转换为byte[]

HttpPostedFile upPhoto = UpPhoto.PostedFile;int upPhotoLength = upPhoto.ContentLength;

byte[] PhotoArray = new Byte[upPhotoLength];Stream PhotoStream = upPhoto.InputStream;

PhotoStream.Read(PhotoArray, 0, upPhotoLength);cmd.CommandText = "insert into eBookxinxi(eBimg,eBmimg,eBtj,eBnjj,eBzjj,eBml,eBname,sjid,eBzz,eBjg) values (@FImage,@image,@tj,@njj,@zjj,@ml,@name,@id,@zz,@jg)";

cmd.Parameters.Add("@FImage", SqlDbType.Image);cmd.Parameters["@FImage"].Value = PhotoArray;

p'

建一个图片网页

if (!Page.IsPostBack)

{SqlConnection conn = new SqlConnection();

conn.ConnectionString = "Data Source=WANGRUI-PC\\WANGRUI;Database=JingDong;User Id=sa;Pwd=admin";string strSql = "select * from eBookxinxi where eBid=1";//这里假设获取id为2的图片

SqlCommand cmd = new SqlCommand(strSql, conn);conn.Open();

SqlDataReader reader = cmd.ExecuteReader();reader.Read();

Response.ContentType = "application/octet-stream";Response.BinaryWrite((Byte[])reader["eBimg"]);

Response.End();reader.Close();

}

您可能还会对下面的文章感兴趣: