DataSet ds=new DataSet();
com.Fill(ds,"temp");
cb.DataSource=ds.Tables["temp"].DefaultView;
cb.DisplayMember=Member;
com.Dispose();
this.dbcn.Close();
com.Fill(ds,"temp");
cb.DataSource=ds.Tables["temp"].DefaultView;
cb.DisplayMember=Member;
com.Dispose();
this.dbcn.Close();
if(cb.SelectItem.Text != '全部')
{
WHERE NAME = "'"+cb.SelectItem.Text+"'"
}
com.Fill(ds,"temp");
DataRow dr = ds.Tables["temp"].NewRow();
dr[Member] = "全部";
ds.Tables["temp"].Rows.Add(dr);
cb.DataSource=ds.Tables["temp"].DefaultView;
cb.DisplayMember=Member;
com.Dispose();
this.dbcn.Close();
private void cb_SelectedIndexChanged(object sender, System.EventArgs e)
{
if (this.cb.SelectedItem.ToString() == "全部")
{
}
else
{
}
}
DataSet ds=new DataSet();
com.Fill(ds,"temp");//增加一行“全部”
DataRow dr = ds.Tables["temp"].NewRow();
dr["Member"] = "全部";
dr["ValueMember"] = "给个值"; //Member、ValueMember是字段名
ds.Tables["temp"].Rows.Add(dr);cb.DataSource=ds.Tables["temp"].DefaultView;
cb.DisplayMember="Member";
cb.ValueMember = "ValueMember";
com.Dispose();
this.dbcn.Close();
{
//代码
}