Populate SfChart SplineSeries to a SQLite DataSource

[Rob]

I'm trying to connect a SQLite database through an ObservableCollection to a populate a Spline Graph

I can build the graph from a collection hard coded in the class, and can pull the data from SQLite into a Listview.  I'm missing something in how to join the two.

Do you have a working example of this so I can see where my code is incorrect?

Thanks

[Devakumar Dhanapoosanam]

Hi Rob, 

 

Greetings from Syncfusion. 

 

We have analyzed your requirement using the SQLite database and prepared a sample for your requirement. 

 

Sample: https://www.syncfusion.com/downloads/support/forum/150764/ze/150764-552325563.zip  

 

Please let us know if you need any further assistance. 

 

Regards, 

Devakumar D 

[Rob]

That was very helpful.  It helped show me what I was doing wrong.

Many thanks

[Hemalatha Marikumar]

Hi Rob, 

 

Thanks for your update. 

 

We are glad to hear that given solution works.  

 

Please let us know if you need any further assistance. 

 

Regards, 

Hemalatha M. 

[Joseph Kim]

Do you have codes for flutter?

I want to add, update and delete by Sqlite.

Thank you.

[Dharanitharan Palanisamy]

Hi Joseph, 

 

We have prepared a sample for populating data points in Flutter Spline charts, which you can download here. Using the SQLite database, we prepared a sample for adding, reading, updating, and deleting data from the table and the same is modified in the chart. Please use this sample as a guideline and modify it to suit your needs. You can consult the support document for more details.  

 

Sample: https://www.syncfusion.com/downloads/support/forum/164904/ze/sql_db_flutter_charts1609635850 

 

Please contact us if you need any additional assistance. 

 

Regards, 

Dharanitharan. P 

[Joseph Kim]

Thank you for your sample.

I'm trying to use X axis with date (mm-dd-yyyy) and sorting. But SQlite doesn't support date and use text format.

How can I sort automatically based on date?

Thank you.

Joseph

[Dharanitharan Palanisamy]

Hi Joseph, 

 

We reviewed your query and recommended that you use the int type in SQLite to store DateTime in milliseconds because SQLite does not support DateTime. You can bind the Cartesianchart with DateTimeAxis, and it is sorted by default, so you don't have to sort it manually. You can sort the CategoryAxis using SortFieldValueMapper, and you can refer to the help documentation below for more information. We have attached a sample that uses SQLite's int type to store DateTime in milliseconds and binds to the Cartesianchart. 

 

https://help.syncfusion.com/flutter/cartesian-charts/axis-types#date-time-axis 

https://help.syncfusion.com/flutter/cartesian-charts/series-customization#sorting 

 

Sample:  https://www.syncfusion.com/downloads/support/directtrac/general/ze/f164904_sql_db_flutter_charts138905013 

 

Thanks, 

Dharanitharan. P