CRUD Operations with two tables

[Ananth]

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.

[Ananth]

hi telerik forum team,

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

really i feel very bad.

[Petur Subev]

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

 

 

[Ananth]

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

[Rene]

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.

[Ananth]

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.

[Ananth]

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.

[Ananth]

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.

[Atanas Korchev]

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