您的位置:首页 > 教程资讯 > 皇冠体育的网址 > ASP.NET > 上传图片后使用数据库保存图片的示例分享

上传图片后使用数据库保存图片的示例分享

发布于:2016-04-26 16:50:58   分享到:

代码如下:
HttpPostedFile UpFile = File1.PostedFile;
int FileLenght = UpFile.ContentLength;
decimal FileSize = FileLenght / 1024;
if (FileLenght == 0)
{
??? DIVShowGVError.Visible = true;
??? LblShowGVError.Text = "请选择上传文件";
??? return;
}
string strImageName = UpFile.FileName;
string strImageType = strImageName.Substring(strImageName.LastIndexOf(".")).ToLower();
if (strImageType != ".jpg" && strImageType != ".jpeg" && strImageType != ".bmp" && strImageType != ".png")
{
??? DIVShowGVError.Visible = true;
??? LblShowGVError.Text = "请上传以下文件格式的图片:jpg,jpeg,bmp,png";
??? return;
}
if (FileSize > 2048)
{
??? DIVShowGVError.Visible = true;
??? LblShowGVError.Text = "上传图片不能大於2M";
??? return;
}
else
{
??? Byte[] FileByteArray = new Byte[FileLenght];
??? Stream StreamObject = UpFile.InputStream;
??? StreamObject.Read(FileByteArray, 0, FileLenght);

??? strNewLeave = "insert into [Leave]([ID],[EmployeeNo],[AgentID],[LeaveType],[StartDate],[EndDate],[Hours],[LeaveReason],[ReportTime],[ReportID],[ImageName],[ImageData]) ";
??? strNewLeave += "values(@LeaveNo,@EmpNo,@AgentName,@LeaType,@StartDate,@EndDate,@Hours,@Reason,getdate(),@Admin,@ImageName,@Image) ";

??? sqlPara = new SqlParameter[] {
??? new SqlParameter("@LeaveNo",strLeaNo),
??? new SqlParameter("@EmpNo",strEmpNo),
??? new SqlParameter("@AgentName",strAgentID),
??? new SqlParameter("@LeaType",strLeaType),
??? new SqlParameter("@StartDate",strDateSt),
??? new SqlParameter("@EndDate",strDateEnd),
??? new SqlParameter("@Hours",strHours),
??? new SqlParameter("@Reason",strReason),
??? new SqlParameter("@Admin",strAdmin),
??? new SqlParameter("@ImageName",strImageName),
??? new SqlParameter("@Image",FileByteArray)
??? };

??? StreamObject.Close();
}

代码如下:
SQLHelper sqlH = new SQLHelper();
??????? string strID = context.Request["ID"];
??????? byte[] MyData = new byte[0];
??????? string str = "? select [ImageData] from [Leave] where [ID]='" + strID + "' ";
??????? DataTable dt = sqlH.ExecuteQuery(str, CommandType.Text);
??????? if (dt.Rows.Count > 0)
??????? {
MyData = (byte[])dt.Rows[0][0];
int ArraySize = MyData.GetUpperBound(0);

context.Response.OutputStream.Write(MyData, 0, ArraySize);
??????? }

标签:

数据库

关于我们  加入我们  版权声明  商务合作  友情链接  网站地图  站长统计

脚本大全-脚本语言之家-版权所有 

Copyright (C) 2016 jiaoben.net, All Rights Reserved