关于ASP.Net MVC直接在控制器书写方法!废话不多少,直接上代码!
public ActionResult MoreInput(HttpPostedFileBase uploadFile)
{
if (uploadFile != null)
{
if (uploadFile.ContentLength > 0)
{
//获得文件的后缀名
string suffix = uploadFile.FileName.Substring(uploadFile.FileName.LastIndexOf(".")).ToLower();
string filePath = Path.Combine(HttpContext.Server.MapPath("/UploadFile"), DateTime.Now.ToString("yyyyMMddHHmmssffff") + suffix);
uploadFile.SaveAs(filePath);
String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + filePath + ";" +
"Extended Properties=Excel 8.0;";
OleDbConnection objConn = new OleDbConnection(sConnectionString);
objConn.Open();
OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [鑫e购$]", objConn);
OleDbDataAdapter ap = new OleDbDataAdapter();
ap.SelectCommand = objCmdSelect;
DataSet ds = new DataSet();
//将Excel中数据填充到数据集
ap.Fill(ds, "鑫e购");
objConn.Close();
//删除文件
System.IO.File.Delete(filePath);
try
{
foreach (DataRow row in ds.Tables[0].Rows)
{
//将ds写入数据库
}
}
catch (Exception)
{
MessageBox.ShowLock(this, "导入出错,请确认Excel格式正确后导入!");
}
}
else
{
MessageBox.ShowLock(this, "上传文件为空文件!");
}
}
else
{
MessageBox.ShowLock(this, "请选择需要上传的文件!");
}
return View();
}
实习3个月了,第一次发博客,希望可以帮助到有需要的人!!!