LLBLGEN 3.0

I have two comboboxes menu sub group and menu group which I am populating using typedlist as per below code. works absolutely fine and I got this easily

var adapter = new DataAccessAdapter(); IRelationPredicateBucket filter = menugroupsubgroup.GetRelationInfo(); filter.PredicateExpression.Add(MenusubgroupFields.Flag == StandardFlag.recordvalidflag); filter.Relations.Add(MenusubgroupEntity.Relations.MenugroupEntityUsingMenugroupId); ISortExpression sorter = new SortExpression(MenusubgroupFields.Description | SortOperator.Ascending); adapter.FetchTypedList(menugroupsubgroup.GetFieldsInfo(), menugroupsubgroup, filter,0, sorter,false); cmbmenusubgroupid.DataSource = menugroupsubgroup; cmbmenusubgroupid.ValueMember = "MENUSUBGROUPID"; cmbmenusubgroupid.DisplayMember = "MENUSUBGROUPDESCRIPTION"; cmbmenusubgroupid.SelectedIndex = -1;

            cmbmenugroupid.BindingContext = new BindingContext();
            cmbmenugroupid.DataSource = menugroupsubgroup;
            cmbmenugroupid.ValueMember = "MENUGROUPID";
            cmbmenugroupid.DisplayMember = "MENUGROUPDESCRIPTION";
            cmbmenugroupid.SelectedIndex = -1;

Now, When I select menu subgroup from combobox, corresponding menu group does not appear in menu group combo box. Any thing extra to be done ? I mean menugroup related to selected subgroup only to be displayed

Do you mean you want the second combo box to display the list filtered according to the selection in the first combo box...? If so you will have to do this manually, there is no inbuilt behavior to do this.

Matt

MTrinder wrote:

Do you mean you want the second combo box to display the list filtered according to the selection in the first combo box...? If so you will have to do this manually, there is no inbuilt behavior to do this.

Matt

Exactly. You got that right. But even if i have to do manally how do I do it was I was not able to understand

You can handle the selectedIndexChanged of the first DDL and there you should populate the second DDL filtered by the selected value of the first DDL.

This can also be managed at design, by using LLBLGenProDataSource and SelectParameters (web app.) or by using a BindingSource controls (windows app.).

Either way you should check the databinding examples posted on our web site to see how master - detail databainding can be done.

Walaa wrote:

You can handle the selectedIndexChanged of the first DDL and there you should populate the second DDL filtered by the selected value of the first DDL.

This can also be managed at design, by using LLBLGenProDataSource and SelectParameters (web app.) or by using a BindingSource controls (windows app.).

Either way you should check the databinding examples posted on our web site to see how master - detail databainding can be done.

True. Had tried this. Though it worked there was some minor issue. Let me check and post the problem I faced by using above method

Walaa wrote:

You can handle the selectedIndexChanged of the first DDL and there you should populate the second DDL filtered by the selected value of the first DDL.

This can also be managed at design, by using LLBLGenProDataSource and SelectParameters (web app.) or by using a BindingSource controls (windows app.).

Either way you should check the databinding examples posted on our web site to see how master - detail databainding can be done.

Before posting on forum I had tried this in selectedIndexChanged

var datasourcemenugroup = new EntityCollection(new MenugroupEntityFactory()); filtermenusubgroup.Clear(); filtermenusubgroup.Add(MenusubgroupFields.MenusubgroupId == int.Parse(cmbmenusubgroupid.SelectedValue.ToString())); bucketmengroup.PredicateExpression.Add(filtermenusubgroup); bucketmengroup.Relations.Add( MenugroupEntity.Relations.MenusubgroupEntityUsingMenugroupId); bucketmengroup.PredicateExpression.Add(MenugroupFields.Flag == StandardFlag.recordvalidflag); adaptermengroup.FetchEntityCollection(datasourcemenugroup, bucketmengroup, 0, new SortExpression( MenugroupFields.Description | SortOperator.Ascending)); cmbmenugroupid.DataSource = datasourcemenugroup; cmbmenugroupid.ValueMember = "MENUGROUPID"; cmbmenugroupid.DisplayMember = "DECRIPTION"; cmbmenugroupid.SelectedIndex = -1;

Now, this works fine. Problem is, I dont want the code to go into this loop when menusubgroup is not selected or invalid value is entered. Because I get error " on form load" error Message: at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at System.Int32.Parse(String s)

Now, When I try adding before "var" any of the following code Nothing gets loaded in combo if(cmbmenusubgroupid.SelectedIndex==0) return; if(cmbmenusubgroupid.SelectedIndex==-1) return;

For testing purpose I again tried

var index = int.Parse(cmbmenusubgroupid.SelectedValue.ToString()); MessageBox.Show(Convert.ToString(index));

Now during form load it shows selected value as "ClubCentricHelper.EntityClasses.MenusubgroupEntity". once form loaded then it works right. Means during load of first combobox selectedIndexChanged is triggered which is causing the problem

I beleive this is what is causing the problem. But how do i resolve this

You have to test the value of SelectedIndex or SelectedValue when it loads the first time, then you can add a restriction to that value (like your IFs above).