/***********************************Function to Save Customer Voice File into Sql Server 2000 using Bulk Copy Method***********************************/ public string SaveCustomerVoice(DataTable dt) { string lblMessage = ""; MastersController objCont = new MastersController(); string sConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["connectionString"].ToString(); int Status = 0; try { string strDelete = "Delete from CustomerVoiceTemp"; objController.ExecuteQuery(strDelete); SqlConnection sqlconn = new SqlConnection(sConnectionString); sqlconn.Open(); SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlconn); bulkCopy.DestinationTableName = "CustomerVoiceTemp"; bulkCopy.WriteToServer(dt); Status = objCont.SaveCustomerVoiceData(); if (Status == 1) { //Ask User if the duplicates are to be replaced //if Yes then delete Page.RegisterStartupScript("OnBlock", "<script language='javascript'>getStatus('customervoice');</script>"); Session.Add("dtcustvoice", dt); } else { lblMessage = "File Customer Voice saved successfully"; } } catch(Exception ex) { // lblMessage = "File Customer Voice 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; }