Search code examples
c#.netwinformscomboboxvaluemember

How to remove values from valuemember in combobox?

The following code updates populates the combobox cmbBox1.

OracleDataAdapter oraAdapter = new OracleDataAdapter(oraCmd);
DataSet oraDataSet = new DataSet();
oraAdapter.Fill(oraDataSet);

cmbBox1.ValueMember = oraDataSet.Tables[0].Columns["Val1"].ToString();

cmbBox1.DisplayMember = oraDataSet.Tables[0].Columns["Disp1"].ToString();
cmbBox1.DataSource = oraDataSet.Tables[0];

I need help in figuring out how to remove few values to from the cmbBox1. Do I remove values from the ValueMember/DisplayMember or is there any way to hide values in cmbBox1? Please advise

Solution

  • You can use DataView

    DataView dv = oraDataSet.Tables[0].DefaultView;
dv.RowFilter = "Code NOT IN (1,2,3)";

cmbBox1.ValueMember = oraDataSet.Tables[0].Columns["Val1"].ColumnName;

cmbBox1.DisplayMember = oraDataSet.Tables[0].Columns["Disp1"].ColumnName;
cmbBox1.DataSource = dv;