這里演示的是如何將上傳圖片直接保存至SQL Server數(shù)據(jù)庫中。
在數(shù)據(jù)庫中，圖片使用varbinary(MAX)存儲：
這是個基于MVC3架構(gòu)的例子。廢話不多說，直接上代碼：
View：
@{
ViewBag.Title = "UpLoadImg";
}
@using (Html.BeginForm("Create", "UpLoadImg", FormMethod.Post, new { enctype = "multipart/form-data" }))
{
<h2>
UpLoadImg</h2>
<div id="mainform">
<div>
<input type="file" id="UpLoadFile" name="UpLoadFile" />
<input id="btnUpLoad" type="submit" value="上傳" />
</div>
<div>
</div>
</div>
} |
Controller后臺Action：
public ActionResult Create()
{
string filename = string.Empty;
string filetype=string.Empty;
byte[] filecontext=null;
HttpPostedFileBase filebase = Request.Files["UpLoadFile"];
if (filebase.ContentLength > 0)
{
Stream stream = filebase.InputStream;
byte[] by = new byte[filebase.ContentLength];
int i = stream.Read(by,0,filebase.ContentLength);
stream.Close();
string[] arrs = filebase.FileName.Split('\\');
if (arrs.Length > 0)
{
filename = arrs[arrs.Length - 1];
}
else
{
filename = filebase.FileName;
}
filetype=filebase.ContentType;
filecontext=by;
}//淡雅一抹繁華，幾多思念許他，他不知花開不易，他不懂人心需要珍惜。
int count = 0;
#region 插入數(shù)據(jù)
try
{
string ImageStore = System.Configuration.ConfigurationManager.AppSettings["ConnectionStrImageStore"].ToString().Trim();
string sqlStr = string.Empty;
sqlStr = @"INSERT INTO [Images] ([filename],[filetype],[filecontext],[uploadtime])
VALUES(@filename,@filetype,@filecontext,@uploadtime)";
SqlConnection connection = new SqlConnection(ImageStore);
SqlCommand command = new SqlCommand(sqlStr, connection);
command.Parameters.AddWithValue("@filename",filename);
command.Parameters.AddWithValue("@filetype",filetype);
command.Parameters.AddWithValue("@filecontext",filecontext);
command.Parameters.AddWithValue("@uploadtime",DateTime.Now);
command.Connection.Open();
count=command.ExecuteNonQuery();
command.Connection.Close();
}
catch
{
}
#endregion if (count > 0)
{
return RedirectToAction("UpLoadImg");
}
else
{
return RedirectToAction("Index");
}
} |