What I am trying to do is concate two string columns and use them as one. I have seen many questions and answers on that but didn't really fix my problem.

I have a data table like the below which has 200 rows and lots of columns. What I aim to do is to have "BVM2022000000810"

Here is my code structure and what I tried

                    var Table_bill= Table.AsEnumerable()
                    .Where(r => r["Bill_ID  "] != DBNull.Value && r["Bill_ID  "] != null)
                    .GroupBy(r => new { Bill_id= r["Bill_ID  "] })
                    .Select(r => new
                    {
                        Bill_id= r.Key.Bill_id.ToString(),
                        Count = r.Count(),
                        Bill_No= r.Select(x => x["Serial"]).Concat(r.Select(x => x["Number"])),
                        //Bill_No= string.Format("{0}{1}",r.Select(x =>x["Serial"].ToString()),r.Select(x=>x["Number"]).ToString()),
 });

Thanks by now!

CodePudding user response：

can you try this code:

Bill_No= string.Join("",r.Select(x => x["Serial"])) string.Join("", r.Select(x => x["Number"]))

or this:

Bill_No= string.Join("",r.Select(x => x.Serial)) string.Join("", r.Select(x => x.Number))

Haven't checked this but seems like it should work.