This is a migrated thread and some comments may be shown as answers.
Can I use data from a MySQL database?
4 Answers 92 Views
This is a migrated thread and some comments may be shown as answers.
Mike
Top achievements
Rank 1
Mike asked on 08 May 2018, 10:03 PM

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

4 Answers, 1 is accepted

Sort by
0
Mike
Top achievements
Rank 1
answered on 10 May 2018, 10:37 AM

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

Mike

0
Dimitar
Telerik team
answered on 10 May 2018, 12:47 PM
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.
0
Mike
Top achievements
Rank 1
answered on 15 May 2018, 03:24 PM

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

0
Plamen
Telerik team
answered on 17 May 2018, 10:39 AM
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.
Asked by
Mike
Top achievements
Rank 1
Answers by
Mike
Top achievements
Rank 1
Dimitar
Telerik team
Plamen
Telerik team
Share this question
or