K
Karthik
Hi,
Can any one help me to change the below code to VB .Net?
var(query = From row In dtInvoice.AsEnumerable())
group row by new { InvNo = row.Field< string >( "InvNo" ),
EmpUNID = row.Field< decimal >( "EmployeeUNID" )} into grp
OrderBy(grp.Key.InvNo)
select new
{
Key = grp.Key,
InvNo = grp.Key.InvNo,
EmpID = grp.Key.EmpUNID,
TotalCost = grp.Sum(r => r.Field< decimal >( "TotalCost" )),
TotalRev = grp.Sum(r => r.Field< decimal >( "TotalRev" ))
}
Thanks and regards,
Karthik.C
Can any one help me to change the below code to VB .Net?
var(query = From row In dtInvoice.AsEnumerable())
group row by new { InvNo = row.Field< string >( "InvNo" ),
EmpUNID = row.Field< decimal >( "EmployeeUNID" )} into grp
OrderBy(grp.Key.InvNo)
select new
{
Key = grp.Key,
InvNo = grp.Key.InvNo,
EmpID = grp.Key.EmpUNID,
TotalCost = grp.Sum(r => r.Field< decimal >( "TotalCost" )),
TotalRev = grp.Sum(r => r.Field< decimal >( "TotalRev" ))
}
Thanks and regards,
Karthik.C