Friday, 6 September 2013

Uploading a file, parsing and then saving in database

Uploading a file, parsing and then saving in database

I want to upload a large file containing upto 10 million records on
asp.net web page, parse the records, validate them and save them in
database.
What approach should i use so that it efficently uploads file to the
database? What will happen if validation fails on a single record. Should
i discard the entire file? How will i notify the user about the problem?

No comments:

Post a Comment