1. Home
  2. Forum
  3. WPF
  4. Problem with Combobox connected to mdb Access table

Problem with Combobox connected to mdb Access table

I'm using google translator to fill out the form and I apologize

I have a WPF application that relies on a mdb access.
In a form I have several Combobox controls related to related tables
In the Load of the form, with the LoadProdotti method, I populate the ObservableCollection that I need to populate the Combobox.
They are loaded correctly, but are not displayed in the form.
I checked the definitions in both the XAML and the code behind of the form, but I can not find the reason for this non-visibility of the data.

I attach the code used.

Part XAML

<syf:ComboBoxAdv
                                Grid.Row="2"
                                Grid.Column="1"
                                Margin="4,2,4,2"
                                Name="cboStato"
                                Padding="4"
                                HorizontalAlignment="Stretch"
                                VerticalContentAlignment="Center"
                                ItemsSource="{Binding Path=ListaStatoProdotto, Mode=TwoWay,UpdateSourceTrigger=PropertyChanged}"
                                DisplayMemberPath="StatoProdotto"
                                SelectedValuePath="IdStatoProdotto"
                                SelectedValue="{Binding Path=CurrentRecord.IdStatoProdotto, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}"
                                IsReadOnly="{Binding IsNotInEditMode, Mode=OneWay, UpdateSourceTrigger=PropertyChanged}"/>

Part Code Behind

definition of the ListaStatoProdotto

    /// <summary>
        /// Lista Stato Prodotto
        /// </summary>
        public ObservableCollection<T_Stato_Prodotto> ListaStatoProdotto
        {
            get
            {
                return mListaStatoProdotto;
            }
            set
            {
                mListaStatoProdotto = value;
                OnPropertyChanged(FLD_ListaStatoProdotto);
            }
        }


LoadProdotti method

    private void LoadProdotti()
        {

            // carico lo Stato dei Prodotti
            ListaStatoProdotto = new ObservableCollection<T_Stato_Prodotto>();
            ListaStatoProdotto.Clear();
            mDpStatoProdotto = new DpT_Stato_Prodotto(AppContext.Instance.ConnStringCommarea);

            Result<List<T_Stato_Prodotto>> statoP = mDpStatoProdotto.SelectAll(Key);
            foreach (T_Stato_Prodotto sta in statoP.Data)
            {
                ListaStatoProdotto.Add(sta);
            }

        }


The result is visible in the attached screenshot.
No list with product statuses is displayed.
I would ask you an example with an associated mdb file.
Thank you

Moreno










Attachment: 20171226_ErroreCombobox_7d04e258.zip

14 Replies
VR Vijayalakshmi Roopkumar Syncfusion Team December 27, 2017 11:05 AM UTC

Hi Misonsan

Thank you for contacting Syncfusion Support.

We have checked the screenshot and found that the items are bind to the control, but it doesn’t display. In ComboBoxAdv control, the items would be display on binding the desired value in the DisplayMemberPath property. So we suspect there is a problem in value used for DisplayMemberPath property. Can you check this property in your side and let us know the result?

If still the items are not displayed correctly, please send us the sample. We would analyze the sample and provide you the solution.

Regards,
Vijayalakshmi V.R.

MI misonsan December 28, 2017 09:19 AM UTC

Dearest Vijayalakshmi V.R.
I thank you for the quick reply.
I checked what you specified in my reply, but I do not find anything unusual.
I created the test project for your kind verification.
Concerning the problem of the Combobox, I temporarily buffered the problem by intervening on the SelectionChanged event, but this seems to me very temporary and not perfectly functional.
After the record has been updated, the values ​​on the combobox are no longer displayed correctly.

In the present project there is also a DoubleTextBox field that has an anomalous behavior and for which I had opened a new request for assistance on 12/22/2017 headed: Problem Using DoubleTextbox.
I would ask you to analyze anceh this problem that I summarize.
In the Price field, declared DoubleTextBox, I must enter the value 1518.42
entered the second digit, I receive the field 1500.00 and then I can not enter the value correctly.




I would ask you to do the checks and then explain to me where and how I'm wrong.
I remain available for any clarification.
In the annex I report the project and the abase data in access.
For a correct operation you must create on the root a folder "Archives" and insert mdb.

I'm sorry for the imperfect syntax, but I use google translator

Hello
Moreno

Attachment: TestComboWpf_1ed70f0a.zip

MI misonsan December 28, 2017 09:25 AM UTC

I'm sorry Vijayalakshmi V.R.

I had also added the zip of the mdb file, but I saw that it had not been inserted.
I refer it now and it is an integral part of my answer.


create a folder in the root of the pc "Archivi"

Hello
Moreno

Attachment: TestCombo_ccaa9850.zip

VR Vijayalakshmi Roopkumar Syncfusion Team January 5, 2018 12:01 PM UTC

 Hi Misonsan

Thank you for contacting Syncfusion Support. 

We have checked the reported sample , but the items has been displayed correctly in ComboBoxAdv at our end. We have also taken the video for the same. Please download the video from following location: 

Please check the video and let us know the whether we follow the correct replication procedure to reproduce the issue. Also let us know your current product versiond details? It would be helpful for us to proceed on this.

Regards,
Vijayalakshmi V.R. 


MI misonsan January 17, 2018 11:32 AM UTC

Thank you for your contribution.
Perhaps I was not exhaustive in explaining the problem.
During the creation of the form the combos are correctly evaluated; the problem occurs when I make changes to the record and re-add the form, the combos are no longer displayed correctly as it happens during the load phase.
With the material that I attached during the notification of the problem, I would ask you to be able to perform some data operations to verify the problem.
Thank you
Moreno

KJ Keerthana Jegannathan Syncfusion Team January 18, 2018 10:14 AM UTC

Hi Misonsan, 
 
Thanks for your update. 
 
As you have mentioned we have made some operations like adding item, re-open it again and some more scenarios (in our latest version 15.4.0.20). But still we couldn't get the issue which you face at you end. We have attached the video which we tries at our end 
 
 
Can you confirm whether you using Syncfusion version 15.4.0.20? Also can you share a video about replication steps? This would reduce the time of reproducing the issue at our end and work for the solution. 
  
Regards, 
Keerthana J 


MI misonsan January 18, 2018 02:34 PM UTC

thanks Keerthana J for the attention

As you can see, I'm using Visual Studio Community 2015 version 14.0.24720.00
Can you use this version?
I downloaded Visual Studio Community 2017 version 15.5.3 but I can not use it yet.
Attached I posted a few photos with the sequence of operations and evidence of the error.

Thank you

Moreno

Attachment: Errori_Combo_9974ffb8.zip

VR Vijayalakshmi Roopkumar Syncfusion Team January 19, 2018 07:27 AM UTC

Hi Misonsan

Sorry for the miscommunication.

In our last update we mentioned about our Syncfusion version. Can you check with our latest version 15.4.0.20 and let us know the result?

In additional testing, we have checked the reported behavior using the provided screenshot at our end, but we are unable to reproduce it our end. We have tried to create a new record as like the other record, but we could not able to save since some of the field is invalid. So we have saved the already created record by editing and checked. But the values are correctly updated related to the selected record. Please find the video for the same:

Video shows how the new record is not created at our end 
Video shows the editing operation done for alreay created item 

Can you also share a video of your application which explains the issue?

Regards
Vijayalakshmi V.R. 


MI misonsan January 19, 2018 12:05 PM UTC

Thanks for the attention.

I apologize for mistakenly sending you versions of Visual Studio and not SyncFusion.
I provide with the attachment.
If the version is shown in the arrow, I have version 15.1.0.37 while you have tested the code with version 15.4.0.20

I have seen from the videos, which you have kindly created, that the operation of the code is correct.
You therefore ask for assistance to update my version of SyncFusion.
It's the first time I've done it and I would not want to make mistakes.
I apologize for the perhaps incorrect way to write, but I have to rely on google translator.

Thank you

Moreno

Attachment: Versione_SyncFusion_f209e564.zip

VR Vijayalakshmi Roopkumar Syncfusion Team January 22, 2018 11:38 AM UTC

Hi Misonsan

Thank you for the information.

We were able to reproduce the reported issue in the version "15.1.0.37" and we have fixed in the next immediate release "15.1.0.41" Can you please upgrade this version or to the latest version "15.4.0.20" in order to get the issue get fixed?

Regards
Vijaylakshmi V.R.

MI misonsan January 22, 2018 07:51 PM UTC

I would like to update the version of my program, but I would like to ask for assistance as it is the first time.
Do I have to download "Latest Version" or "Service Pack"?
It is sufficient then to perform only the setup of the file in download or debbo to do other
activity?
Attached the screenshot of the files in Download
Thank you
Moreno

Attachment: 20180122_Download_982a5bce.zip

KJ Keerthana Jegannathan Syncfusion Team January 23, 2018 06:28 AM UTC

 
Hi Misonsan, 
 
Thanks for your update. 
 
You can download the service pack which is the latest one from the below location. 
 
  
Also, installation of this file will configure your machine with our Syncfusion Essential Studio Service pack(15.4.0.20) version assemblies which includes the fix for your reported issue automatically. Please let us know if you need further assistance on this. 
 
Regards, 
Keerthana J 
 
 
 


MI misonsan January 25, 2018 11:18 AM UTC

thank you Keerthana for timely and professional assistance.
I have upgraded as recommended and it works all regularly.
Good day
Moreno

PB Priyanga Balasubramaniam Syncfusion Team January 25, 2018 11:38 PM UTC

Hi Moreno,

Thanks for your update.

Let us know if you need any other assistance.

Regards,
Priyanga B

Loader.
Up arrow icon