Group By Two Columns using the Linq query

[coder]

Hello,

can anyone help me with this query?

dt.AsEnumerable.GroupBy(Function(r) r("ContractNumber").ToString).Select(Function(g) dtResult.LoadDataRow({g.Key,g.Where(Function(r) r("Status").ToString="Not-Submitted" OrElse r("Status").ToString="Submitted" ).Count,g.Where(Function(r) r("Status").ToString="Submitted").Count,g.Where(Function(r) r("Status").ToString="Not-Submitted").Count, (100*(g.Where(Function(r) r("Status").ToString="Submitted").Count/g.Where(Function(r) r("Status").ToString="Not-Submitted" OrElse r("Status").ToString="Submitted" ).Count)).ToString+"%" },False)).CopyToDataTable

I am trying to add another column name with the **Contract Number** which is called “Name”

so when it’s written the ContractNumber data, I need it to write the Name also.

The contract number and Name are related to each other.

Thank you

.

[Anil_G (Anil Gorthi)]

@coder

You can use r("Contractnumber").ToString + r("Name").ToString

Cheers

[coder]

Thank you for your reply, but it’s not working.
i didn’t get the result of the name

[Anil_G (Anil Gorthi)]

@coder

Can you please explain what is not working and what you are getting and what you need

you asked for group by…so you want the data also to be visible in output?

cheers

[coder]

this is the output, but I wanted it to be in the Name column.

[coder]

I want this output

[Anil_G (Anil Gorthi)]

@coder

If you need to add it as separate column then try this

dt.AsEnumerable.GroupBy(Function(r) r("ContractNumber").ToString).Select(Function(g) dtResult.LoadDataRow({g.Key,g.First()("Name").ToString,g.Where(Function(r) r("Status").ToString="Not-Submitted" OrElse r("Status").ToString="Submitted").Count,g.Where(Function(r) r("Status").ToString="Submitted").Count,g.Where(Function(r) r("Status").ToString = "Not-Submitted").Count, (100*(g.Where(Function(r) r("Status").ToString="Submitted").Count/g.Where(Function(r) r("Status").ToString = "Not-Submitted" OrElse r("Status").ToString="Submitted" ).Count)).ToString+"%" },False)).CopyToDataTable

cheers

[coder]

Its working , Thank you for your help