```
After creating a View, add the following methods in your controller:
```
using System.Web;using System.Web.Mvc;using System.IO;using System.Data.SqlClient;using System.Collections.Generic;
namespace UploadDownloadDbDemo.Controllers{
public class HomeController : Controller {
//check whether the FileUpload control contain file or not public bool HasFile(HttpPostedFileBase file) {
return (file != null && file.ContentLength > 0) ? true : false; }
//upload images in database one by one one if FileUpload contain file
public ActionResult Index() {
foreach (string upload in Request.Files) { if (!HasFile(Request.Files[upload])) continue; string mimeType = Request.Files[upload].ContentType; Stream fileStream = Request.Files[upload].InputStream; string fileName = Path.GetFileName(Request.Files[upload].FileName); int fileLength = Request.Files[upload].ContentLength; byte[] fileData = new byte[fileLength]; fileStream.Read(fileData, 0, fileLength); const string connect = @"Server=your_servername;Database=your_database ;User Id=user_id;password=password;";
using (var conn = new SqlConnection(connect)) { var qry = "INSERT INTO FileStore (FileContent, MimeType, FileName) VALUES (@FileContent, @MimeType, @FileName)"; var cmd = new SqlCommand(qry, conn); cmd.Parameters.AddWithValue("@FileContent", fileData); cmd.Parameters.AddWithValue("@MimeType", mimeType); cmd.Parameters.AddWithValue("@FileName", fileName); conn.Open(); cmd.ExecuteNonQuery();
}
}
return View();
}
//store file name in the list from the database //and store that list object in a ViewBag property
public ActionResult Download() { const string connect = @"Server=your_servername;Database=your_database;User Id=user_id;password=user_password;";
List