Can I use data from a MySQL database?

[Mike]

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

[Mike]

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

Mike

[Dimitar]

Hello Mike,

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

• Spreadsheet DataSource Binding.

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:

• Bind to DataSource Specifics.
  
  
• Server-side Processing.
  
  
• CRUD Data Operations.

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

[Mike]

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

[Plamen]

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