使用C#
从SQL数据库读取其内容时,我如何填充Combobox。例如
fillcombo(" displayMamber"," valuemember"," columnname"," tableName"(;
或
fillcombo(" columnname"," tableName"(;
很难说您到底被卡住了,但是您应该能够开始这样的东西:
public static void Bind<T>(ComboBox combo, List<T> Models, string Name, string Value)
{
var binding = new BindingSource();
binding.DataSource = Models;
combo.DataSource = binding.DataSource;
combo.DisplayMember = Name;
combo.ValueMember = Value;
}
假设winforms,我的按钮每个都有一个类似的事件:
private void button2_Click(object sender, EventArgs e)
{
List<State> states = new List<State>();
using (var dc = new CustomersEntities())
{
states = dc.States.ToList();
}
Bind<State>(comboBox1, states, "StateName", "Id");
}
这不是一个理想的模式,但是对于入门而言,它可以完美地发挥作用。
您可能感兴趣的是一个通用存储库,并围绕它构建通用库,以便您可以拥有看起来更像:
的方法public static void GetCities()
{
comboBoxCities.Bind<City>(repository.AllCities(), x => x.Name, x.Id);
}
,但这并没有真正涉及一两个问题。