C# (CSharp) C1.DataEngine C1.DataEngine.ObjectConnector.AppendData Beispiele

Beispiel #1

        // add data to DataEngine table
        void AddToEngineTable(int count, bool firstTime)
        {
            // read initial data from database
            var command = new SqlCommand(Properties.Resources.SqlStatement, conn);

            if (firstTime || dataFromDB == null)
            {
                using (var reader = command.ExecuteReader())
                {
                    dataFromDB = Sale.GetSales(reader).ToList();
                }
            }

            // add more rows, just for testing performance
            var      connector = new C1.DataEngine.ObjectConnector <Sale>(_c1FlexPivotPage.FlexPivotPanel.Workspace, ChangeDataSize(dataFromDB, count));
            DateTime dt        = DateTime.Now;
            int      idx       = StartAddingRows(count);

            if (firstTime)
            {
                connector.GetData(tableName);
            }
            else
            {
                connector.AppendData(tableName);
            }
            EndAddingRows(count, dt, idx);

            // connect C1FlexPivot to DataEngine filled with data
            if (firstTime)
            {
                ConnectDataEngine();
            }
        }