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

CrossTab

8 Answers 348 Views

Grid

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

8 Answers, 1 is accepted

answered on 20 Mar 2013, 10:41 AM

Hello!
Thanks for Help!
But can I use DataTable ?

@(Html.Kendo().Grid<System.Data.DataRow>(Model.Rows.Cast<System.Data.DataRow>())

.Name("VolumetricStruct")

.Columns(columns =>

{

foreach (System.Data.DataColumn column in Model.Columns)

{

columns.Bound(column.DataType, column.ColumnName).Title(column.ColumnName);

}

columns.Command(command =>

{

command.Edit();

command.Destroy();

}).Width(300).Title("Действия");

})

.Scrollable(s => s.Height(500))

.DataSource(dataSource => dataSource

.Ajax()

.Model(model => model.Id("idDiameter"))

.Read(read => read.Action("ReadVolumetricStruct", "VolumetricTable"))

.Update(" ", " ")

.Create(" ", " ")

.Destroy(" ", " ")

)

.Editable(editable => editable.TemplateName("VolumetricTable").Mode(GridEditMode.PopUp))

)

To my regret, I get error A circular reference was detected while serializing if I use .Grid<System.Data.DataRow>(Model.Rows.Cast<System.Data.DataRow>

But if I use .Grid(Model)
I get Error : This request has been blocked because sensitive information could be disclosed
And I don't know that i must do :(

Please help if u can!

answered on 20 Mar 2013, 11:55 AM

Hi Gusev,

I would suggest to check the "Binding to DataTable" example in the CodeLibrary which demonstrates how to bind KendoUI Grid for ASP.NET MVC to a DataTable object. Also you can check the Grid documentation for more information about the issues that you mention:

More information about how to fix the "Circular reference" errors can be found in the Grid Troubleshooting article.
More information about the "The request has been blocked" errors can be found in the above article.

Kind Regards,
Vladimir Iliev
the Telerik team

Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!

answered on 03 Apr 2013, 02:26 PM

Hello!!!
I have a question!
I use this example:http://www.kendoui.com/code-library/mvc/grid/binding-to-datatable.aspx
Please show on this example how to edit object (row)

and next:
I have Model:

public class ShrinkCoeffModel

{

[Display(Name = "Толщина (мм)")]

public virtual int Thickness { get; set; }

[Display(Name = "Влажность (%)")]

public virtual string[] Wetness { get; set; }

[Display(Name = "Коэфф. усушки (мм)")]

public virtual decimal[] Coeff { get; set; }

}

and Grid:

@(

Html.Kendo().Grid(Model)

.Name("ShrinkCoeff")

.ToolBar(commands =>

{

commands.Create();

})

.Columns(columns =>

{

columns.Bound(o => o.Thickness);

for (int i = 0; i < Model.FirstOrDefault().Wetness.Count(); i++)

{

columns.Bound(o => o.Wetness[i]);

}

columns.Command(command =>

{

command.Edit();

command.Destroy();

}).Width(210).Title("Действия");

})

.Editable(editable => editable.TemplateName("Item").Mode(GridEditMode.PopUp))

.DataSource(dataBinding => dataBinding

.Server()

.Model(model => model.Id(o => o.Thickness))

.Update("Edit", "ShrinkCoeff")

.Create("Create", "ShrinkCoeff")

.Destroy("Delete", "ShrinkCoeff"))

.Pageable()

.Sortable()

.Selectable()

)

Why Grid dosn't want work with array(
How I can this do?

for (int i = 0; i < Model.FirstOrDefault().Wetness.Count(); i++)

{

columns.Bound(o => o.Wetness[i]);

}