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

CRUD Operations with two tables

8 Answers 255 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Ananth
Top achievements
Rank 1
Ananth asked on 12 Jul 2014, 12:51 PM
hi friends

i am new to telerik UI 

i was performed CRUD operations using telerik perfoectly,

i want to perform CRUD operations with more than one table,

u have any sample project please forward to me other wise give the suggestion to do that.

Thanks in advance.

8 Answers, 1 is accepted

Sort by
0
Ananth
Top achievements
Rank 1
answered on 14 Jul 2014, 10:10 AM
hi telerik forum team,

i asked one small doubt,but i still didnt get reply from ur side.

really i feel very bad.

0
Petur Subev
Telerik team
answered on 15 Jul 2014, 04:02 PM
Hello Ananth,

We have covered how to implement CRUD operations with the Grid table in our documentation here:

http://docs.telerik.com/kendo-ui/getting-started/using-kendo-with/aspnet-mvc/helpers/grid/ajax-binding

What do you mean by "operations with more than one table" could you please clarify? Each Grid has its own dataSource which it will use but the approach remains the same.

Kind Regards,
Petur Subev
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
Ananth
Top achievements
Rank 1
answered on 16 Jul 2014, 04:12 AM
hi telerik team

Thanks for reply.

here i attach three tables

my requirement is i want show all the related records as a single grid and perform CRUD operations that's all.

Thanks & Regards

Ananth.G
0
Rene
Top achievements
Rank 1
answered on 16 Jul 2014, 04:45 AM
Ananth,

if you are using entity framework - try creating a view on SQL server joining your tables, creating a model on that view - and then having your grid's datasource work on that model.  When saving - save the values to their respective tables.

Rene.
0
Ananth
Top achievements
Rank 1
answered on 16 Jul 2014, 11:22 AM
Hi telerik team,

i tried my level best but it create some problems for,so i cant continue that

so can u give any sample project with respect to my requirement (i.e) CRUD Operation for Collection of tables in

to a Single Grid.
0
Ananth
Top achievements
Rank 1
answered on 16 Jul 2014, 11:29 AM
u can choose your own table whatever field you want.

your support is valuable to us.

we are eagerly waiting for buy your product.

Thank You.
0
Ananth
Top achievements
Rank 1
answered on 17 Jul 2014, 01:00 PM
hi telerik team,

i asked for one sample application but i didn't get still, may i know can u able to provide.

because need that one very urgent so please be support.
0
Atanas Korchev
Telerik team
answered on 17 Jul 2014, 02:55 PM
Hello Ananth,

The Kendo UI grid doesn't support editing of multiple tables as a single one. You have to bind the grid to a single class which contains the properties of all tables:

public class DataItem
{
    public string PropertyFromTable1 { get; set; }
    public string PropertyFromTable2 { get; set; }
}

Then during update you should extract those properties and update the corresponding tables. 

The Kendo UI offline demos contain runnable implementations of grid editing. You can use them for a reference.

Regards,
Atanas Korchev
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
Tags
Grid
Asked by
Ananth
Top achievements
Rank 1
Answers by
Ananth
Top achievements
Rank 1
Petur Subev
Telerik team
Rene
Top achievements
Rank 1
Atanas Korchev
Telerik team
Share this question
or