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

Sample for Web Sql Database

4 Answers 393 Views
Grid
This is a migrated thread and some comments may be shown as answers.
saif
Top achievements
Rank 1
saif asked on 22 Nov 2011, 03:03 PM
Can somebody provide me with sample to work with Kendo grid and Web Sql Database

4 Answers, 1 is accepted

Sort by
0
Corby
Top achievements
Rank 1
answered on 01 Dec 2011, 10:00 PM
I, too, would find this useful.  I've seem threads around the web about using Javascript to query sql and then binding the return to the grid but haven't tried that yet.  As an alternative, I'm wondering if using the code-behind for my C# .NET page to query the DB and return XML, then binding the xml to the grid would work.  Anyone have any sample code they could share?
0
William
Top achievements
Rank 1
answered on 09 Jan 2012, 09:45 PM
It would be great to see a functional grid demo with php files to connect to an sql database.
The sql dumping data would help eliminate the confusion to set it up.

JQeury Flexigrid had a working code option example available for php mySQL to populate the grid
and even though it looks harder to implement it got me going on the right track.

All we need is a simple sample to get started.... 3 or 4 table columns & rows for the SQL dump and
a description of what files to setup to connect to the DB.

Is there anybody that can help with this?
0
Sovan
Top achievements
Rank 1
answered on 10 Jan 2012, 11:26 AM
Hi all,
I am also trying to make a sample app using mssql server,wcf service,LINQ and kendoGrid editing. My grid is binding properly, but I have no idea how to edit,delete,or add data into grid and sync to the db as well(). I'd also like to know how the simple service urls(as there in the http://demos.kendoui.com/web/grid/editing.html) for CUD operations make the magic. Actually I need the server side implementations(i.e. the service part(what should I write in the .svc.cs file to make it work),the code to update data into the db)
I've made other grid apps using OData. But they all are for read purpose only. Now I need to update into db as well. I am using visual web developer 2010 Express. I need code in this version.
Can anybody share any code regarding the CUD operations? It'd be a great help for me.

KendoUI has also a todo app using .net mvc architecture. Go to link www.kendotodo.apphb.com/Home

Thanks.
0
Rich
Top achievements
Rank 1
answered on 12 Jan 2012, 03:50 PM
I agree with the previous post from Sovan.
I would also like to see the server side code included in the examples (i.e. the service part(what should I write in the .svc.cs file) so I can update the database. From the examples in the documentation, it is not clear how the data should be updated via the service.

I appreciate the help!
Tags
Grid
Asked by
saif
Top achievements
Rank 1
Answers by
Corby
Top achievements
Rank 1
William
Top achievements
Rank 1
Sovan
Top achievements
Rank 1
Rich
Top achievements
Rank 1
Share this question
or