Hi,
I'm adding data to sfDataGrid in C# code dynamically depending of the datasource. ItemsSouce is DataTable from DataSet and data is displayed.
When I want to add GridComboBoxColumn() then data is not shown
Code;
XAML
<Syncfusion:SfDataGrid x:Name="sfDataGrid2" HorizontalAlignment="Left" Height="159" Margin="53,440,0,0" VerticalAlignment="Top" Width="922" AllowFiltering="True" RowHeaderWidth="15" AddNewRowPosition="FixedTop" FooterRowsCount="1" RowHeight="18" AutoGenerateColumns="False" AutoGenerateColumnsMode="ResetAll"/>
C#
public void FillDataSet()
{
DataTable dtArticles = new DataTable("Articles");
dtArticles.Columns.Add("id");
dtArticles.Columns.Add("name");
dtArticles.Columns.Add("idgroup");
dtArticles.Rows.Add(1, "Cola",1);
dtArticles.Rows.Add(2, "Pizza",2);
dtArticles.Rows.Add(3, "Steak", 2);
DataTable dtGroups= new DataTable("Groups");
dtGroups.Columns.Add("idgroup");
dtGroups.Columns.Add("groupname");
dtGroups.Rows.Add(1,"Drink");
dtGroups.Rows.Add(2,"Food");
ds = new DataSet("gastronomy");
ds.Tables.Add(dtArticles);
ds.Tables.Add(dtGroups);
}
private void FillDataGrid()
{
FillDataSet();
sfDataGrid2.Columns.Clear();
sfDataGrid2.ItemsSource = ds.Tables["Articles"].DefaultView;
sfDataGrid2.AutoGenerateColumns = false;
sfDataGrid2.AutoGenerateColumnsMode = AutoGenerateColumnsMode.ResetAll;
//Column definition
sfDataGrid2.Columns.Add(new GridNumericColumn() { HeaderText = "Article ID", MappingName = "id", NumberDecimalDigits = 0, ColumnSizer = GridLengthUnitType.SizeToHeader });
sfDataGrid2.Columns.Add(new GridTextColumn() { HeaderText = "Name", MappingName = "name" });
//This column is only to show that data exists in this column
sfDataGrid2.Columns.Add(new GridNumericColumn() { HeaderText = "Group ID", MappingName = "idgroup", NumberDecimalDigits = 0, ColumnSizer = GridLengthUnitType.SizeToHeader });
sfDataGrid2.Columns.Add(new GridComboBoxColumn()
{
ItemsSource = ds.Tables["Groups"].DefaultView,
HeaderText = "Group",
MappingName = "idgroup",
DisplayMemberPath = "groupname",
});
}
What I get is:
Nothing is displayed in Group column. Ofc in this column I want the user to choose from Food, Drink options and bind that to idgroup
I'm missing something but can't figured out. Any help is appreciated.
