The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
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?
Please let us know if you need any further assistance.
Regards,
Devakumar D
RORobJanuary 22, 2020 05:38 PM
That was very helpful. It helped show me what I was doing wrong.
Many thanks
HMHemalatha Marikumar Syncfusion Team January 23, 2020 01:00 AM
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.
JKJoseph KimApril 26, 2021 04:18 PM
Do you have codes for flutter?
I want to add, update and delete by Sqlite.
Thank you.
DPDharanitharan Palanisamy Syncfusion Team April 27, 2021 02:58 PM
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.
Please contact us if you need any additional assistance.
Regards,
Dharanitharan. P
JKJoseph KimMay 6, 2021 01:16 PM
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
DPDharanitharan Palanisamy Syncfusion Team May 8, 2021 01:39 AM
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.