Hi,

I have a DatePicker that displays the date nicely in the correct format i.e. "2016-05-26" for May 26, 2016.

I would like to handle badly formatted user input, like "160531" which is an allowed way to enter a date in our organisation. I want to take this date and format it correctly with some JS code. The problem is that when I input a date like this I can't get it from the datepicker in my javascript code.

JS Code:

       var date1 = kendo.toString($("#RelevantDate").data("kendoDatePicker").value(), 'd');
        var date2 = $("#RelevantDate").data("kendoDatePicker").value();

both the date1 and the date2 variable are null if I have a date like "160531". With a nicely formatted date everything works.

Is there any way to get a badly formatted date out of the datepicker? I want the users to be able to select the date in the picker and to enter the date manually so changing to a textbox input is not an option.

Best regards,

Henrik
 

Hello,

I have an empty mvc 5 c# project which I basicly put a grid in and that is now working just fine, my problem is styling and its position.

there is no CSS nothing I can see that would make the grid or the .cshtml file behave in this way. It has a margin on the left of about 1/4th of the whole screen.

This is quite annoying , I suspect something in the included stylesheets with the grid is doing this. Its not just the grid this also does the same to the footer that is rendered in the _layout.cshtml.

I want to either put a details column on the left or right of the grid that displays further details about the selected line in the grid.

Suggestions ?

Regards,

Emil 

I have a grid with a foreign key that is displaying a dropdown in in-line edit mode. That's working fine but I would like to display multiple columns from the parent object in that dropdown not just the key as it currently does. How do I configure for that?

Here's what I have

    @(Html.Kendo().Grid<MBSData.Model.DocumentType>()
          .Name("documenttypegrid")
          .HtmlAttributes(new {style = "height:600px;"})
          .Columns(columns =>
          {
              columns.Bound(c => c.DocumentTypeId).Title("Type").Width("120px");
              columns.ForeignKey(p => p.DocumentCategoryId, (System.Collections.IEnumerable) ViewData["DocumentCategories"], "DocumentCategoryId", "DocumentCategoryId")
                  .Title("Category")
                  .Width("120px");
              columns.Bound(c => c.Description);
              columns.Command(command =>
              {
                  command.Edit();
                  command.Destroy();
              }).Width("190px");
          })
          .ToolBar(toolbar => { toolbar.Create(); })
          .Editable(editable => editable.Mode(GridEditMode.InLine))
          .Sortable(sortable => { sortable.SortMode(GridSortMode.MultipleColumn); })
          .Filterable()
          .Scrollable(s => s.Height("auto"))
          .Resizable(resize => resize.Columns(true))
          .DataSource(dataSource => dataSource
              .Ajax()
              .ServerOperation(false)
              .Model(model => model.Id(p => p.DocumentTypeId))
              .Read(read => read.Action("DocumentType_Read", "DocumentType"))
              .Create(create => create.Action("DocumentType_Create", "DocumentType"))
              .Update(update => update.Action("DocumentType_Update", "DocumentType"))
              .Destroy(destroy => destroy.Action("DocumentType_Destroy", "DocumentType"))
          )
          .Events(events => events
              .Edit("onEdit")
          )
          )

Thanks.

Tom

Hi support,

I need to create a Parent/Child grid and both grids must be editable. I've seen some examples in the forum and non of them fit my scenario.

In my case both grids uses local data binding so there's no need for .Create() .Read() .Update() .Destroy() methods in the datasource. One action return the view with the data needed to show in both grids.

The problem I'm facing is that when I add .Editable(ed => ed.Mode(GridEditMode.InCell)) to the child grid without specifying a datasource I get this error:

    An exception of type 'System.NotSupportedException' occurred in Kendo.Mvc.dll but was not handled in user code
    Additional information: There is no DataSource Model Id property specified.

Now if I add a datasource like the one below nothing is shown in the child grid but the header.

I also checked these demos

http://docs.telerik.com/kendo-ui/controls/data-management/grid/how-to/Editing/edit-master-row-data-in-detail-template

http://www.telerik.com/support/code-library/grid-ajax-hierarchy-editing

but both use a datasource with .Create() .Read() .Update() .Destroy() operations in the child grid so they're useless to me.

Is it possible to create the child grid editable without CRUD operations in its datasource?

Any help will be appreciated.

PS: I don't even need the Read operation in the datasource because I already have these data!

Here's my code

View:

The model:

I have a mvc grid with as model { int projectnumber, int Monday }

and code

columns.Bound(c => c.Monday).Title(text: "Monday").ClientFooterTemplate(template: "#=sum#");

.DataSource(datasource => datasource
        .Ajax()
        .Aggregates(aggregates =>
        {
            aggregates.Add(a => a.Monday).Sum();
        })

Now I only want to create the sum over all lines in the grid with exception of the line with project number 1.

The AJAX read gets back [1,1] and [2,4] and [3,5] So I hope to get a sum of 4+5=9 instead of the 10 I get with a normal sum.

I hope myu question is clear and somebody knows how to do a partial sum.

With kind regards,

Maurice Lucas

Good day,

The spreadsheet control doesn't seem to support nested VLOOKUPS eg

=IFERROR(IFERROR(VLOOKUP(alt_ref&"/"&supplierID&"/"&LEFT(courseCode,4)&"*",Calcs!A:G,6,FALSE),VLOOKUP(alt_ref&"/"&supplierID&"/",Calcs!A:G,6,FALSE)),VLOOKUP(alt_ref&"//",Calcs!A:G,6,FALSE))

This works correctly in Excel.

Regards

Derek

I have an ajax connected grid, and I have a button thats a submit button, when I click it it posts the page and the searchstring I have in a textbox.

This is fine and works, I was just wondering if and how I can with jquery get the button to get ajax to fetch the data for the grid? I would like that to happen without a postback if possible, and it should since its an ajax grid.

any ideas ?

Regards,

Emil