EditorWithCombo ValueList not populating

115

Jordan Bowness posted over 13 years ago

I'm trying to set the editor for all the cells in the 1st row of my grid (which happens to be fixed). I think I'm doing this right, but for some reason I can't get the settings to pass up the valuelist to the editor...

    Private Sub grdDatasource_InitializeRow(sender As Object, e As Infragistics.Win.UltraWinGrid.InitializeRowEventArgs) Handles grdDatasource.InitializeRow
        If grdDatasource.Rows.FixedRows.Contains(e.Row) Then
            Dim theSettings As New DefaultEditorOwnerSettings
            Dim MyDropdownList As New UltraDropDown
            Dim tblList As New DataTable
            tblList.Columns.Add("ColName")
            tblList.Rows.Add("col1")
            tblList.Rows.Add("col2")
            MyDropdownList.SetDataBinding(tblList, "ColName")

            MyDropdownList.ValueMember = "ColName"
            MyDropdownList.DisplayMember = "ColName"
            theSettings.ValueList = MyDropdownList

            For Each CurrentCell As Infragistics.Win.UltraWinGrid.UltraGridCell In e.Row.Cells
                Dim mySettings As New DefaultEditorOwnerSettings()
                mySettings.ValueList = MyDropdownList
                Dim myEditor As New EditorWithCombo(New DefaultEditorOwner(mySettings))
                CurrentCell.Editor = myEditor
            Next
        End If
    End Sub

mySettings.Valuelist appears to have the proper list bound to the table, but once I create the meEditor object, passing in the mySettings, the valuelist becomes NOTHING.

Any idea why the Editor isn't picking up the Valuelist from the settings object?

469350

Offline Mike Saltzman posted over 13 years ago in reply to Jordan Bowness

Hi Jordan,

jordanbowness said:
I'm actually only going this for the FIRST row in the grid, so I haven't noticed a huge cost. That said, I will look at your suggestion. Thanks kindly.

I understand. But you may not realize that the InitializeRow event fires for each row in the grid more than once. It fires when the row is first created, but it also fires any time you change the value of any cell in that row. So you will be creating an recreating controls you really don't need and leaking memory every time you do.
Cancel
Reply

Cancel
115

Offline Jordan Bowness posted over 13 years ago in reply to Mike Saltzman

Thanks for the reply Mike.

I'm actually only going this for the FIRST row in the grid, so I haven't noticed a huge cost. That said, I will look at your suggestion. Thanks kindly.

Jordan.
Cancel
Reply

Cancel
469350

Offline Mike Saltzman posted over 13 years ago
Not every control supports every property of the DefaultEditorOwnerSettings.So it's possible the grid is not honoring the ValueList you are specifying here.

The good news is that you really don't need this, anyway. You can simple set the ValueList property on the cell.

Another potential problem here is that you are creating a new UltraDropDown and a new DataTable for every row every time that row is initialized. This is a problem for a number of reasons. For one thing, your UltraDropdown is never parented to the form. This means it will never get disposed and it also has no BindingContext.

This is also horribly inefficient, since you are creating a huge number of UltraDropDowns and DataTables that will never get disposed. Your application will eat up more and more memory the longer it runs.

I strongly recommend creating the UltraDropdown only once and doing it outside of the InitializeRow event. If you need more than one UltraDropDown, then I would create all the ones you need and re-use them as needed inside InitializeRow. And also make sure to add the UltraDropDown control to the form.Controls collection.

So you can replace your loop with this code:

For Each CurrentCell As Infragistics.Win.UltraWinGrid.UltraGridCell In e.Row.Cells
                CurrentCell.ValueList = MyDropdownList

                CurrentCell.Editor = myEditor
            Next

And you do not need the DefaultEditorOwnerSettings at all.
Cancel
Reply

Cancel
71886

Offline [Infragistics] Boris Toromanov posted over 13 years ago
Hello,

My advice is to change this line
MyDropdownList.SetDataBinding(tblList, "ColName")
with the following:
MyDropdownList.SetDataBinding(tblList, tblList.TableName)
.

You could also pass an empty string for a DataMember in the SetDataBinding() method.

If it is not of a matter if you are using this method or either set the DataSource property of the UltraDropDown I would recommend you to use something similar to the following:

MyDropdownList.DataSource = tblList;

You could read about the DataMember property and the SetDataBinding() method at the following links: http://help.infragistics.com/Help/NetAdvantage/WinForms/2011.1/CLR2.0/html/Infragistics2.Win.UltraWinGrid.v11.1~Infragistics.Win.UltraWinGrid.UltraGridBase~DataMember.html and

http://help.infragistics.com/Help/NetAdvantage/WinForms/2011.1/CLR2.0/html/Infragistics2.Win.UltraWinGrid.v11.1~Infragistics.Win.UltraWinGrid.UltraGridBase~SetDataBinding(Object,String,Boolean,Boolean).html respectively.

Please notice this line: "Indicates a sub-list of the DataSource to show in the UltraWinGrid." from the first link. So, if you want to attach the DataTable, that you are creating, as a source to the drop down, you have to pass it as a DataMember to the control.

Feel free to contact us if you need any additional assistance.
Cancel
Reply

Cancel