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.

SQL Server

Thread ID:





70377 Dec 10,2007 07:09 AM Mar 30,2016 06:06 AM Windows Forms 10
Tags: ScheduleControl
Keith Darby
Asked On December 10, 2007 07:09 AM

Are any vb samples available for ScheduleControl using SQL Server or Access to store the appointment information?
Using VB.Net 2005 with version 5.1

Administrator [Syncfusion]
Replied On December 10, 2007 11:39 AM

We do not have such a sample but will try to post ones here in the next couple of days.

Administrator [Syncfusion]
Replied On December 14, 2007 04:02 AM

Here is a minimal VB sample that uses a MDB file as its datasource. It uses OleDB to create a DataSet with DataTables that hold the information. This is done by creating a derived ScheduleAppointment class that wraps DataRows, and deriving ScheduleAppointmentList to hold these wrapped datarows.


Administrator [Syncfusion]
Replied On December 14, 2007 04:07 AM

Sorry. Please use this zip file. The previous one is missing the mdb file.


Administrator [Syncfusion]
Replied On December 14, 2007 04:15 AM

Here is a C# version.


Keith Darby
Replied On January 4, 2008 05:56 AM

Thanks for the sample, but I cannot get it to work it gives 2 errors:

Error 4 Type 'IScheduleResourceList' is not defined.

Error 5 sub 'SaveModifiedItem' cannot be declared 'Overrides' because it does not override a sub in a base class.

I am using 5.1, is the sample for version 6 only?

Keith Darby
Replied On January 4, 2008 08:01 AM

If I delete the above function and sub then the code will run till the following line in GetSchedule:
dv.RowFilter = String.Format('[{0}] >= #{1}# AND [{2}] < #{3}#', MDB_ScheduleItem.Column_StartTime, startDate.Date, MDB_ScheduleItem.Column_EndTime, endDate.Date.AddDays(1))

It stops saying 'String was not recognized as a valid DateTime.'
The startDate.Date is showing in US format(mm/dd/yy) rather than UK fromat (dd/mm/yy).

Rajagopal [Syncfusion]
Replied On January 22, 2008 06:14 PM

Hi Keith,

We were able to see this problem when setting the global culture for the application to UK English. This problem can be resolved by parsing it for the InvariantCulture in the GetSchedule override.

Here is the modified sample in VB.NET that works fine


Replied On March 17, 2010 02:34 PM

I can use the sample file but this is not a valid link.
Is it possible to update the link thanks.

Marcelo Souza Fernandes
Replied On March 29, 2016 10:45 AM

Where is the file ???

Piruthiviraj Malaimelraj [Syncfusion]
Replied On March 30, 2016 06:06 AM

Hi Marcelo,

Thank you for your interest in Syncfusion products.

Here is the VB sample of ScheduleControl that uses a MDB file as its datasource.

Please refer to the attached sample.






This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

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.