Clever Geek Handbook

Hide columns in LookUpEdit (DevExpress)

I am trying to hide all columns of a LookUpEdit (3rd party DevExpress) control except DisplayMember (its functionality should look like a standby ComboBox)

Properties. The DataSource is a DataTable, so when I want to access each column to hide it, the programs throw a Null ref exception.

What am I doing wrong?

Code:

If TypeOf Me.Properties.DataSource Is DataTable Then
     Me.Properties.PopulateColumns()
     Dim dt As DataTable = CType(Me.Properties.DataSource, DataTable)

     For Each column As DataColumn In dt.Columns
         If Me.Properties.Columns(column.ColumnName) IsNot Nothing AndAlso column.ColumnName IsNot Me.DisplayMember Then
                Me.Properties.Columns(column.ColumnName).Visible = False
         End If
     Next

End If
+3


source to share


3 answers


Instead of hiding columns, you can add just one column:

lookUpEdit1.Properties.Columns.Add(New LookUpColumnInfo(lookUpEdit1.Properties.DisplayMember))


Here's an example:

Dim dataTable As New DataTable()

dataTable.Columns.Add("ID", Type.GetType("System.Int32"))
dataTable.Columns.Add("Name", Type.GetType("System.String"))
dataTable.Columns.Add("Description", Type.GetType("System.String"))

dataTable.Rows.Add(0, "Name0", "Description0")
dataTable.Rows.Add(1, "Name1", "Description1")
dataTable.Rows.Add(2, "Name2", "Description2")

lookUpEdit1.Properties.DataSource = dataTable
lookUpEdit1.Properties.DisplayMember = "Name"
lookUpEdit1.Properties.ValueMember = "ID"

lookUpEdit1.Properties.Columns.Add(New LookUpColumnInfo(lookUpEdit1.Properties.DisplayMember))
+4


source


To hide a specific column in the devexpress lookupedit control, follow these steps.



lookUpEdit1.Properties.PopulateColumns();
lookUpEdit1.Properties.Columns[**index**].Visible = false;
+1


source


For deexpress 18.2.8

I am using the following code to hide a column:

using (DataTable dt = rst.ResultSet.Tables[0].Copy())
{
    dt.Columns["Unit_ID"].ColumnMapping = MappingType.Hidden;
    ddlUnitOfMeasurement.Properties.DataSource = dt.DefaultView;
    ddlUnitOfMeasurement.Properties.ValueMember = "Unit_ID";
    ddlUnitOfMeasurement.Properties.DisplayMember = "Unit_Name"; 
}
0


source






More articles:


All Articles