BAQ Combo Box: Display multiple columns

Hello!
I have a BAQ combo box, and an underlying BAQ that pulls in a nvarchar description and an int ID.

Currently, the BAQ dropdown is only displaying the ID column, but I would like it to display both columns. Can the DisplayMember property under BAQ information on the control be set to display more than one column?

As far as I know you cannot specify multiple display columns. Even if you could, I would recommend you create a calculated field in your BAQ, that combines the two fields, and then make that calculated field your display member. This way if you ever want to change what it displays, it is a BAQ calculated field change vs. opening a customization.

3 Likes

Yes, we can show multiple columns in BAQ Combobox. Customization code is as below. You need to bind BAQ Combo using code.

call below method where do you want it to fill dropdown:

private void FillDropDownNames(string TNo)
{
DynamicQueryAdapter dynQryAD1 = new DynamicQueryAdapter(oTrans.EpiBaseForm);
dynQryAD1.BOConnect();
QueryExecutionDataSet qds1 = dynQryAD1.GetQueryExecutionParametersByID(“ExtBAQ_Names”);
qds1.ExecutionParameter.Clear();
string TNo = TNo;
qds1.ExecutionParameter.AddExecutionParameterRow(“TNo”, TNo, “nvarchar”, false, Guid.NewGuid(), “A”);
dynQryAD1.ExecuteByID(“ExtBAQ_Names”, qds1);
if(dynQryAD1.QueryResults.Tables[“Results”].Rows.Count > 0)
{
cmbNames.DataSource = dynQryAD1.QueryResults.Tables[“Results”];
cmbNames.DisplayMember = “Names_Name”;
cmbNames.ValueMember = “Names_Id”;
cmbNames.DataBind();
}
}