Best Practices for uploading files to database

by

I would try the following approach which has worked well in the past.

  1. Allow the user to upload the file, put it somewhere on disk.
  2. Bind the results of the file to some grid (you can connect to Excel files using ODBC/OLE DB using traditional Connection/Command objects).
  3. Apply validation to the rows in the grid based on some set of business rules (excel data is normally quite dirty).
  4. Allow the user to update values in the grid and correct validation issues.
  5. When all the data is kosher and the user is happy with it perform a bulk insert in a transaction.
  6. If anything “bad” happens rollback and present some user feedback.

More Related Contents:

  1. Upload files with HTTPWebrequest (multipart/form-data)
  2. LINQ to SQL Left Outer Join
  3. How can I solve a connection pool problem between ASP.NET and SQL Server?
  4. How can I get my webapp’s base URL in ASP.NET MVC?
  5. New asp.net charting controls – will they work with MVC (eventually)?
  6. How to disable postback on an asp Button (System.Web.UI.WebControls.Button)
  7. System.Threading.Tasks – Limit the number of concurrent Tasks
  8. Postback doesn’t work with aspx page as Default Document
  9. Can I develop for .NET Framework 4 in Visual Studio 2008?
  10. GZip Compression On IIS 7.5 is not working
  11. Could not find any resources appropriate for the specified culture or the neutral culture
  12. What is the ‘page lifecycle’ of an ASP.NET WebForm? [closed]
  13. How to create a CheckBoxListFor extension method in ASP.NET MVC?
  14. Data Access Layer design patterns
  15. Control.ResolveUrl versus Control.ResolveClientUrl versus VirtualPathUtility.ToAbsolute
  16. ASP.NET MVC 3 Model Binding Resources
  17. FileUpload control inside an UpdatePanel without refreshing the whole page?
  18. How can I create database tables from XSD files?
  19. How can I avoid SQL injection attacks in my ASP.NET application?
  20. What causing this “Invalid length for a Base-64 char array”
  21. User images – database vs. filesystem storage [duplicate]
  22. User Group and Role Management in .NET with Active Directory
  23. input name and id changes when set runat=server
  24. IIS: web applications warmup
  25. How do I sync the SVN revision number with my ASP.NET web site?
  26. Why are there two incompatible session state types in ASP.NET?
  27. How do I solve an AntiForgeryToken exception that occurs after an iisreset in my ASP.Net MVC app?
  28. Exclude certain pages from using a HTTPModule
  29. How to pass a variable to the SelectCommand of a SqlDataSource?
  30. is it safe to keep database connections open for long time

Leave a Comment