Hi Mohanram,
Thanks for you response but I am able to add columns at run time but not able to bind data to all my columns (sparkline).
the below is my code behind classes where I want to provide grid with Orders so that each spark line template column can show list of Order.
public class Orders
{
public Orders()
{
this.AllOrders = new List<List<Order>>();
}
private List<List<Order>> allorders;
public List<List<Order>> AllOrders
{
get { return allorders; }
set { allorders = value; }
}
}
public List<Order> generateRowData(string key)
{
List<Order> MyOrdersRow = new List<Order>();
var rand = new Random();
//Creating 19 graph data boxes take it as a CV
for (Int32 i = 0; i < 19; i++)
{
var member = new Order();
for (int j = 1; j < 45; j++)
member.Orders.Add(new OrderData { CvDataPoint = j, MvfvDataPoint = rand.Next(0, 160) });
MyOrdersRow.Add(member);
}
return MyOrdersRow;
}
public class Order
{
public Order()
{
this.Orders = new List<OrderData>();
}
private List<OrderData> orders;
/// <summary>
/// this will be data source for sparkline charts
/// </summary>
public List<OrderData> Orders
{
get { return orders; }
set { orders = value; }
}
}
public class OrderData
{
private int cvDataPoint;
public int CvDataPoint
{
get { return cvDataPoint; }
set { cvDataPoint = value; }
}
private int mvfvDataPoint;
public int MvfvDataPoint
{
get { return mvfvDataPoint; }
set { mvfvDataPoint = value; }
}
}
The Below is the xaml Part :
<syncfusion:SfDataGrid Height="Auto" Name="MySFGrid">
<syncfusion:SfDataGrid.Columns>
<syncfusion:GridTemplateColumn MappingName="CvDataPoint" Width="250" >
<syncfusion:GridTemplateColumn.CellTemplate>
<DataTemplate>
<Grid Height="Auto">
<syncfusion:SfLineSparkline ItemsSource="{Binding Orders}" Height="Auto" MarkerVisibility="Visible"
Padding="4" YBindingPath="CvDataPoint" XBindingPath="MvfvDataPoint">
</syncfusion:SfLineSparkline>
</Grid>
</DataTemplate>
</syncfusion:GridTemplateColumn.CellTemplate>
</syncfusion:GridTemplateColumn>
</syncfusion:SfDataGrid.Columns>
</syncfusion:SfDataGrid>
