UltraCombo ItemNotInList event | Infragistics Forums

995

UltraCombo ItemNotInList event

Glenn Robbins posted over 13 years ago

I have a bound combo to a SQL Server tinyint field and a list of items to chose from populated by setting the databindings to a dataview with a tinyint value field and string display field.

Selecting an item in the list is firing the ItemNotInList event though. Very weird: in the event, capturing the value field shows the correct new value and after the event , the focus changes and the dataset isupdated with the correct value. If I select the previously chosed value (that is, the value of the bound record), then the event does not fire.

If indeed I do type an invalid value, the event shows the bad text as the value, the old value is restored, and the dataset is not updated.

Parents

469350

Offline Mike Saltzman posted over 13 years ago

Hi,

There's no such thing as a TinyInt in Dotnet. So what's the DataType of the grid column that is bound to the TinyInt field? It's probably Int16 or something like that.

What version of the controls are you using?

Are you absolutely certain that the field in the DropDown is using the same DataType as the field in the grid?
Cancel
Reply

Cancel
995

Offline Glenn Robbins posted over 13 years ago in reply to Mike Saltzman

this is a stand alone combo (ultracomboeditor), not in a grid. Bound to a field in typed dataset, the tinyint translates to a byte datatype. I am just setting the combo datasource to a datatable, not doing anything to set the combo's grid fields. Version 2110.2 Thanks.
Cancel
Reply

Cancel
469350

Offline Mike Saltzman posted over 13 years ago in reply to Glenn Robbins

Okay, sorry, I assumed it was a grid.

But anyway, this should work fine as long as you are sure that the Value of the control is being set to a Byte and also the DataValues of the items on the list are also Bytes.

I know that this works with other data types, so there's no reason why Bytes should be any different.

sunibla said:
Version 2110.2

Ummm... there is no such version. I assume this is a typo and you mean 2010.2?
Cancel
Reply

Cancel
995

Offline Glenn Robbins posted over 13 years ago in reply to Mike Saltzman

I have updated my procedure to explicitly convert the identity tinyint field to tinyint and it now comes into the DataTable as Byte. However, my combo problem still exists: selecting a new value fires the NotInListEvent though the proposed value in the event is correct and the dataset is updated correctly. Again, if then selecting the original value (which matches the bound field existing value) the event is not fired. To reproduce, I would populate a combo with a DataTable with a byte DataValue and string DataMember and bind the combo to a Byte column in the record datasource. The Combo works fine with int DataTypes. Thanks.
Cancel
Reply

Cancel

Reply

469350

Offline Mike Saltzman posted over 13 years ago in reply to Glenn Robbins

Hi,

The combo does not know anything about the back end, it only knows about the DataType of the field you are binding to. So if both the column on the list and the values you are binding to are the same type, it should work.

Just to be sure, I tested this out using Integer (which I am sure work, since this is what most people use for the ValueMember) and then I tested it with Byte, just in case Byte behaves oddly for some reason. They both work perfectly fine for me and the ItemNotInList event never fires when I pick an item from the list.

I also tested this using both UltraCombo and UltraComboEditor and they both work the same.

I'm attaching my sample here so you can see if it gives you the same results.

WindowsFormsApplication2.zip
Cancel
Reply

Cancel

Children

No Data