public void BindProductsFromLiveServer(DataTable dttblUpdate) { DataTable dt = new DataTable("tmp_Updatable"); string str = ""; try { dt = dttblUpdate; lbltotalerrorcount.Text = ""; if (dt != null && dt.Rows.Count > 0) { #region BULK INSERT objproduct.DeleteTempProductRecords(); // Copy the DataTable to SQL Server using SqlBulkCopy objproduct.SqlBulkCopyOperation(dt); objproduct.InsertUpdateProductFromTemp(); //Response.Write("<br>SQL BULK COPY Insert comepleted<br>"); //Response.Write("<br>Data transfer completed<br>"); //Response.Write("<br>End Time ==> " + DateTime.Now + "<br>"); //Response.Write("<br>Total " + dt.Rows.Count + " records are import.<br>"); #endregion } else { lbltotalerrorcount.Text += "<tr><td colspan=\"6\"><b style=\"color:red;\">No products available on live server.</b></td></tr>"; } } catch (Exception ex) { throw ex; } finally { dt.Dispose(); dt = null; dttblUpdate.Dispose(); dttblUpdate = null; } }