asp.net上傳圖片保存到數(shù)據(jù)庫的代碼

來源：懂視網(wǎng) 責(zé)編：小采時間：2020-11-27 22:42:58

asp.net上傳圖片保存到數(shù)據(jù)庫的代碼

asp.net上傳圖片保存到數(shù)據(jù)庫的代碼:數(shù)據(jù)庫：保存圖片的數(shù)據(jù)格式圖象二進(jìn)制數(shù)據(jù)儲存字段前臺：代碼如下:<%@ Page Language=C# AutoEventWireup=true CodeBehind=UploadWork.aspx.cs Inherits=meishuguan.UploadWork %> <!DOCT

推薦度：

點(diǎn)擊下載本文 文檔為doc格式

導(dǎo)讀asp.net上傳圖片保存到數(shù)據(jù)庫的代碼:數(shù)據(jù)庫：保存圖片的數(shù)據(jù)格式圖象二進(jìn)制數(shù)據(jù)儲存字段前臺：代碼如下:<%@ Page Language=C# AutoEventWireup=true CodeBehind=UploadWork.aspx.cs Inherits=meishuguan.UploadWork %> <!DOCT

數(shù)據(jù)庫：保存圖片的數(shù)據(jù)格式圖象二進(jìn)制數(shù)據(jù)儲存字段
前臺：
代碼如下:


<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="UploadWork.aspx.cs" Inherits="meishuguan.UploadWork" %> 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
<html xmlns="http://www.w3.org/1999/xhtml"> 
<head runat="server"> 
<title></title> 
<style type="text/css"> 
.style1 
{ 
width: 100%; 
} 
.style2 
{ 
height: 25px; 
} 
</style> 
</head> 
<body> 
<script type="text/javascript"> 
function checkData() { 
var fileName = document.getElementById("UploadImage").value; 
alert(fileName); 
//var fileName = document.getElementsByName("UploadImage").value; 
if (fileName == "") 
return; 
var exName = fileName.substr(fileName.lastIndexOf(".") + 1).toUpperCase(); 
//alert(exName) 
if (exName == "JPG" || exName == "BMP" || exName == "GIF") { 
var imgpath = fileName.src; 
alert(imgpath); 
document.getElementById("PreviewImage").src = imgpath; 
document.write(fileName); 
} 
else { 
alert("請選擇正確的圖片文件") 
document.getElementById("PreviewImage").value = "" 
} 
} 
</script> 
<form method="post" runat="server"> 
<div> 
<table class="style1"> 
<tr> 
<td class="style2"> 
<asp:Label ID="MessageLabel" runat="server"></asp:Label> 
</td> 
<td class="style2"> 
  
</td> 
</tr> 
<tr> 
<td class="style2"> 
<input id="UploadImage" name = "UploadImage" type="file" runat="server" onchange="checkdata()" /> 
</td> 
<td class="style2"> 
  
<img id="PreviewImage" alt="" src="" style="height: 80px; width: 80px" /></td> 
</tr> 
<tr> 
<td> 
<asp:Button ID="UploadButton" runat="server" Text="確定" OnClick="UploadButton_Click" /> 
</td> 
<td> 
  
</td> 
</tr> 
</table> 
</div> 
</form> 
</body> 
</html> 
 
后臺： 
 代碼如下:
using System; 
using System.Collections.Generic; 
using System.Web; 
using System.Web.UI; 
using System.Web.UI.WebControls; 
using System.IO; 
using System.Data.SqlClient; 
using System.Configuration; 
namespace meishuguan 
{ 
public partial class UploadWork : System.Web.UI.Page 
{ 
protected void Page_Load(object sender, EventArgs e) 
{ 
} 
protected void UploadButton_Click(object sender, EventArgs e) 
{ 
HttpPostedFile UpFile = UploadImage.PostedFile; 
int ImageLength = UpFile.ContentLength; 
if (ImageLength == 0) 
{ 
MessageLabel.Text = "請選擇要上傳的圖片"; 
return; 
} 
if (ImageLength > Int32.Parse(Application["MaxImageLength"].ToString())) 
{ 
MessageLabel.Text = "圖片大小不能大于2M"; 
return; 
} 
Stream ImageStream = UpFile.InputStream; 
Byte[] ImageByte = new Byte[ImageLength]; 
ImageStream.Read(ImageByte, 0, ImageLength); 
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); 
string sqlstring = "insert into [Work](MID,image,length) values(@MID,@image,@length)"; 
SqlCommand command = new SqlCommand(sqlstring, connection); 
command.Parameters.Add("@MID", System.Data.SqlDbType.Int).Value = Session["MID"].ToString(); 
command.Parameters.Add("@image", System.Data.SqlDbType.Image, ImageLength).Value = ImageByte; 
command.Parameters.Add("@length", System.Data.SqlDbType.Int).Value = ImageLength; 
connection.Open(); 
command.ExecuteNonQuery(); 
connection.Close(); 
MessageLabel.Text = "圖片上傳成功"; 
} 
} 
} 

 
 




聲明：本網(wǎng)頁內(nèi)容旨在傳播知識，若有侵權(quán)等問題請及時與本網(wǎng)聯(lián)系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com

asp.net上傳圖片保存到數(shù)據(jù)庫的代碼

推薦度：

點(diǎn)擊下載本文 文檔為doc格式

標(biāo)簽：保存上傳保存圖片

熱門焦點(diǎn)

asp.net上傳圖片保存到數(shù)據(jù)庫的代碼

asp.net上傳圖片保存到數(shù)據(jù)庫的代碼

asp.net上傳圖片保存到數(shù)據(jù)庫的代碼

最新推薦

猜你喜歡

熱門推薦