We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

load complex data from Sqlite

Thread ID:

Created:

Updated:

Platform:

Replies:

132382 Aug 29,2017 04:21 PM UTC Sep 4,2017 04:48 AM UTC Xamarin.Forms 5
loading
Tags: SfListView
Laura Ruggeri
Asked On August 29, 2017 04:21 PM UTC

I have a list with incremental load.
For every given piece I have to read the detail
Is that the best approach?

Dinesh Babu Yadav [Syncfusion]
Replied On August 30, 2017 01:35 PM UTC

Hi Laura, 
 
Thank you for using Syncfusion Products. 
 
Query 
Response 
Load data into SfListView from SQLite 
We have included in our KB documentation about “Loading the data from SQLite online/offline database in SfListView” similar to the reported query and please find the following link for more information’s.  
  
Support for incremental loading in SfListView 
We have prepared the KB documentation regarding the support for load more items when end of SfListView is reached and please refer the following KB link for more information. 
 
For every given piece I have to read the detail 
We could not able to understand the reported query. So, could you please share some additional details and exact requirement that you need to implement at your end using SfListView which would help us to analyze the requirement better and update you an appropriate solution. 
 
Please let us know if you require further assistance. 
 
Regards, 
Dinesh Babu Yadav 
 


Laura Ruggeri
Replied On August 30, 2017 01:48 PM UTC

I had read this documentation.

I have a list of products that I read correctly from my database.

For each product I have to go to read data with complex queries and that can not be run along with the first one.

On native android in the getview (adapter list) i read these data and only if the scrool is not busy.


Dinesh Babu Yadav [Syncfusion]
Replied On September 1, 2017 01:48 AM UTC

Hi Laura, 
 
Sorry for the inconvenience. 
 
Could you please confirm that your exact requirement is to whether you need to load the data by using complex queries when an item is being added to the visual layout like similar to ItemAppearing event in Xamarin Forms ListView. If yes, we have considered to provide support for ItemAppearing and ItemDisappearing event in SfListView by which you can achieve your requirement. We have added it into our feature request list, and the feature will be available in our upcoming 2017 Volume 4 main release. We will update you once the feature has been implemented 
 
Please let us know if you require further assistance. 
 
Regards, 
Dinesh Babu Yadav 


Laura Ruggeri
Replied On September 1, 2017 07:12 AM UTC

Yes.

In addition to the ItemAppering and ItemDisappering, it would be helpful to have scroll status.

At the moment I resolved this way even if it is not optimal.

 private async void ScrollRows_Changed(object sender, ScrollChangedEventArgs e)
        {
            IsBusyScroll = true;
            var lastIndex = scrollRows.LastBodyVisibleLineIndex;
       
            await Task.Delay(600);
            if (lastIndex == scrollRows.LastBodyVisibleLineIndex)
            {
                IsBusyScroll = false;
                var rows = scrollRows.GetVisibleLines();
                try
                {
                    for (int i = 0; i < rows.Count; i++)
                    {
                        var row = rows[i];
                        ARTICOLO_BIND_LISTE bind = ViewModel.MagartItems[row.LineIndex];
                        if (bind.SET_ALL_DATO == false)
                        {
                            System.Diagnostics.Debug.WriteLine("APPERING SCROLL " + bind.IndexDisplay + "->" + bind.Descrizione);
                            ViewModel.LoadItemComplete(row.LineIndex);
                        }
                    }
                }
                catch { }
            }


        }


Dinesh Babu Yadav [Syncfusion]
Replied On September 4, 2017 04:48 AM UTC

Hi Laura,  
  
Thanks for the update. 
  
Currently, we do not have support for “Detecting the different ScrollStates for ScrollView in SfListView” and we have already considered this as feature request. We have added it into our feature request list, and the feature will be available in our upcoming 2017 Volume 4 main release. We will update you once the feature has been implemented and included in release. 
  
Regards, 
Dinesh Babu Yadav 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;