how to upload csv file to database using mvc razor?

See more:

C#3.5

C#5.0

MVC4

MVC5

hi, there I am following this article to upload csv file into sql server database but this tutorial in aspx mvc2.. so I am not able to make it work.. also it is giving me several exceptions.

http://arranmaclean.wordpress.com/2010/07/20/net-mvc-upload-a-csv-file-to-database-with-bulk-upload/[^]

HomeController Code

[HttpPost]
       public ActionResult Index(HttpPostedFileBase FileUpload)
       {

           DataTable dt = new DataTable();


           if (FileUpload.ContentLength > 0)
           {

               string fileName = Path.GetFileName(FileUpload.FileName);
               string path = Path.Combine(Server.MapPath("~/App_Data/uploads"), fileName);


               try
               {
                   FileUpload.SaveAs(path);

                   dt = ProcessCSV(path);


                   ViewData["Feedback"] = ProcessBulkCopy(dt);
               }
               catch (Exception ex)
               {

                   ViewData["Feedback"] = ex.Message;
               }
           }
           else
           {

               ViewData["Feedback"] = "Please select a file";
           }


           dt.Dispose();

           return View("Index", ViewData["Feedback"]);
       }

       private static DataTable ProcessCSV(string fileName)
       {

           string Feedback = string.Empty;
           string line = string.Empty;
           string[] strArray;
           DataTable dt = new DataTable();
           DataRow row;


           Regex r = new Regex(",(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))");


           StreamReader sr = new StreamReader(fileName);


           line = sr.ReadLine();
           strArray = r.Split(line);


           Array.ForEach(strArray, s => dt.Columns.Add(new DataColumn()));



           while ((line = sr.ReadLine()) != null)
           {
               row = dt.NewRow();


               row.ItemArray = r.Split(line);
               dt.Rows.Add(row);
           }


           sr.Dispose();


           return dt;


       }


       private static String ProcessBulkCopy(DataTable dt)
       {
           string Feedback = string.Empty;
           string connString = ConfigurationManager.ConnectionStrings["myConnection"].ConnectionString;


           using (SqlConnection conn = new SqlConnection(connString))
           {

               using (var copy = new SqlBulkCopy(conn))
               {


                   conn.Open();


                   copy.DestinationTableName = "BulkImportDetails";
                   copy.BatchSize = dt.Rows.Count;
                   try
                   {

                       copy.WriteToServer(dt);
                       Feedback = "Upload complete";
                   }
                   catch (Exception ex)
                   {
                       Feedback = ex.Message;
                   }
               }
           }

           return Feedback;
       }

Index Razor View

@{
    ViewBag.Title = "Index";
}

<h2>Index</h2>

@{
    ViewBag.Title = "Home Page";
}
<h2>CSV Bulk Upload</h2>
@{ using (Html.BeginForm("", "", FormMethod.Post, new { enctype = "multipart/form-data" }))
 {
    <input type="file" name="FileUpload" />
    <input type="submit" name="Submit" id="Submit" value="Upload" />
 }
}

<p>@{ Html.Encode(ViewData["Feedback"]);} </p>

Currently, I am getting "no file selected exception" via Feedback.