使用LINQ生成ComboBox.ItemsSource时出现DisplayMemberPath和SelectedValuePath问题 [英] DisplayMemberPath and SelectedValuePath issue while using LINQ to generate ComboBox.ItemsSource
问题描述
XAML代码:
<ComboBox Name="comboBoxAccountName" DisplayMemberPath="AccountName" SelectedValuePath="AccountID" />
ItemComboBoxAccount类:
ItemComboBoxAccount class:
public class ItemComboBoxAccount
{
private int accountID;
private String accountName;
public int AccountID
{
get { return accountID; }
set { accountID = value; }
}
public String AccountName
{
get { return accountName; }
set { accountName = value; }
}
}
LINQ查询:
comboBoxAccountName.ItemsSource = (from accounts in dataContext.Accounts
select new { accountName = accounts.accountName, accountID = accounts.accountID }
).AsEnumerable()
.Select(x => new ItemComboBoxAccount { AccountID = x.accountID, AccountName = x.accountName })
.ToList();
组合框不显示任何项目,帐户"中的行与帐户一样多,但行仍为空白.我要显示AccountName.
ComboBox shows no items, there are as many rows as accounts in Accounts, but rows remain blank. I want display AccountName.
推荐答案
好,对于实体,我将使用lambda表达式设置项目来源.这样,我可以从一种方法动态填充组合框,而不必使用数据绑定.
Well,for entities I would use lambda expression to set the item source. That way I can dynamically populate the combo box from one method without having to use data binding.
我使用sql,然后在context.tt文件中创建数据库的实例.
I use sql and then create a instance of the db in the context.tt file.
操作以下内容以供自己使用:
Manipulate the following for your own use:
将使用"BankEntities"来表示数据库实体.
Going to use "BankEntities" to represent the db entity.
尝试:
combobox.itemsource = BankEntities.instance.BankAccounts.where(x => x.AccountName == x.AccountName).ToList();
或
combobox.itemsource = BankEntities.instance.BankAccounts.where(x => x.AccountId == x.AccountId).ToList();
这篇关于使用LINQ生成ComboBox.ItemsSource时出现DisplayMemberPath和SelectedValuePath问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!