SqlBulkCopy Tutorial - Knowledge Base (KB)

Getting Error Invalid cast from 'System.String' to 'System.Guid'

I am Importing Data in Student Record from excel sheet with .xls as it's file extension when i am calling the function to upload Excel that is... public ActionResult Importexcel() { if (Request.Files["FileUpload1"].ContentLength > 0...

set a constant(same) time stamp for multiple data base rows

I'm creating an asp.net mvc4 application, that can write data into database tables from excel sheets(using sqlbulkcopy column mapping). when we select excel sheet and submit, it is writing data into database....Now I want to set file uploaded time as time...

how to do validation in sql bulk copy upload

I just created MVC4 application to upload data using excel file to store in the database table called ...tbl_hei_student....... [HttpPost] [AcceptVerbs(HttpVerbs.Post)] public ActionResult Student(HttpPostedFileBase FileUpload1) { ...

Bind default value if excel sheet column value null in sql bulk copy upload

I created mvc 4 application that can upload data into database using sql bulk copy upload method....Once I select excel file, it can upload data into the system....this is working fine, now I want to add default value if excel field is null...this is how ...