Can some body review this LINQ and let me know how I can get this result done,
Dim lnqVendors = From Rows As UltraGridRow In Me.grdiList.Rows _
Where Rows.Cells("CheckCol").Value = True _
Select Rows.Cells("PayeeFK").Value, Rows.Cells("PaymentDate").Value, Rows.Cells("PayeeAddressesFK").Value
What's the problem?
In the select Line only allow me to select one column instead of the three column that I need.
Oh, you're right.
In c# you have to write:
select new {Payee = Rows.Cells("PayeeFK").Value, PaymentDate = Rows.Cells("PaymentDate").Value, PayeeAddresses = Rows.Cells("PayeeAddressesFK").Value}
probably the same for vb.
To maker things clear, don't name your temporary var "Rows" but "row".
Thank,, this is in VB let see if I got the values, so far does not get any error in syntax.
Where Row.Cells("CheckCol").Value = True _
Distinct