Infralution Support

[terryharrison]

I have a virtual list hooked up to the virtual connection and I am trying to retrieve the selected data. The virtual connection retrieves two columns from the datatable and I set displaymember to show one of them. It doesn't honor that choice but will only display whatever is the first column in the choice. If I bind a regular dataset to the virtual list I can retrieve the info by CType(VirtualListBox2.SelectedItem, DataRowView).Item(0)) but when it is bound to the virtual connection this won't work. Can someone tell me how to display one column and then retrieve the second value column and how to do that from the virtual connection setup.
Thanks

[Infralution]

The VirtualListBox control doesn't currently support binding using the DisplayMember property to lists that use the ITypedList interface - which is what VirtualRecordsets use to allow access to the fields . This is an oversight on our behalf - most of our customers are using Virtual Tree which does support binding via ITypeList. We will fix this in the next release.

Fortunately there is a fairly way to do this without setting the DisplayMember. You simply handle the GetItemText event for the VirtualListBox and set the text to display explicitly eg

[terryharrison]

Ok I understand that so now I can fill the list with the correct column - how do I retrieve the column value not displayed when the user double clicks a row? The column I am displaying is the part sku for example and I want to let the user double click on the displayed sku but I want to retrieve the other column for the specific part lookup.

[Infralution]

The SelectedItem is the VirtualRecord - so your if the other column was called "id" and contained a string value the code would be:

[terryharrison]

A new problem has popped up. I can bind the data from the virtual recordset to the virtual listbox and it works very well. I can intercept the click and the double click event and get the correct data. However when the top row of data is clicked it selects as normal - colors the background inverts the text, etc. If any other row below the top row is selected it does not display as being selected although the click and double click action will retrieve the correct info. I really need the row to show it is selected. Am I missing something in the set up?

Thanks

[Infralution]

That sounds very odd. I've tried replicating this (bound a VirtualListBox control to a VirtualData recordset in the way described in previous posts) but could not see the problem you are getting.

Are handle the Click event or overriding the VirtualListBox.OnClick method. If overriding make sure that you call the base method.

If you could you create a small sample program which shows the problem and email it to us at support@infralution.com that would help us track down the issue.
_________________
Infralution Support

[Infralution]

Thanks for the sample project - it made it easy to track down the problem. The issue is actually with the way you initialize the VirtualRecordset. Your code does the following: