How to use commas after three digits next to numbers using LINQ Query

Question

I want to separate the numeric values ​​in my query with commas for ease of viewing. Is it possible? example
1000.00 I want to see 1,000.00
10000.00 I want to see 10,000.00
100000.00 I want to see 100,000.00

//Query
  var data = (from a in _context.tbl_BankTransactions
              join b in _context.tbl_Banks
              on a.bankid equals b.bankid
            
              where a.Date >= _fitsdate
              where a.Date <= _lastdate
              select new
              {
                  bankTransctionid = a.bankTransctionid,
                  BankName = b.BankName,
                  AccountNo = b.AccountNo,
                  debited = (decimal?)a.debited ?? 0,
                  credited = (decimal?)a.credited ?? 0,
                  Date = a.Date
            
              }).ToList();

I want to see this data debited & credited value commas after three digits

Answer 1

Hi jewel,

You could use custom numeric format strings https://learn.microsoft.com/en-us/dotnet/standard/base-types/custom-numeric-format-strings#the--custom-specifier-2

debited = ((decimal?)a.debited ?? 0).ToString("#,##0.00"),
credited = ((decimal?)a.credited ?? 0).ToString("#,##0.00"),

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".  Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

This answer has been deleted because of duplication.

Answer 3

How to use commas after three digits next to numbers using LINQ Query

The type of debited and credited is decimal?. You cannot see them in "commas after three digits" format as long as type is decimal (same for short, int, long, float and double). Linq does not matter.

To see the values of debited and credited in "commas after three digits" format you will have to convert them to string with proper formatting.

Please refer to the following Microsoft documents for details of standard and cusrom numeric format strings:

Standard numeric format strings

Custom numeric format strings

Answer 4

debited & credited are binary values. You don’t show the code that displays them. In this code you should add formatting. Or convert to strings in the query

select new
              {
                  bankTransctionid = a.bankTransctionid,
                  BankName = b.BankName,
                  AccountNo = b.AccountNo,
                  debited = ((decimal?)a.debited ?? 0).ToString(“D”),
                  credited = ((decimal?)a.credited ?? 0).ToString(“D”),
                  Date = a.Date
            
              })