combobox绑定dataset，但是点击combobox下拉菜单的时候什么都没有？C# codeprivate void comboBox商品品牌_S
combobox绑定dataset，但是点击combobox下拉菜单的时候什么都没有？
C# codeprivate void comboBox商品品牌_SelectedIndexChanged(object sender, EventArgs e) { string source = "server=(local)\\ SQLEXPRESS;" + "Integrated Security=True;" + "Database=Goods"; using (SqlConnection conn = new SqlConnection(source)) { conn.Open(); string select = "select * from RestGoods"; SqlDataAdapter da = new SqlDataAdapter(select, conn); //SqlCommandBuilder bu = new SqlCommandBuilder(da); DataSet ds = new DataSet(); da.Fill(ds, "RestGoods"); comboBox商品品牌.DataSource = ds.Tables["RestGoods"]; comboBox商品品牌.DisplayMember = "商品品牌"; comboBox商品品牌.ValueMember = "商品品牌"; } }
大虾们帮我看看
[解决办法].DataBind()
[解决办法]comboBox商品品牌.DataBind()
[解决办法]没绑定撒
[解决办法]winform的吧
你看看DataSet里面有没有数据
还有“商品品牌”是RestGoods表中的字段么？
[解决办法]设个断点到这里，或者
private void comboBox商品品牌_SelectedIndexChanged(object sender, EventArgs e)
{
string source = "server=(local)\\ SQLEXPRESS;" + "Integrated Security=True;" + "Database=Goods";
using (SqlConnection conn = new SqlConnection(source))
{
conn.Open();
string select = "select * from RestGoods";
SqlDataAdapter da = new SqlDataAdapter(select, conn);
//SqlCommandBuilder bu = new SqlCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, "RestGoods");
if(ds!=null&&ds.tables.count>0&&ds.tables[0].rows.count>0)
{
messagebox.show(ds.Tables["RestGoods"].rows.count.tostring());
}
else
{
messagebox.show("没有数据");
}
}
}
[解决办法]一般我会怎么写.
直接查列名效率也高.
还有你这个功能写在SelectedIndexChanged事件第一次肯定不妥.建议写到LOAD事件里.
private void comboBox商品品牌_SelectedIndexChanged(object sender, EventArgs e)
{
string source = "server=(local)\\ SQLEXPRESS;" + "Integrated Security=True;" + "Database=Goods";
using (SqlConnection conn = new SqlConnection(source))
{
conn.Open();
string select = "select 列名 from RestGoods"; //列名为你需要绑定到COMBOBOX的列值.
SqlDataAdapter da = new SqlDataAdapter(select, conn);
//SqlCommandBuilder bu = new SqlCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, "RestGoods");
comboBox商品品牌.DataSource = ds.Tables["RestGoods"];
comboBox商品品牌.DataBind();
}
}
[解决办法]这个用控件做比较简单
先用sqlDataAdapter创建SlecetCommand，然后创建DataSet，在ComBox里DataSource里选择DataSet.表名，在DisplayMember选择列名
在Formload里写上sqlDataAdapter.Fill(DataSet)就可以了
