Code,Name to be displayed only once

Question

Hi I have data like below and i want Code,Name to be displayed only once CODE NAME DEBIT CREDIT C01 ABC 500 C01 ABC 200 C01 ABC 200 C01 ABC 200 Thanks

Amit Mohanty · Answer

If you want sql query, try this WITH CTE AS ( SELECT CODE, NAME, DEBIT, CREDIT, ROW_NUMBER() OVER (PARTITION BY CODE, NAME ORDER BY (SELECT NULL)) AS RowNum FROM YourTable ) SELECT CASE WHEN RowNum = 1 THEN CODE ELSE '' END AS CODE, CASE WHEN RowNum = 1 THEN NAME ELSE '' END AS NAME, DEBIT, CREDIT FROM CTE;

Jignesh Kumar · Answer

Hello Ramco, Please use this once, var data = new List { new { Code = "C01", Name = "ABC", Debit = 500, Credit = (int?)null }, new { Code = "C01", Name = "ABC", Debit = (int?)null, Credit = 200 }, new { Code = "C01", Name = "ABC", Debit = 200, Credit = (int?)null }, new { Code = "C01", Name = "ABC", Debit = 200, Credit = (int?)null }, }; var processedData = data .Select((row, index) => new { Code = index == 0 || (row.Code != data[index - 1].Code) ? row.Code : string.Empty, Name = index == 0 || (row.Name != data[index - 1].Name) ? row.Name : string.Empty, row.Debit, row.Credit }) .ToList(); Console.WriteLine($"Code 	Name 	Debit	Credit"); foreach (var row in processedData) { Console.WriteLine($"{row.Code}	{row.Name}	{row.Debit}	{row.Credit}"); } This will give you resulst as below, Code Name Debit Credit C01 ABC 500 200 200 200

Jaish Mathews · Answer

To display Code and Name only once for each group of data (based on Code and Name ), you can group the data by Code and Name and suppress repeated values in their columns. This is commonly done in reporting or rendering grouped data in a grid-like format. Here’s how you can achieve this in C# using LINQ and Blazor : Data Example public class Transaction { public string Code { get; set; } public string Name { get; set; } public decimal? Debit { get; set; } public decimal? Credit { get; set; } } Data Preparation var transactions = new List { new Transaction { Code = "C01", Name = "ABC", Debit = 500, Credit = null }, new Transaction { Code = "C01", Name = "ABC", Debit = null, Credit = 200 }, new Transaction { Code = "C01", Name = "ABC", Debit = 200, Credit = null }, new Transaction { Code = "C01", Name = "ABC", Debit = 200, Credit = null }, }; Group and Suppress Repeats var groupedTransactions = transactions .Select((t, index) => new { Code = index == 0 || transactions[index - 1].Code != t.Code ? t.Code : null, Name = index == 0 || transactions[index - 1].Name != t.Name ? t.Name : null, t.Debit, t.Credit }).ToList(); Render in Blazor Here’s an example of how to render the grouped data in a Blazor component: Code Name Debit Credit @foreach (var item in groupedTransactions) { @item.Code @item.Name @item.Debit @item.Credit } Output Table Code Name Debit Credit C01 ABC 500 200 200 200 This approach groups the data and suppresses repeated values for Code and Name , while preserving the full detail of the transactions. Let me know if you need additional clarifications!

Code,Name to be displayed only once

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)