|
You can set pivotGrid
datasource from SQL query by converting Sql database to data table. so that
we can easily assign the data source to the pivot grid. we have to use the System.Data.SqlServerCe.dll assembly
to run this sample. We have also attached the dll in the below sample link.
We have used a sample database file named “NorthWind.sdf”.
Please refer the
below code:
this.pivotGridControl1.PivotRows.Add(new PivotItem {
FieldMappingName = "City",
TotalHeader = "Total" });
this.pivotGridControl1.PivotRows.Add(new PivotItem {
FieldMappingName = "Last Name",
TotalHeader = "Total" });
// Adding PivotColumns to
the Control
this.pivotGridControl1.PivotColumns.Add(new PivotItem {
FieldMappingName = "Country",
TotalHeader = "Total" });
// Adding PivotCalculations
to the Control
this.pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo
{ FieldName = "Extension",
Format = "C", SummaryType = SummaryType.DoubleTotalSum });
}
public DataTable
GetsData()
{
SqlCeConnection con = new
SqlCeConnection("Data
Source = SQLCeDB\\Northwind.sdf; Password = Hebot15v");
con.Open();
SqlCeDataAdapter adp = new
SqlCeDataAdapter("SELECT
\t[Employees].[Employee ID]\t,[Employees].[Last
Name]\t,[Employees].[First Name]\t,[Employees].[Title]\t,[Employees].[Birth
Date]\t,[Employees].[Hire
Date]\t,[Employees].[Address]\t,[Employees].[City]\t,[Employees].[Region]\t,[Employees].[Postal
Code]\t,[Employees].[Country]\t,[Employees].[Home
Phone]\t,[Employees].[Extension]\t,[Employees].[Photo]\t,[Employees].[Notes]\t,[Employees].[Reports
To] FROM \t[Employees]", con);
DataTable dt = new
DataTable();
adp.Fill(dt);
return dt;
}
Please
refer the below sample:
http://www.syncfusion.com/downloads/support/directtrac/130461/Pivot_Grid_Customization697941168.zip
|
