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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

SQL Server

Thread ID:

Created:

Updated:

Platform:

Replies:

70377 Dec 10,2007 12:09 PM UTC Mar 30,2016 10:06 AM UTC WinForms 10
loading
Tags: ScheduleControl
Keith Darby
Asked On December 10, 2007 12:09 PM UTC

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 04:39 PM UTC

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

Administrator [Syncfusion]
Replied On 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

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

Here is a C# version.



MDB_ScheduleSample_CS.zip

Keith Darby
Replied On 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?


Keith Darby
Replied On 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).



Rajagopal [Syncfusion]
Replied On 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


masoodabedin
Replied On 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



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

Where is the file ???

Piruthiviraj Malaimelraj [Syncfusion]
Replied On 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


CONFIRMATION

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.

Warning Icon 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.Close Icon

;