将图片以二进制代码形式存入数据库
上传aspx
<!--上传图片-->
<input id="UpPhoto" name="UpPhoto" runat="server" type="file">
<asp:Button id="btnAdd" name="btnAdd" runat="server" Text="上传"
onclick="btnAdd_Click"></asp:Button>
www.zzzyk.com
上传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();
}
补充：综合编程 , 其他综合 ,
