'' Instead of saving the records, lets use sqlBulkCopy to speed up the import to SQL processUsing destinationConnection As SqlClient.SqlConnection = _ New SqlClient.SqlConnection(MicroFour.StrataFrame.Data.DataLayer.DataSources(Me.BizCustomersItems1.DataSourceKey).ConnectionString) destinationConnection.Open() Using bulkCopy As SqlClient.SqlBulkCopy = New SqlClient.SqlBulkCopy(destinationConnection) Try bulkCopy.DestinationTableName = Me.BizCustomersItems1.TableNameAndSchema bulkCopy.BatchSize = 50 bulkCopy.BulkCopyTimeout = 0 '-- Create a column mapping with all fields in the BO For Each fieldName As String In .AllFieldsList() bulkCopy.ColumnMappings.Add(fieldName, fieldName) Next bulkCopy.WriteToServer(Me.BizCustomersItems1.CurrentDataTable) bulkCopy.Close() ''-- Accept the changes to the data table to avoid message asking to save records. Me.BizCustomersItems1.CurrentDataTable.AcceptChanges() Catch ex As Exception MsgBox(ex.ToString) Finally Me.WaitWindow1.HideWaitWindow() End Try End UsingEnd Using