public static void BulkToDB(DataTable dt, string tableName) { string connstring = DBUtility.PubConst.GetBusinessDbconnectionString(); SqlConnection sqlConn = new SqlConnection(connstring); SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConn); bulkCopy.DestinationTableName = tableName; bulkCopy.BatchSize = dt.Rows.Count; try { sqlConn.Open(); if (dt != null && dt.Rows.Count != 0) bulkCopy.WriteToServer(dt); } catch (Exception ex) { throw ex; } finally { sqlConn.Close(); if (bulkCopy != null) bulkCopy.Close(); } }