This is a migrated thread and some comments may be shown as answers.

Scheduler and MySQL Database

3 Answers 234 Views
Scheduler and Reminder
This is a migrated thread and some comments may be shown as answers.
yurinkomarov
Top achievements
Rank 1
yurinkomarov asked on 17 Mar 2016, 03:41 PM

Good day!

It is necessary that the Scheduler worked with MySQL database and not MsAccess. And, preferably, to explain the connection and filling in the data via code and not using the Visual Studio.

Best regards, Me!

3 Answers, 1 is accepted

Sort by
0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 18 Mar 2016, 01:06 PM
Hello Yura,

Thank you for writing.

You can refer to the following help articles demonstrating how to setup RadScheduler's data binding:

http://docs.telerik.com/devtools/winforms/scheduler/data-binding/data-binding-walkthrough
http://docs.telerik.com/devtools/winforms/scheduler/data-binding/using-datasource-property
http://docs.telerik.com/devtools/winforms/scheduler/data-binding/codeless-data-binding

Note that it is important to specify the DataSource property of the AppointmentMappingInfo and the ResourceMappingInfo

If you need filling the DataTable from the SQL server, you can refer to the following stackOverflow threads:
http://stackoverflow.com/questions/11993211/how-to-fill-datatable-with-sql-table
http://stackoverflow.com/questions/16958155/fill-datatable-from-sql-server-database

I hope this information helps. Should you have further questions I would be glad to help.
 
Regards,
Dess
Telerik
Do you need help with upgrading your AJAX, WPF or WinForms project? Check the Telerik API Analyzer and share your thoughts.
0
yurinkomarov
Top achievements
Rank 1
answered on 21 Mar 2016, 01:27 PM

Good day!

Main problem is that I can't change ConnectionString (if in work I need change SQL Server).

Best regards, Me!

0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 22 Mar 2016, 10:34 AM
Hello Yura,

Thank you for writing back. 

Note that if you generate the BindingSource from your SQL server data at design time, the connection string is stored in the App.config file. The following MSDN article is quite useful about changing the connection string: https://msdn.microsoft.com/en-us/library/ms171889(v=vs.90).aspx

If you are still experiencing any further difficulties, it would be greatly appreciated if you specify in details what is the exact goal that you are trying to achieve. Thus, we would be able to assist you further.

I hope this information helps. If you have any additional questions, please let me know.

Regards,
Dess
Telerik
Do you need help with upgrading your AJAX, WPF or WinForms project? Check the Telerik API Analyzer and share your thoughts.
Tags
Scheduler and Reminder
Asked by
yurinkomarov
Top achievements
Rank 1
Answers by
Dess | Tech Support Engineer, Principal
Telerik team
yurinkomarov
Top achievements
Rank 1
Share this question
or