[CLOSED] How combobox automatically loads new value added in the form?

[rnachman]

Hi,

In same web page I used one combobox and text field. The text field is using to enter some information and save it in the database. All these saved information should auto reflect in combobox after click save. While initial load of the page the combobox loads with all saved values in the database and it should auto reflect with values added from webpage.

[Daniil]

Hi,

You should reload the ComboBox Store.

ComboBox1.getStore().reload();

The Store must have an OnRefreshData handler.

Or, even, you can bind a new data directly within server side saving handler.

[rnachman]

Hi Daniil,

Is it compulsory the store object? I just adding the db values directly like following, and calling this same method every time I add value to the database.

Public Sub LoadCategories()
        Dim i As Integer
        Dim ds As New DataSet
        Dim cda As New clsDataAccess
        ds = cda.getDataSet("select * from UserContactCategory where Employee_ID=" & Session("LogID").ToString())

        If ds.Tables.Count > 0 Then
            If ds.Tables(0).Rows.Count > 0 Then
                For i = 0 To ds.Tables(0).Rows.Count - 1
                    cboCategory.Items.Add(New Ext.Net.ListItem(ds.Tables(0).Rows(i)("CategoryName"), ds.Tables(0).Rows(i)("CategoryId")))
                Next
            End If
        End If

        cboCategory.SelectedIndex = 0
    End Sub

Hi,

You should reload the ComboBox Store.

ComboBox1.getStore().reload();

The Store must have an OnRefreshData handler.

Or, even, you can bind a new data directly within server side saving handler.

[Daniil]

Is it compulsory the store object?

In your case - no.

During DirectEvent you should use the ComboBox AddItem, InsertItem, AddRecord or IndesrtRecord methods.

See also
https://examples1.ext.net/#/Form/Com...Items_Actions/