Hi santosgernan1,
Use HttpPostedFileBase to select file.
Fotr uploading file refer below article.
ASP.Net MVC: Simple File Upload Tutorial with example
Refer below sample.
SQL
CREATE TABLE EmployeeData
(
IDNo INT IDENTITY PRIMARY KEY,
EmpName VARCHAR(50),
Photo VARCHAR(100),
MarkSheet VARCHAR(100)
)
Namespaces
using System.IO;
using System.Data.SqlClient;
using System.Configuration;
Controller
public class HomeController : Controller
{
// GET: Home
public ActionResult Index()
{
return View();
}
[HttpPost]
public ActionResult Index(string name, HttpPostedFileBase image1, HttpPostedFileBase image2)
{
string img1 = string.Empty;
string img2 = string.Empty;
if (image1 != null)
{
img1 = Path.Combine("~/Files/Photos/", Path.GetFileName(image1.FileName));
image1.SaveAs(Server.MapPath(img1));
}
if (image2 != null)
{
img2 = Path.Combine("~/Files/Marksheets/", Path.GetFileName(image2.FileName));
image2.SaveAs(Server.MapPath(img2));
}
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
string spName = "INSERT INTO EmployeeData VALUES (@Name, @Photo, @Marksheet)";
using (SqlCommand cmd = new SqlCommand(spName, con))
{
cmd.Parameters.AddWithValue("@Name", name);
cmd.Parameters.AddWithValue("@Photo", img1);
cmd.Parameters.AddWithValue("@Marksheet", img2);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
return View();
}
}
View
@model Sample_237538.Models.EmployeeModel
@{
Layout = null;
}
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width" />
<title>Index</title>
</head>
<body>
@using (Html.BeginForm("Index", "Home", FormMethod.Post, new { enctype = "multipart/form-data" }))
{
<table>
<tr>
<td><span>Name:</span></td>
<td><input type="text" name="name" /></td>
</tr>
<tr>
<td><span>Photo:</span></td>
<td><input type="file" name="image1" /></td>
</tr>
<tr>
<td><span>Marksheet:</span></td>
<td><input type="file" name="image2" /></td>
</tr>
</table>
<br />
<input type="submit" value="Upload" />
}
</body>
</html>
Screenshot
