Questions on UI for ASP.NET MVC Forum

1 answer

991 views

custom aggregates

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

Grid

answered on 26 May 2016

3 answers

167 views

Nested VLOOKUPs

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

Spreadsheet

answered on 26 May 2016

2 answers

185 views

[Solved] Ajax connected grid - Posting without postback

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

Grid

answered on 26 May 2016

1 answer

231 views

End dates is updated automatically when start date is changed

When I change the start date of a task in the tree list on the left, the end date is automatically updated. It seems that the system keeps the same number of days between the two dates, but not always. However, if I change the start date in the task editor window (double-click on task bar on the right-hand side), the end date does not get updated by the system. This appears to be inconsistent and undesired behavior. How can I suppress the automatic update of the end date when I change the start date?

Gantt

answered on 26 May 2016

2 answers

385 views

Project Templates of UI for ASP.NET MVC are disappeared

HI

I found that Project Template maybe not installed correctly while install new version of
UI for ASP.NET MVC :

Project Templates of UI for ASP.NET MVC are disappeared after UI for ASP.NET MVC installation.
After restart the Visual Studio the problem is the same.

Why ? Is there have any solution ?

Best regards

Chris

--

Windows 7
Visual Studio 2015
.NET Framework 4.6

Installer and VS Extensions

answered on 25 May 2016

4 answers

1.4K+ views

Update an EditorFor value in a popup editor template using JavaScript

I have a grid that is bound to some data that includes a ProjectID and a Project_Name column. The Project_Name column is a lookup into another database table based on ProjectID, but I return it as part of the result set for simpler display and binding in the grid. The grid's edit mode is PopUp and I have created an EditorTemplate with a Kendo ComboBox that is bound to ProjectID for value and Project_Name for display. When you change the ProjectID and click Update, the new ProjectID is persisted in the DB, but the Project_Name value doesn't change unless I refresh the page or the grid. I have all the information that I need to be able to assign the new Project_Name to the row, so I do not want to have to rebind the grid or refresh the page just to do this.

Now, I know that controls in the templated pop-up that are bound to the model will automatically update the grid's dataItem when they change. If I add an Html.TextBoxFor(o => o.Project_Name) to the editor and type a new value into it, I can see it change in the grid at the same time. I was planning to hide this textbox and update its value in JavaScript when the ProjectID's combobox value changes in order to update the grid's dataItem, but after some experimentation, I have found that changing the Project_Name textbox's value with JavaScript does not update the grid's dataItem; only typing into it does. I have tried updating the textbox's value both by using the JQuery val() method and by accessing the HTML input's value property directly. I cannot see any event handlers attached to the textbox, so I don't understand the mechanism by which the value that I type in is sent back to the grid, while a value assigned in JavaScript is not sent back.

So, a few questions:
1. Why does the bound textbox update the grid's dataItem when I type a value in, but not when I assign a value via JavaScript?
2. Is there a way for me to trigger the bound checkbox to update the grid's dataItem after I update the value in JavaScript?
3. Is this the best way for me to update Project_Name in the edited row in the grid, or is there a better way to do so without having to rebind the grid or refresh the page?

Grid

answered on 25 May 2016

5 answers

245 views

ListView template with unnamed Datasource members

I am binding a ListView to a collection of strings. How can I access that data in the template definition? Model.SearchResults is a type of IEnumberable<string>

@(Html.Kendo().ListView(Model.SearchResults)

.Name("listClients")

.TagName("div")

.ClientTemplateId("clientsTemplate")

.Pageable(pageable => pageable

.PreviousNext(true)

.Info(true)

.PageSizes(true))

.HtmlAttributes(new{style="min-height:300px"})

.DataSource(dataSource => dataSource

.PageSize(1)))

<script type="text/x-kendo-tmpl" id="clientsTemplate">

@Html.Action("LoadProfileView", new { clientId = **HOW DO I GET THE VALUE HERE**})

</script>

ListView

answered on 25 May 2016

4 answers

176 views

Fever chart with Bubble chart

Hi How to draw a fever chart in Kendo bubble chart in ASP.Net MVC . PFA. I would like to draw a background for the buble chart

I got a code for scatter but it is not working for Buble

http://docs.telerik.com/kendo-ui/controls/charts/how-to/draw-on-scatter-plots

Chart

answered on 24 May 2016

5 answers

624 views

Progress Indicator on PopUp Window

Hi,

I'm using a grid with PopUp edit mode, using a template, declared like this:

...
.Editable(editable => editable
.Mode(GridEditMode.PopUp)
.TemplateName("CompanyEditorTemplate")
.Window(w => w.Title("Gestione Cliente")))
...

All works fine. But I'd like to add progress indicator to the window using this kendo.ui.progress($("#gridClienti"), true) but the problem is that I can't retrieve the window div element to pass to this function. I tried to add ID throw HtmlAttributes() method but it doesn't work.

Any suggestion will be appreciated.

Thanks!!

Grid

answered on 24 May 2016

3 answers

165 views

Spreadsheet - Defined Name for Formulas

I want to be able to use Defined Name when creating my spreadsheet so that I can use them in formulas. IE instead of having to create a formula that is

= SUM(A1:A20) I define A1 to A20 a name "Period1" and then I can do things like = SUM(Period1 Apples) etc. How do you create the Defined Names in the Spreadsheet and does the formulas then support this feature. Also when exporting the spreadsheet to excel do the formulas and names export?

Thanks

Lee

Spreadsheet

answered on 23 May 2016