LINQ how to concatenate 2 db columns to display in dropdownlist
- by Simke Nys
I'm trying to concatenate product_name with product_prize_kg by using LINQ so I can display it as one field in a dropdownlist. When I try to do this I get the following error.
value of type 'system.collections.generic.list(of anonymous type )'
cannot be converted to ...
My code is like this:
Public Function selectAll() As List(Of tblProduct)
Dim result = From product In dc.tblProducts
Select New With
{
Key .productID = product.pk_product_id,
Key .productNameKg = Convert.ToString(product.product_name) & " " & Convert.ToString(product.product_price_kg)
}
Return result.ToList()
End Function
This is the dropdownlist that I want to fill.
<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="ObjectDataSource1" DataTextField="productNameKg"
DataValueField="productID">
</asp:DropDownList>
Thanks
Grtz Simke
