Sfdatagrid group by name and id

Question

Hi Good day,I have my information as shown in sfdatagrid, I want to group it by Name and Count the unique Ids.I will be expecting and output like:Mark=2Zed=1Claire=1Name     Type                         IdsMark     Generic - 200mm     166071Mark     Generic - 200mm     166071Mark     Generic - 200mm     166108Zed       Generic - 200mm     166108Claire    Generic - 200mm     166271Claire    Generic - 200mm     166271thank you

Mohanram Anbukkarasu · Accepted Answer

Hi Mark, 

Thanks for the update.  

We are able to understand your requirement. SfDataGrid doesn’t have any direct support for this. However you can achieve this using sample level workaround by creating a custom renderer for the group caption as shown in the following code example.  

Code example :  





this.sfDataGrid1.CellRenderers["CaptionSummary"] = new GridCaptionSummaryCellRendererExt(); 
 
public class GridCaptionSummaryCellRendererExt : GridCaptionSummaryCellRenderer 
{ 
    protected override void OnRender(Graphics paint, Rectangle cellRect, string cellValue, CellStyleInfo style, DataColumnBase column, RowColumnIndex rowColumnIndex) 
    { 
        if (cellValue.Contains("Name")) 
        { 
            var dataRow = (DataRow)column.GetType().GetProperty("DataRow", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic).GetValue(column); 
 
            Group group = dataRow.RowData as Group; 
 
            string ID = string.Empty; 
            int count = 0; 
 
 
            foreach (var record in group.Records) 
            { 
                if (ID == (record.Data as Data).ID) 
                    continue; 
                ID = (record.Data as Data).ID; 
                count++; 
 
            } 
 
            cellValue = "Name : " + group.Key + "-" + count.ToString() + " " + "Items"; 
        } 
 
        base.OnRender(paint, cellRect, cellValue, style, column, rowColumnIndex); 
    } 
} 


Sample link : https://www.syncfusion.com/downloads/support/forum/165732/ze/SfDataGrid_Demo-752521234  

Please let us know if you require further assistance from us.  

Regards, 
Mohanram A.

Mohanram Anbukkarasu · Answer

Hi Mark, 

Thanks for contacting Syncfusion products.  

We are little unclear with your requirement. We regret for the inconvenience. Kindly revert to us with more details about your requirement with some image illustration if possible. It will be more helpful for us to understand your exact requirement and to provide a prompt solution. 

Regards, 
Mohanram A.

Mark Jayvee · Answer

Hi,Sorry for the confusion and failure of the description.At Column name there are 3 Mark with 2 the same id and 1 unique.What I what to do is to group it so that it will give me an answer like Mark have a count of 2. Which means it combines the id where there is duplicate.Thank u