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
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
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".
In the select Line only allow me to select one column instead of the three column that I need.
What's the problem?