Add One Or Many Rows To a List Property of a Table In a DataGrid?
I currently have a Data Grid for a table of Staff members. Each staff member can have 0, 1 or many Clients attached to them. Currently I am trying to display them in a ComboBox in the Details View to allow the user to select them.
I have several questions:
1: How I can bind the client to the parent list property?
2. Is there a better way then to use the Add a New Row function with a ComboBox to attached numerous Clients to a Staff member?
3. Instead of having a details view/sub grid, could I instead somehow not have to use a Subgrid and allow the user to add multiple Clients in the main data grid via a combobox with multiple selects? If so how would multiple selects work with the database in terms of telling it to add/delete many people at once?
public class StaffModel:PersonModel{
public List<ClientModel>? Clients { get; set; }
public StaffModel() : base() { }
}
My Staff Xaml page:
<dataGrid:SfDataGrid
x:Name="MainDataGrid"
Grid.Row="2"
Grid.ColumnSpan="2"
AddNewRowPosition="Top"
AllowEditing="True"
AutoGenerateColumns="False"
AutoGenerateRelations="True"
ColumnWidthMode="Star"
GridLinesVisibility="Both"
Loaded="OnMainGridLoad">
<dataGrid:SfDataGrid.Columns>
<dataGrid:GridTextColumn HeaderText="First Name" MappingName="FirstName" />
<dataGrid:GridTextColumn HeaderText="Last Name" MappingName="LastName" />
<dataGrid:GridTextColumn MappingName="Nickname" />
<dataGrid:GridTextColumn MappingName="Phone" />
<dataGrid:GridTextColumn MappingName="EmailAddress" />
</dataGrid:SfDataGrid.Columns>
<dataGrid:SfDataGrid.DetailsViewDefinition>
<dataGrid:GridViewDefinition RelationalColumn="Clients">
<dataGrid:GridViewDefinition.DataGrid>
<dataGrid:SfDataGrid
x:Name="ClientsDataGrid"
AddNewRowPosition="Top"
AllowDeleting="True"
AllowEditing="True"
AutoGenerateColumns="False"
ColumnWidthMode="Star"
GridLinesVisibility="Both">
<dataGrid:SfDataGrid.Columns>
<dataGrid:GridTemplateColumn HeaderText="Client" MappingName="Id">
<dataGrid:GridTemplateColumn.CellTemplate>
<DataTemplate>
<TextBlock
VerticalAlignment="Center"
Text="{Binding FullName}"
TextAlignment="Center" />
</DataTemplate>
</dataGrid:GridTemplateColumn.CellTemplate>
<dataGrid:GridTemplateColumn.EditTemplate>
<DataTemplate>
<editors:SfComboBox
x:Name="comboBox"
Width="250"
ItemsSource="{Binding DataContext.Clients, ElementName=RootGrid}"
PlaceholderText="Select a client"
SelectedItem="{Binding Clients.Client, Mode=TwoWay}"
SelectionMode="Multiple" />
</DataTemplate>
</dataGrid:GridTemplateColumn.EditTemplate>
</dataGrid:GridTemplateColumn>
</dataGrid:SfDataGrid.Columns>
</dataGrid:SfDataGrid>
</dataGrid:GridViewDefinition.DataGrid>
</dataGrid:GridViewDefinition>
</dataGrid:SfDataGrid.DetailsViewDefinition>
</dataGrid:SfDataGrid>
Alfred Smith,
|
Queries |
Responses |
||
|
How I can bind the client to the parent list property? |
C# Code snippet to
Bind the relationship client to Parent (staff):
2. In XAML, define a GridViewDefinition and
set the RelationalColumn property to the name of the child
collection (e.g., "ClientDetails")
|
||
|
Is there a better way then to use the Add a New Row function with a ComboBox to attached numerous Clients to a Staff member? |
when adding a new client, you can retrieve the parent StaffId and assign it to the new client's Id to maintain the relationship using AddNewRowInitiating event.
C# code snippet to retrieve the parent ID:
|
||
|
Instead of having a details view/sub grid, could I instead somehow not have to use a Subgrid and allow the user to add multiple Clients in the main data grid via a combobox with multiple selects? If so how would multiple selects work with the database in terms of telling it to add/delete many people at once? |
Without using a ComboBox column, you can use the above approach. This will help display the data more effectively, and it also supports multiple operations such as: Multiple selection Delete operations by enabling AllowDeleting property, and Adding new rows using AddNewRow or adding adding new data manually . |
Image Reference:
|
|
UG Link: MasterDetailsView
Find the sample demo in the attachment and let us know if
you have any concerns on this.
If this post is helpful, please consider Accepting it as the solution so that
other members can locate it more quickly.
Attachment: Sample_6c108842.zip
Hi thanks for the reply I played around with the code you supplied but having looked at it, I think having the DetailsView/Grid is unneeded.
I would like to do the following instead:
- Keep everything on the same grid without a details grid.
- There would be a template column that in the cell view shows a button that shows the amount of Clients associated with the staff member.
- When the user clicks the button, it then displays a combobox that supports multiple selection in the edit view.
These images represent what I am trying to achieve:
Image 1 - Before going into edit mode
Image 2 - After click on the button
