public TopNDemo()
{
InitializeComponent();
Tag = Properties.Resources.TopNDemoDesc;
this.Loaded += (s, ea) =>
{
if (!pivotGrid.IsVisible)
{
return;
}
if (isLoaded)
{
return;
}
isLoaded = true;
// bind to data source
var panel = new FlexPivotPanel();
panel.DataSource = Utils.PivotDataSet.Tables[0].DefaultView;
pivotGrid.ItemsSource = panel;
fpEngine = panel.FlexPivotEngine;
// apply update to view
fpEngine.BeginUpdate();
fpEngine.RowFields.Add("Country");
fpEngine.ColumnFields.Add("Salesperson");
fpEngine.ValueFields.Add("ExtendedPrice");
fpEngine.Fields["ExtendedPrice"].Format = "c0";
fpEngine.EndUpdate();
};
}
public Form1()
{
InitializeComponent();
C1FlexPivotEngine pivot = AdventureWorks.Cube.GetPivotEngine();
dataGridView1.ColumnAdded += (s, e) => dataGridView1.Columns[0].Frozen = true;
dataGridView1.DataSource = pivot.FlexPivotDefaultView;
}
public Form1()
{
InitializeComponent();
ServicePointManager.SecurityProtocol = (SecurityProtocolType)3072;
Workspace workspace = Northwind.Invoice.GetWorkspace();
C1FlexPivotEngine pivot = Northwind.Invoice.GetPivotEngine(workspace);
dataGridView1.ColumnAdded += (s, e) => dataGridView1.Columns[0].Frozen = true;
dataGridView1.DataSource = pivot.FlexPivotDefaultView;
}
public static C1FlexPivotEngine GetPivotEngine()
{
C1FlexPivotEngine fp = new C1FlexPivotEngine();
fp.ConnectCube(cubeName, connectionString);
fp.BeginUpdate();
fp.ColumnFields.Add("Color");
fp.RowFields.Add("Category");
fp.ValueFields.Add("Order Count");
fp.EndUpdate();
return(fp);
}
public static C1FlexPivotEngine GetPivotEngine(Workspace workspace)
{
C1FlexPivotEngine fp = new C1FlexPivotEngine();
fp.Workspace = workspace;
fp.ConnectDataEngine("SalesByEmployeeCountry");
fp.BeginUpdate();
fp.ColumnFields.Add("Country");
fp.RowFields.Add("Salesperson");
fp.ValueFields.Add("Sales");
fp.EndUpdate();
return(fp);
}
public static C1FlexPivotEngine GetPivotEngine(Action <C1FlexPivotEngine> action)
{
C1FlexPivotEngine fp = new C1FlexPivotEngine();
fp.ConnectCube(cubeName, connectionString);
fp.UpdateCompleted += (s, e) =>
{
action.Invoke(fp);
};
fp.BeginUpdate();
fp.ColumnFields.Add("Color");
fp.RowFields.Add("Category");
fp.ValueFields.Add("Order Count");
fp.EndUpdate();
return(fp);
}
public static C1FlexPivotEngine GetPivotEngine(Workspace workspace, Action <C1FlexPivotEngine> action)
{
C1FlexPivotEngine fp = new C1FlexPivotEngine();
fp.Workspace = workspace;
fp.ConnectDataEngine("SalesByEmployeeCountry");
fp.UpdateCompleted += (s, e) =>
{
action.Invoke(fp);
};
fp.BeginUpdate();
fp.ColumnFields.Add("Country");
fp.RowFields.Add("Salesperson");
fp.ValueFields.Add("Sales");
fp.EndUpdate();
return(fp);
}
public Form1()
{
InitializeComponent();
DataGridView grid = new DataGridView();
Controls.Add(grid);
grid.Dock = DockStyle.Fill;
grid.ReadOnly = true;
grid.AllowUserToAddRows = false;
grid.AllowUserToDeleteRows = false;
grid.ColumnAdded += (s, e) => grid.Columns[0].Frozen = true;
C1FlexPivotEngine pivot = AdventureWorks.Cube.GetPivotEngine();
grid.DataSource = pivot.FlexPivotDefaultView;
}
public TopN()
{
InitializeComponent();
// get data
var dt = DemoDataSource("select * from Invoices", true);
// bind to data source
var panel = new C1FlexPivotPanel();
panel.DataSource = dt;
c1FlexPivotGrid1.DataSource = panel;
// initialize view
_engine = panel.FlexPivotEngine;
_engine.RowFields.Add("ProductName");
_engine.ColumnFields.Add("Country");
_engine.ValueFields.Add("Quantity");
}
public Form1()
{
InitializeComponent();
// get data
var da = new OleDbDataAdapter("select * from [Sales By Category]", GetConnectionString());
var dt = new DataTable();
da.Fill(dt);
// bind to data source
var panel = new C1FlexPivotPanel();
panel.DataSource = dt;
c1FlexPivotGrid1.DataSource = panel;
// initialize view
_engine = panel.FlexPivotEngine;
_engine.RowFields.Add("ProductName");
_engine.ColumnFields.Add("CategoryName");
_engine.ValueFields.Add("ProductSales");
}
