SQL Server

[Keith Darby]

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]

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

[Administrator]

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

[Administrator]

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



MDB_ScheduleSample_VB.zip

[Administrator]

Here is a C# version.



MDB_ScheduleSample_CS.zip

[Keith Darby]

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]

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]

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

[masoodabedin]

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

[Marcelo Souza Fernandes]

Where is the file ???

[Piruthiviraj Malaimelraj]

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