Database

OleDbConnection oleDbConnection = new OleDbConnection("Provider=vfpoledb;Data Source=" + _tempFolderPath)

string insertCommandText = String.Format("INSERT INTO {0} ({1}) VALUES ({2})",
                                                                dataTable.TableName,
                                                                columnsList.TrimEnd(','),
                                                                arguments.Replace("P", "?,").TrimEnd(','));

                       int it = 0;
                       foreach (DataRow dataRow in dataTable.Rows)
                       {
                           using (OleDbCommand oleDbCommand = new OleDbCommand(insertCommandText,
                                                                               oleDbConnection,
                                                                               oleDbTransaction))
                           {
                               for (int i = 0; i < dataRow.ItemArray.Length; i++)
                               {
                                   if(IsAdditionalSortColumn(dataTable.Columns[i].ColumnName))
                                       continue;
                                   oleDbCommand.Parameters.AddWithValue("@param" + i, dataRow.ItemArray[i]);
                               }

                               oleDbCommand.ExecuteNonQuery();
                               it++;
                           }
                       }
                   }