/***********************************Function to Save Defect File into Sql Server 2000 using Bulk Copy Method***********************************/ public string SaveDefect(DataTable dt) { string lblMessage = ""; MastersController objCont = new MastersController(); string sConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["connectionString"].ToString(); int Status = 0; try { string strDelete = "Delete from DefectTemp"; objController.ExecuteQuery(strDelete); SqlConnection sqlconn = new SqlConnection(sConnectionString); sqlconn.Open(); SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlconn); bulkCopy.DestinationTableName = "DefectTemp"; bulkCopy.WriteToServer(dt); Status = objCont.SaveDefectData(); if (Status == 1) { //Ask User if the duplicates are to be replaced //if Yes then delete Page.RegisterStartupScript("OnBlock", "<script language='javascript'>getStatus('defect');</script>"); Session.Add("dtdefect", dt); } else { lblMessage = "File Defect saved successfully"; } } catch(Exception ex) { //lblMessage = "File Defect could not be saved successfully"; string strMessage = ex.Message.ToString(); if (strMessage.Contains("Cannot insert duplicate key in object")) { lblMessage = "Cannot insert duplicate values"; } else { lblMessage = "Excel file is not in valid format"; } } return lblMessage; }