Intersoft Community - WebCombo - Unbound Child combo: Row Count and adding extra rows

Unbound Child combo: Row Count and adding extra rows

andi@intersoftpt.com — Tue, 16 Feb 2010 22:47:42 GMT

Hi Ellen,

Forgive me for the mistake, yes, you can have a link unbound WebCombo with exception that, the child WebCombo should not be an unbound WebCombo. In that so, if we are trying to get the total row of the child WebCombo after the parent WebCombo is chosen, I am afraid, we cannot do that. Since, even though, we select the value in parent WebCombo, without showing the DropDownList of the child WebCombo, the data will not be loaded. That is why, the total row will become zero everytime we are trying to achieve it.

The workaround to get the total row of the child WebCombo is by using the childCombo_OnShowDropDown client side event. With this event, I believe we can use var count = combo.GetRowsCount();.

I hope it helps and please do not hesitate to ask if you have any other questions. Thank you.

Best Regards,

Andi Santoso

Unbound Child combo: Row Count and adding extra rows

ellpan — Tue, 16 Feb 2010 13:58:25 GMT

Hi Andi,

Thank you for replying. You were right about #2: I missed to set Mode.MultipleColumns.

As for #1, we can set a link and filter a dependent combo. It works fine in my case. The problem is how to get the correct number of retrieved rows after filtering.

Regards,

Ellen

Unbound Child combo: Row Count and adding extra rows

andi@intersoftpt.com — Mon, 15 Feb 2010 02:12:43 GMT

Hi Ellen,

First of all, forgive me if I am wrong, but if I am not mistaken, when we use Unbound to populate the data, we cannot create a link setting and filter another WebCombo. So my suggestion is, since the return value is in data table as well, why do not you use bound WebCombo. So instead of cBoChild.PopulateUnboundData(dt,true), you can just put the data table in to the data source, ex: cBoChild.DataSource = dt. In this way, now we can use the link setting feature and we do not need the client side even of "onAfterItemSelected". I believe it is more convenient.

For the second problem, the column is not adding because you have not set the combo mode into a multiple columns. Here a line code that you will need to add in order to do so:

WebCombo2.LayoutSettings.ComboMode = ISNet.WebUI.WebCombo.Mode.MultipleColumns;

I hope it helps and please do not hesitate to ask if you have any other questions. Thank you.

Best Regards,

Andi Santoso

Unbound Child combo: Row Count and adding extra rows

ellpan — Fri, 12 Feb 2010 13:55:06 GMT

I have cboParent and cboChild: both Unbound.

1. When a row is selected in a cboParent, I need to get number of rows in cboChild.

I put a ClientSite code in "OnAfterItemSelected" of cboParent: var combo = ISGetObject("cboChild");

Then I tried the following three functions:

a) var count = combo.GetRowsCount();

b) var count = combo.TotalRetrievedRows;

c) var count = combo.TotalRows;

In case (a), I get the total number of records of cboChild without a filter that came from cboParent.

For example: I select a row in cboParent. When I open cboChild, 12 records. The count gives 50 - what is total number of possible records for cboChild regardless of filter from cboParent.

In cases (b) and (c), I get 0. How to get the correct count?

2. I have another related problem.

I select a record in cboParent, and cboChild is populated based on that selection. I need to add an additional row to cboChild.

I populated cboChild with the following code:

----------

cboChild.DataTextField = "Description"
cboChild.DataValueField = "InstrumentGroupID"
cboChild.LayoutSettings.StatusBoxVisible = False
cboChild.Columns.Add("Description")
cboChild.Columns.Add("InstrumentGroupID")
cboChild.Columns.Add("TechniqueID")
cboChildo.Columns(2).Hidden = "True"
cboChild.Columns(2).RenderOnHidden = "True"

// then sql quiry ... and finally

cboChild.PopulateUnboundData(dt, False)

// I tried to use the following client-side code to add a row:

var combo = ISGetObject("cboChild");

var rows = combo.GetRows();
var newRow = combo.NewRow("-1");
var cells = newRow.GetCells();
cells.GetNamedItem("Description").Text = "Test1";

cells.GetNamedItem("InsturmentGroupID").Text = "-1";

rows.Add(newRow);
combo.UpdateUI();

--------

The problem is: "cells" has only one cell "Description" and the row was added as "undefined". What am I doing wrong?

Thanks.