Can I use data from a MySQL database?

5 posts, 0 answers
  1. Mike
    Mike avatar
    3 posts
    Member since:
    May 2018

    Posted 08 May 2018 Link to this post

    I am evaluating Kendo UI for Jquery.

    I need the spreadsheet grid control to input a very specific excel file.  In the end, I need to turn it into a web form.

    That form data would write to a MySQL database.  Another web page would read from the database and populate the spreadsheet with data.

    Can this be done with the spreadsheet control?

    If not, can it be done with the data grid or other Kendo UI controls?

    If so, please explain how I would accomplish this.

     

    Thank you.

    Mike

  2. Mike
    Mike avatar
    3 posts
    Member since:
    May 2018

    Posted 10 May 2018 Link to this post

    Anyone?  This is a bit time critical and I cannot find an answer to this. Some help is most appreciated.

    Mike

  3. Dimitar
    Admin
    Dimitar avatar
    806 posts

    Posted 10 May 2018 Link to this post

    Hello Mike,

    There is an existing Spreadsheet Demo that demonstrates how the Kendo UI Spreadsheet can be bound to remote data:


    In addition to the above demo, please refer to the following resources that describe the DataSource binding specifics and also provide additional information on server processing:


    I would also encourage you to take a look at the Spreadsheet DataSource Binding Demo with the Telerik UI for ASP.NET MVC wrappers. There, you could inspect the CRUD server implementation and the service that is used to retrieve data (Entity Framework).

    Regards,
    Dimitar
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  4. Mike
    Mike avatar
    3 posts
    Member since:
    May 2018

    Posted 15 May 2018 in reply to Dimitar Link to this post

    So is that a yes or no (lol).  I read the info and it seems that I can bind mysql database to either the spreadsheet or datagrid controls, reading and writing, so hopefully I can read and write that data to the database with no issues.

    However, I DO NOT use ASP at all (you suggested I should look at something for ASP).  I use MySQL with PHP and HTML5 (and Javascript in many cases).  How would I achieve this with Kendo UI for Jquery?  Do I need the PHP server side option?

     

    Mike

  5. Plamen
    Admin
    Plamen avatar
    3057 posts

    Posted 17 May 2018 Link to this post

    Hello Mike,

    Yes Kendo Spreadsheet can be bound to mysql database with PHP yet we don't have exactly such runnable example with PHP. My colleague linked the MVC demo because our example is using such back end service in case you want to check what is the exact logic that we used there.

    As for the implementation itself in the linked demo is shown how such behavior can be achieved with Kendo Spreadsheet widget for jQuery. In general the Kendo SpreadSheet should have a sheet (or more) and this sheet is assigned a kendo DataSource. This dataSource should define two operations -read and submit and each one of them should connect with your backend and perform accordingly read from the database and save in case of changes.

    Hope this information be helpful. If you have further questions please let me know.

    Regards,
    Plamen
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top