SQL Server

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


10 Replies

AD Administrator Syncfusion Team December 10, 2007 04:39 PM UTC

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



AD Administrator Syncfusion Team December 14, 2007 09:02 AM UTC

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.



MDB_ScheduleSample_VB.zip


AD Administrator Syncfusion Team December 14, 2007 09:07 AM UTC

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



MDB_ScheduleSample_VB.zip


AD Administrator Syncfusion Team December 14, 2007 09:15 AM UTC

Here is a C# version.



MDB_ScheduleSample_CS.zip


KD Keith Darby January 4, 2008 10:56 AM UTC

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?



KD Keith Darby January 4, 2008 01:01 PM UTC

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).




RA Rajagopal Syncfusion Team January 22, 2008 11:14 PM UTC

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
http://websamples.syncfusion.com/samples/Grid.Windows/I40344VBSample/main.htm

Regards,
Rajagopal



MA masoodabedin March 17, 2010 06:34 PM UTC

Hey
I can use the sample file but this is not a valid link.
Is it possible to update the link thanks.
http://websamples.syncfusion.com/samples/Grid.Windows/I40344VBSample/main.htm
MA




MS Marcelo Souza Fernandes March 29, 2016 02:45 PM UTC

Where is the file ???


PM Piruthiviraj Malaimelraj Syncfusion Team March 30, 2016 10:06 AM UTC

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.


Sample:

http://www.syncfusion.com/downloads/support/forum/70377/ze/VB_Sample-1079103580


Regards,

Piruthiviraj


Loader.
Up arrow icon