So, I've been working with putting a Database into my Kanban project and I ended up getting everything working. I also checked out the example you gave someone on thread 134560.
So, I have an issue where when I add in and read the KanbanModels from the database and add it to a specific assignee (in swimlane view), the card does not show up, but it gets added to the count of items for the column? So, I stepped through the program completely and checked to make sure all of the calls and variables and types were correct, but I was unable to fix it.
I even went off of your example you gave on that thread with no luck. I created the ObservableCollection<KanbanModel> and did the same setup but with no luck, even by setting the KanabanControl.ItemsSource equal to the collection and I even tried to manually Bind from Xaml, also with no luck.
Currently, I switched to the Basic UI view by taking away the Assignee parameter, and it works perfectly....? All I did was take out the Assignee property within the model creation and all to go back to the UI without swimlane.
I was adding into the db like this, where cols are setup as (ID, Title, Description, Category, ColorKey, Tags) and ID is the primary key which auto increments:
SqliteCommand insertCommand =new SqliteCommand();
// Use parameterized query to prevent SQL injection attacks
insertCommand.CommandText="INSERT INTO MyTable VALUES (NULL, @title, @desc, @categ, @colorKey, @tags);";
I was getting the data from the db like this, though I've tried many different ways to get it to work and nothing helped, including how yours was setup. The code below is currently in the GetData function which returns the observable collection:
Tags = query.GetString(5).Split(",")// Turn string of tags into string array, fills listview
Once GetData() returns, it's being set to the ItemSource of Kanban, i.e., kanbanControl.ItemsSource = DataAccess.GetData();
Just for the context again, I did go off of your example from the thread listed above, and had the ObservableCollection placed in the same area as you, but no luck :( Really wanted to use the Swimlane view both for appearances and to use myself after I'm finished with the program. If you'd like a copy of my project to test, I'll attach it but please let me know. Would love to get this issue figured out!
As I said, I did remove the Assignee property for the KanbanModels and that took it out of Swimlane view, which made things work fine. So, I just took it out of the table completely and as of right now I took away the option for the user to add their own Assignee. It was working perfectly before I started working with a database too.
Tags = query.GetString(6).Split(",")// Turn string of tags into string array, fills listview
HUHunterJune 5, 2019 07:45 AM
I started with your sample from the thread ID I put in this post with the KanbanSQL example you did. I added the Assignee property to both the table, params and all and it wasn't working with just that.
MKMuneesh Kumar G Syncfusion Team June 6, 2019 07:53 AM
Greetings from Syncfusion.
Due to the source complexity, we need some more time to check the provided sample with database connection. We will update you the details on June 7th, 2019. We appreciate your patience until then.
Muneesh Kumar G.
HUHunterJune 6, 2019 08:42 AM
Sure thing, no problem! If you need any additional context please feel free to let me know. I do have the samples I wrote too!
HUHunterJune 6, 2019 02:09 PM
Sorry, just trying to give as much context as I can!
I've uploaded my test program with my code. You should be able to run it and see my example of what is going wrong. I also uploaded a screen recording video of the problem that I am having with my application. This should help a ton on narrowing down the issue. I will continue to work on it on my end and see if I find a solution.
NOTE: If you run my project and get a read-access memory error when you make your first task, just restart the program and it'll be added and it'll be fine after that. I haven't figured out why it does that yet, but it still works perfect afterwards, sooo, that'll be saved for a later date (presumably after this bug).
IMIyyappan Mani Syncfusion Team June 9, 2019 10:12 AM
Sorry for the inconvenience caused,
Since, we are checking the reported issue with source level and we will update you with more details on 10thJune 2019. We appreciate your patience until then.
HUHunterJune 9, 2019 10:29 AM
It's no problem at all! I hope I gave enough context so that you're able to pinpoint where I'm going wrong or if something is broken that I'm unaware of :)
Thank you for your time and help!
MKMuneesh Kumar G Syncfusion Team June 10, 2019 07:46 AM
Since we have checked the reported problem by generating another application and the issue in that application did not occur. Since we need some more time to validate your sample, we will update you on June 11, 2019 with more information.
Regards, Muneesh Kumar G
MKMuneesh Kumar G Syncfusion Team June 11, 2019 08:43 AM
We have logged the defect report “Swimline Cards not gets refereshed“ in UWP Platform and you can track it from the below link.