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.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to load the data from SQLite offline database in SfListView?

SfListView allows you to bind the data from local database by using SQLite. To achieve this, you need to follow the below steps: SQLiteConnection

Step 1: Create a SQLite database table

Step 2: Populate the data into the table

Step 3: Store them as an IEnumerable collection

Step 4: Bind it to SfListView using SfListView.ItemSource property.

Step 5: Refer the following link to know how to create SQLite connection,
http://developer.xamarin.com/guides/xamarin-forms/working-with/databases/

Note: To run this sample in UWP, install sqlite.net.pcl, version v1.0.10 (Only this version of SQLite supports UWP platform, later versions don’t support UWP).

Refer the following code which illustrates, how to create a SQLite database table and insert items in it.

C#

 

C#

 

Refer the following code to bind the data from the SQLite database to SfListView.

XAML

 

Click here to download the sample.

Article ID: Published Date: Last Revised Date: Platform: Control:
7550 03/08/2017 02/12/2018 Xamarin.Forms SfListView
Did you find this information helpful?
Comments
Stephan Schrade Dec 10, 2017

Unfortunately the downloadable project does not run on my mac with Xcode 9.2

there are some strange conditions in the csproject file regarding specific older versions of Xamarin.forms and building results in 

LaunchScreen.storyboard: Error: Compiling IB documents for earlier than iOS 7 is no longer supported. (SampleDemo.iOS) ibtool

Reply
Muthu Kumaran Gnanavinayagam [Syncfusion] Feb 12, 2018

Hi Stephan,

 

The reported issue occurs due to minimum deployment target version in the attached sample. We have modified our sample and you can download the working sample.

 

Regards,

G.Muthu kumaran.

Reply
Add Comment
You must log in to leave a comment

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