Scheduler and MySQL Database

4 posts, 0 answers
  1. yurinkomarov
    yurinkomarov avatar
    7 posts
    Member since:
    Feb 2016

    Posted 17 Mar 2016 Link to this post

    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!

  2.
  3. Dess | Tech Support Engineer, Sr.
    Admin
    Dess | Tech Support Engineer, Sr. avatar
    3765 posts

    Posted 18 Mar 2016 Link to this post

    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.
  5. yurinkomarov
    yurinkomarov avatar
    7 posts
    Member since:
    Feb 2016

    Posted 21 Mar 2016 in reply to Dess | Tech Support Engineer, Sr. Link to this post

    Good day!

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

    Best regards, Me!

  7. Dess | Tech Support Engineer, Sr.
    Admin
    Dess | Tech Support Engineer, Sr. avatar
    3765 posts

    Posted 22 Mar 2016 Link to this post

    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.
  8.
Back to Top