(UTC)
  The MindFusion Forums › Scheduling and Gantt Components › Windows Forms › Using Planner .net with database
(Moderator: Iva_P)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send TopicPrint
Hot Topic (More than 10 Replies) Using Planner .net with database (Read 10269 times)
rfeuer
YaBB Newbies
*
Offline


I love YaBB 1G - SP1!

Posts: 12
Joined: Jan 16th, 2006
Using Planner .net with database
Jun 18th, 2006 at 4:05pm
Print Post  
Do you know of anyone successfully writing classes that extend appointment, and recurrence that will read and write to a database? I have done, so but am having a terrible time with performance. The recurrence part is especially tricky with an extended appointments. Any thoughts?

Thanks,

Rick
  
Back to top
 
IP Logged
 
Meppy
God Member
*****
Offline


MindFusion support

Posts: 1783
Joined: Jul 20th, 2005
Re: Using Planner .net with database
Reply #1 - Jun 20th, 2006 at 4:30am
Print Post  
We are going to implement a built-in database binding in the next release of Planner.NET.

Meppy
« Last Edit: Jun 20th, 2006 at 8:14am by Meppy »  
Back to top
 
IP Logged
 
EM
Guest


Re: Using Planner .net with database
Reply #2 - Jun 21st, 2006 at 11:46am
Print Post  
When is the next release??
  
Back to top
 
IP Logged
 
Bud Staniek
Guest


Re: Using Planner .net with database
Reply #3 - Jun 28th, 2006 at 10:51am
Print Post  
Dataset binding would be good, real good. Any ETA on this feature?
  
Back to top
 
IP Logged
 
Stoyo
God Member
*****
Offline


MindFusion support

Posts: 13230
Joined: Jul 20th, 2005
Re: Using Planner .net with database
Reply #4 - Jun 28th, 2006 at 12:14pm
Print Post  
It should be ready in 1-2 weeks, then we'll post here a download link for the beta version.

Stoyan
  
Back to top
 
IP Logged
 
Damian
YaBB Newbies
*
Offline


I love YaBB 1G - SP1!

Posts: 12
Joined: Apr 26th, 2006
Re: Using Planner .net with database
Reply #5 - Jul 22nd, 2006 at 8:24pm
Print Post  
Is there a release with the database integration as yet?

Cheers
Damian
  
Back to top
 
IP Logged
 
Bud Staniek
Guest


Re: Using Planner .net with database
Reply #6 - Jul 23rd, 2006 at 12:21pm
Print Post  
I have completed some prototpe testing of a SQL Server-based app using just a handful of appointments and that went well. The appointments are objects based on an extended Appointment class. I am using DataSets to store the retrieved data but saving any changes back to the database at the time they are made. (Calling stored procedures, not the DataAdapter's Update method.) I have encountered no speed issues whatsoever. Performance is definitely acceptable.

I am now gearing up for a full blown test with 'real data' imported from multiple Outlook calendars. I anticipate the biggest performance-related factors to be:
1) The date range for appointments retrieved from the database into the DataSet
2) The number of calendars ('resources') you wish to include for that date range
3) The number of Dates to Add to the TimetableSettings at any one time

I am looking forward to playing around with these parameters to find optimum settings. From prototype testing, I know acceptable performance can be achieved, I just need to know how far I can push the envelope.

As a side note, I am much impressed with Meppy's plan for implementing external data binding for Calendar items in the next release. From playing around with Planner .NET I can see this would involve an incredible amount of work. I remain 'cautiously optimistic'. Wink
  
Back to top
 
IP Logged
 
Damian
YaBB Newbies
*
Offline


I love YaBB 1G - SP1!

Posts: 12
Joined: Apr 26th, 2006
Re: Using Planner .net with database
Reply #7 - Jul 23rd, 2006 at 6:06pm
Print Post  
But is there a release of this yet? ???
  
Back to top
 
IP Logged
 
Meppy
God Member
*****
Offline


MindFusion support

Posts: 1783
Joined: Jul 20th, 2005
Re: Using Planner .net with database
Reply #8 - Jul 24th, 2006 at 5:03am
Print Post  
The release is not ready yet. Once we have a beta version, we will post a download link on the forums for all who are interested in testing it.

Meppy
  
Back to top
 
IP Logged
 
Bud Staniek
Guest


Re: Using Planner .net with database
Reply #9 - Aug 13th, 2006 at 2:13pm
Print Post  
Just wanted to post the results of using the Planner.NET control with a 'real' database. I imported Outlook calendars from 4 resources (a.k.a. 'people') for 2006 into an SQL Server database. Total number of imported appointments was about 4500.

The fetch routines from my application retrieves approximately 60 days worth of appointments at a time into a dataset and the Appointment, Resource, and Recurrence objects are subsequently created from the corresponding rows in the data tables. That way, for example, when the TimeTableSettings.Dates collection needs to be rebuilt, it can use data already in the data tables rather than re-open the database connection and retrieve from there. The only time the database gets hit is when the user selects a date outside of the 60-day range. When that happens, all data tables, Appointments, and Recurrences are cleared and re-created.

I remain very pleased with performance. The re-rendering of appointments whenever the user changes dates or switches calender views (TimeTable, Day, SingleMonth, etc.) takes almost no time. I have also played around with extending the 60-day date range with minimal impact on performance.

Very impressive product MindFusion guys! I would be interested to hear from others who have database-enabled their Planner.NET apps
  
Back to top
 
IP Logged
 
Meppy
God Member
*****
Offline


MindFusion support

Posts: 1783
Joined: Jul 20th, 2005
Re: Using Planner .net with database
Reply #10 - Aug 14th, 2006 at 1:35pm
Print Post  
That's great news. We haven't tested the control with that many objects, so probably our code is inherently good  Wink

Meppy
  
Back to top
 
IP Logged
 
Damian
YaBB Newbies
*
Offline


I love YaBB 1G - SP1!

Posts: 12
Joined: Apr 26th, 2006
Re: Using Planner .net with database
Reply #11 - Aug 16th, 2006 at 4:11pm
Print Post  
Im storing all my data in an sql xpress database.  Works ok but found some issues with recurrence which im still trying to fix (problems with my app).  Ive been hangin on for the database version to see if it would help but need to get it sorted asap so am cracking on with it.

At first i stored all my data as xml inside database fields but have since changed it to use typed datasets and do it properly - creating records for each item etc..!   Still relatively new to .net after moving from vb6 so everything quite new at the moment - but im getting there.
  
Back to top
 
IP Logged
 
Meppy
God Member
*****
Offline


MindFusion support

Posts: 1783
Joined: Jul 20th, 2005
Re: Using Planner .net with database
Reply #12 - Aug 17th, 2006 at 5:50am
Print Post  
Please, let me know what problems do you have with item recurrences. I might be able to help.

Meppy
  
Back to top
 
IP Logged
 
SimonL
YaBB Newbies
*
Offline



Posts: 36
Joined: Aug 11th, 2006
Re: Using Planner .net with database
Reply #13 - Aug 20th, 2006 at 10:28am
Print Post  
Meppy wrote on Jun 20th, 2006 at 4:30am:
We are going to implement a built-in database binding in the next release of Planner.NET.

Meppy


Does this mean that when we use the control in VS2005, we will be able to create a DataSource in the DataSource window and drag the DataSource to the calendar control and have it bind at design time. Or at least will we be able to bind to business objects that implement IBindableList etc. We use business objects, not datasets.

Thanks,
Simon
  
Back to top
 
IP Logged
 
Meppy
God Member
*****
Offline


MindFusion support

Posts: 1783
Joined: Jul 20th, 2005
Re: Using Planner .net with database
Reply #14 - Aug 21st, 2006 at 6:37am
Print Post  
We expect to support both datasets and business objects as data sources.

Meppy
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send TopicPrint
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

The MindFusion Forums » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2025. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge