<div id="workshopsTableContainer"> <table id="workshopsTable" class="table table-hover table-bordered"> <thead> <tr> <th>Site</th> <th>Date/Time</th> <th>Evaluation Code</th> <th></th> </tr> </thead> <tbody data-template="workshopsTableRowTemplate" data-bind="source: workshops"></tbody> </table></div><script id="workshopsTableRowTemplate" type="text/x-kendo-tmpl"><tr> <td data-bind="text: site_id"></td> <td data-bind="text: workshop_date"></td> <td data-bind="text: evaluation_code"></td> <td><a class="btn btn-primary">Edit</a></td></tr></script>$(function(){ workshopViewModel = kendo.observable({ workshops: new kendo.data.DataSource({ transport: { read: { url: "/applications/wms/components/API.cfc?method=read", dataType: "json", data: {objType: "workshop", organization_id: 944}, type: "POST", cache: false }, parameterMap: function(options, operation) { if (operation !== "read" && options.models) { return {models: kendo.stringify(options.models)}; } return options; } }, schema: { data: "data", total: "recordcount", type: "json", model: Workshop }, batch: false }) }); kendo.bind($("#workshopsTableContainer"), workshopViewModel);})var Workshop = kendo.data.Model.define( { id: "workshop_id", fields: { "workshop_id": { type: "number", editable: true, nullable: false }, "site_id": { type: "number", editable: true, nullable: false }, "workshop_date": { type: "string", editable: true, nullable: false }, "evaluation_code": { type: "string", editable: true, nullable: false } }});{"message":"","success":true,"recordcount":5,"data":[{"organization_date_created":"November, 03 2010 20:17:26","organizer_approved":1,"organizer_extension":132.0,"organizer_login_token":"9D31858C-9448-AA47-F48C02E67A5733BF","site_county_id":39,"organization_oap":"<\/string><\/var><\/string><\/var><\/string><\/var>200<\/string><\/var>1,2,3,12,13,17,18<\/string><\/var><\/struct><\/data><\/wddxPacket>","organizer_role":"Organizer","approved":0,"manager_full_name":"Angelique Adams","site_id":865,"site_zip_code":95330.0,"pb_notes":"","site_site_type":"College Campus","manager_deleted":0,"start_date_time":"February, 03 2010 18:00:00","site_organization_id":944,"manager_extension":132.0,"site_deleted":0,"query_date":"October, 01 2012 09:45:26","organizer_region_ids":"","manager_first_name":"Angelique ","organization_id":944,"manager_role":"Organizer","site_address":"16916 S Harlan Rd","site_date_created":"November, 03 2010 20:25:40","manager_date_created":"November, 03 2010 20:17:26","organizer_organization_id":944,"organization_pa":1,"organization_zip_code":95330.0,"manager_organization_id":944,"organizer_last_name":"Adams","organizer_full_name":"Angelique Adams","start_time":"6:00 PM","organizer_phone":"209-858-0077","manager_password":"angel1031","site_site":"ITT Technical Institute","pb_survey_count":0,"organizer_organization3_id":0,"manager_id":95599,"pb_shipped_date":"","organizer_email":"ajadams@itt-tech.edu","organizer_organization2_id":0,"manager_title":"Director of Finance","date_created":"November, 03 2010 20:25:40","organization_organization":"ITT Technical Institute","site_computers":"10 to 20","organization_approved":1,"workshop_date":"2\/3\/2010","organization_city":"Lathrop","organizer_date_created":"November, 03 2010 20:17:26","organizer_organization_id2":"","manager_organization3_id":0,"organizer_first_name":"Angelique ","evaluation_code":"6ztee","organizer_organization_id3":"","organizer_id":95599,"manager_last_name":"Adams","manager_email":"ajadams@itt-tech.edu","organization_logged_in":1,"site_city":"Lathrop","manager_organization_id2":"","manager_phone":"209-858-0077","manager_organization2_id":0,"workshop_id":2120,"manager_organization_id3":"","organizer_title":"Director of Finance","manager_login_token":"9D31858C-9448-AA47-F48C02E67A5733BF","deleted":0,"organization_deleted":0,"manager_region_ids":"","organizer_deleted":0,"pb_survey_count_status":"Uninitiated","manager_approved":1,"organization_county_id":39,"organizer_password":"angel1031","end_date_time":"February, 03 2010 19:00:00","organization_address":"16916 S Harlan Rd","end_time":"7:00 PM"},{"organization_date_created":"November, 03 2010 20:17:26","organizer_approved":1,"organizer_extension":132.0,"organizer_login_token":"9D31858C-9448-AA47-F48C02E67A5733BF","site_county_id":39,"organization_oap":"<\/string><\/var><\/string><\/var><\/string><\/var>200<\/string><\/var>1,2,3,12,13,17,18<\/string><\/var><\/struct><\/data><\/wddxPacket>","organizer_role":"Organizer","approved":1,"manager_full_name":"Angelique Adams","site_id":865,"site_zip_code":95330.0,"pb_notes":"","site_site_type":"College Campus","manager_deleted":0,"start_date_time":"February, 26 2011 11:00:00","site_organization_id":944,"manager_extension":132.0,"site_deleted":0,"query_date":"October, 01 2012 09:45:26","organizer_region_ids":"","manager_first_name":"Angelique ","organization_id":944,"manager_role":"Organizer","site_address":"16916 S Harlan Rd","site_date_created":"November, 03 2010 20:25:40","manager_date_created":"November, 03 2010 20:17:26","organizer_organization_id":944,"organization_pa":1,"organization_zip_code":95330.0,"manager_organization_id":944,"organizer_last_name":"Adams","organizer_full_name":"Angelique Adams","start_time":"11:00 AM","organizer_phone":"209-858-0077","manager_password":"angel1031","site_site":"ITT Technical Institute","pb_survey_count":0,"organizer_organization3_id":0,"manager_id":95599,"pb_shipped_date":"","organizer_email":"ajadams@itt-tech.edu","organizer_organization2_id":0,"manager_title":"Director of Finance","date_created":"January, 18 2011 09:21:32","organization_organization":"ITT Technical Institute","site_computers":"10 to 20","organization_approved":1,"workshop_date":"2\/26\/2011","organization_city":"Lathrop","organizer_date_created":"November, 03 2010 20:17:26","organizer_organization_id2":"","manager_organization3_id":0,"organizer_first_name":"Angelique ","evaluation_code":"icr9w","organizer_organization_id3":"","organizer_id":95599,"manager_last_name":"Adams","manager_email":"ajadams@itt-tech.edu","organization_logged_in":1,"site_city":"Lathrop","manager_organization_id2":"","manager_phone":"209-858-0077","manager_organization2_id":0,"workshop_id":2688,"manager_organization_id3":"","organizer_title":"Director of Finance","manager_login_token":"9D31858C-9448-AA47-F48C02E67A5733BF","deleted":0,"organization_deleted":0,"manager_region_ids":"","organizer_deleted":0,"pb_survey_count_status":"Uninitiated","manager_approved":1,"organization_county_id":39,"organizer_password":"angel1031","end_date_time":"February, 26 2011 13:00:00","organization_address":"16916 S Harlan Rd","end_time":"1:00 PM"},{"organization_date_created":"November, 03 2010 20:17:26","organizer_approved":1,"organizer_extension":132.0,"organizer_login_token":"9D31858C-9448-AA47-F48C02E67A5733BF","site_county_id":39,"organization_oap":"<\/string><\/var><\/string><\/var><\/string><\/var>200<\/string><\/var>1,2,3,12,13,17,18<\/string><\/var><\/struct><\/data><\/wddxPacket>","organizer_role":"Organizer","approved":1,"manager_full_name":"Angelique Adams","site_id":865,"site_zip_code":95330.0,"pb_notes":"","site_site_type":"College Campus","manager_deleted":0,"start_date_time":"February, 03 2011 18:00:00","site_organization_id":944,"manager_extension":132.0,"site_deleted":0,"query_date":"October, 01 2012 09:45:26","organizer_region_ids":"","manager_first_name":"Angelique ","organization_id":944,"manager_role":"Organizer","site_address":"16916 S Harlan Rd","site_date_created":"November, 03 2010 20:25:40","manager_date_created":"November, 03 2010 20:17:26","organizer_organization_id":944,"organization_pa":1,"organization_zip_code":95330.0,"manager_organization_id":944,"organizer_last_name":"Adams","organizer_full_name":"Angelique Adams","start_time":"6:00 PM","organizer_phone":"209-858-0077","manager_password":"angel1031","site_site":"ITT Technical Institute","pb_survey_count":0,"organizer_organization3_id":0,"manager_id":95599,"pb_shipped_date":"","organizer_email":"ajadams@itt-tech.edu","organizer_organization2_id":0,"manager_title":"Director of Finance","date_created":"January, 18 2011 09:22:27","organization_organization":"ITT Technical Institute","site_computers":"10 to 20","organization_approved":1,"workshop_date":"2\/3\/2011","organization_city":"Lathrop","organizer_date_created":"November, 03 2010 20:17:26","organizer_organization_id2":"","manager_organization3_id":0,"organizer_first_name":"Angelique ","evaluation_code":"xz8us","organizer_organization_id3":"","organizer_id":95599,"manager_last_name":"Adams","manager_email":"ajadams@itt-tech.edu","organization_logged_in":1,"site_city":"Lathrop","manager_organization_id2":"","manager_phone":"209-858-0077","manager_organization2_id":0,"workshop_id":2689,"manager_organization_id3":"","organizer_title":"Director of Finance","manager_login_token":"9D31858C-9448-AA47-F48C02E67A5733BF","deleted":0,"organization_deleted":0,"manager_region_ids":"","organizer_deleted":0,"pb_survey_count_status":"Uninitiated","manager_approved":1,"organization_county_id":39,"organizer_password":"angel1031","end_date_time":"February, 03 2011 20:00:00","organization_address":"16916 S Harlan Rd","end_time":"8:00 PM"},{"organization_date_created":"November, 03 2010 20:17:26","organizer_approved":1,"organizer_extension":132.0,"organizer_login_token":"9D31858C-9448-AA47-F48C02E67A5733BF","site_county_id":39,"organization_oap":"<\/string><\/var><\/string><\/var><\/string><\/var>200<\/string><\/var>1,2,3,12,13,17,18<\/string><\/var><\/struct><\/data><\/wddxPacket>","organizer_role":"Organizer","approved":0,"manager_full_name":"Angelique Adams","site_id":865,"site_zip_code":95330.0,"pb_notes":"","site_site_type":"College Campus","manager_deleted":0,"start_date_time":"January, 07 2013 17:00:00","site_organization_id":944,"manager_extension":132.0,"site_deleted":0,"query_date":"October, 01 2012 09:45:26","organizer_region_ids":"","manager_first_name":"Angelique ","organization_id":944,"manager_role":"Organizer","site_address":"16916 S Harlan Rd","site_date_created":"November, 03 2010 20:25:40","manager_date_created":"November, 03 2010 20:17:26","organizer_organization_id":944,"organization_pa":1,"organization_zip_code":95330.0,"manager_organization_id":944,"organizer_last_name":"Adams","organizer_full_name":"Angelique Adams","start_time":"5:00 PM","organizer_phone":"209-858-0077","manager_password":"angel1031","site_site":"ITT Technical Institute","pb_survey_count":0,"organizer_organization3_id":0,"manager_id":95599,"pb_shipped_date":"","organizer_email":"ajadams@itt-tech.edu","organizer_organization2_id":0,"manager_title":"Director of Finance","date_created":"September, 22 2012 12:43:38","organization_organization":"ITT Technical Institute","site_computers":"10 to 20","organization_approved":1,"workshop_date":"1\/7\/2013","organization_city":"Lathrop","organizer_date_created":"November, 03 2010 20:17:26","organizer_organization_id2":"","manager_organization3_id":0,"organizer_first_name":"Angelique ","evaluation_code":"uhc3a","organizer_organization_id3":"","organizer_id":95599,"manager_last_name":"Adams","manager_email":"ajadams@itt-tech.edu","organization_logged_in":1,"site_city":"Lathrop","manager_organization_id2":"","manager_phone":"209-858-0077","manager_organization2_id":0,"workshop_id":3520,"manager_organization_id3":"","organizer_title":"Director of Finance","manager_login_token":"9D31858C-9448-AA47-F48C02E67A5733BF","deleted":0,"organization_deleted":0,"manager_region_ids":"","organizer_deleted":0,"pb_survey_count_status":"Uninitiated","manager_approved":1,"organization_county_id":39,"organizer_password":"angel1031","end_date_time":"January, 07 2013 19:00:00","organization_address":"16916 S Harlan Rd","end_time":"7:00 PM"},{"organization_date_created":"November, 03 2010 20:17:26","organizer_approved":1,"organizer_extension":132.0,"organizer_login_token":"9D31858C-9448-AA47-F48C02E67A5733BF","site_county_id":39,"organization_oap":"<\/string><\/var><\/string><\/var><\/string><\/var>200<\/string><\/var>1,2,3,12,13,17,18<\/string><\/var><\/struct><\/data><\/wddxPacket>","organizer_role":"Organizer","approved":0,"manager_full_name":"Angelique Adams","site_id":865,"site_zip_code":95330.0,"pb_notes":"","site_site_type":"College Campus","manager_deleted":0,"start_date_time":"February, 07 2013 17:00:00","site_organization_id":944,"manager_extension":132.0,"site_deleted":0,"query_date":"October, 01 2012 09:45:26","organizer_region_ids":"","manager_first_name":"Angelique ","organization_id":944,"manager_role":"Organizer","site_address":"16916 S Harlan Rd","site_date_created":"November, 03 2010 20:25:40","manager_date_created":"November, 03 2010 20:17:26","organizer_organization_id":944,"organization_pa":1,"organization_zip_code":95330.0,"manager_organization_id":944,"organizer_last_name":"Adams","organizer_full_name":"Angelique Adams","start_time":"5:00 PM","organizer_phone":"209-858-0077","manager_password":"angel1031","site_site":"ITT Technical Institute","pb_survey_count":0,"organizer_organization3_id":0,"manager_id":95599,"pb_shipped_date":"","organizer_email":"ajadams@itt-tech.edu","organizer_organization2_id":0,"manager_title":"Director of Finance","date_created":"September, 22 2012 12:44:08","organization_organization":"ITT Technical Institute","site_computers":"10 to 20","organization_approved":1,"workshop_date":"2\/7\/2013","organization_city":"Lathrop","organizer_date_created":"November, 03 2010 20:17:26","organizer_organization_id2":"","manager_organization3_id":0,"organizer_first_name":"Angelique ","evaluation_code":"ib96k","organizer_organization_id3":"","organizer_id":95599,"manager_last_name":"Adams","manager_email":"ajadams@itt-tech.edu","organization_logged_in":1,"site_city":"Lathrop","manager_organization_id2":"","manager_phone":"209-858-0077","manager_organization2_id":0,"workshop_id":3521,"manager_organization_id3":"","organizer_title":"Director of Finance","manager_login_token":"9D31858C-9448-AA47-F48C02E67A5733BF","deleted":0,"organization_deleted":0,"manager_region_ids":"","organizer_deleted":0,"pb_survey_count_status":"Uninitiated","manager_approved":1,"organization_county_id":39,"organizer_password":"angel1031","end_date_time":"February, 07 2013 20:00:00","organization_address":"16916 S Harlan Rd","end_time":"8:00 PM"}]}I have a dropdownlist in a grid. When I put a row in edit mode and change the selected value of the ddl, the data sent to my update procedure is the value field (i.e. 1, 5, 7). What I want to send is the text field (i.e. Apples, Oranages, Bananas).
How can I ensure the text value of the dropdownlist is being sent to my update method?
If I don't change the selection it works like I want (meaning the text value is sent to my update procedure). Only when I change the selected value the parameter value sent is the value field.
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server"> <div id="grid"> </div> <script type="text/javascript"> $(document).ready(function () { $("#grid").kendoGrid({ //height: 260, toolbar: ["create"], columns: [ "DepartmentID", { field: "FRSAccountNumber", title: "FRS Account No", sortable: true, filterable: true }, { field: "DepartmentName", title: "Dept Name", sortable: true, filterable: true }, { field: "CollegeName", width: "150px", editor: categoryDropDownEditor }, { field: "SubjectArea", title: "Subj Area", sortable: true, filterable: true }, { command: ["edit", "destroy"], title: " ", width: "210px", filterable: false } ], editable: "inline", dataSource: { //batch: true, pageSize: 10, schema: { data: function (data) { return data.d || []; }, type: "json", total: "d.length", model: { id: "DepartmentID", fields: { DepartmentID: { type: "number" }, FRSAccountNumber: { type: "string" }, DepartmentName: { type: "string" }, CollegeName: "CollegeName", SubjectArea: { type: "string" } }//fields }//model }, //schema transport: { read: { url: "Web/KendoDS.asmx/ReadDepartments", contentType: "application/json; charset=utf-8", type: "POST" }, //read update: { url: "Web/KendoDS.asmx/Update", contentType: "application/json; charset=utf-8", // tells the web service to serialize JSON type: "POST" //use HTTP POST request as the default GET is not allowed for ASMX }, parameterMap: function (data, operation) { if (operation != "read") { return JSON.stringify({ dept: data }); } } }//transport }, //dataSource pageable: true }); var categoryDataSource = new kendo.data.DataSource({ transport: { read: { url: "Web/KendoDS.asmx/GetColleges", contentType: "application/json; charset=utf-8", type: "POST" } }, schema: { data: "d" } }); function categoryDropDownEditor(container, options) { $('<input data-text-field="CollegeName" data-value-field="Ranking" data-bind="value:' + options.field + '"/>') .appendTo(container) .kendoDropDownList({ autoBind: false, dataSource: categoryDataSource }); } }); </script></asp:Content><select data-role="dropdownlist" data-bind="source: type, value: expenseType"> <span data-text-field="name" data-value-field="value" ></select><select data-role="dropdownlist" data-bind="source: type, value: expenseType" data-text-field="name" data-value-field="value" ></select>I am new to kendoUI and facing a few issues
1. not able to get the grid reference. (for changing the grid properties)
var grd = $("#grid").data("kendoGrid"); // Not working. grd is shown as undefined.
2. DataBound event is not recognized.
Please let me know what i am I missing here.
Please find my code below
<div class="k-content">
@(Html.Kendo().Grid(Model)
.Name("grid")
.Columns(columns =>
{
columns.Bound(company => company.Id).Hidden();
columns.Bound(company => company.CompanyName).Sortable(true).Width(120);
columns.Bound(company => company.Email).Sortable(true).Width(150);
columns.Bound(company => company.CompanyAddressAddress1).Width(120);
columns.Bound(company => company.CompanyAddressAddress2).Width(120);
columns.Bound(company => company.CompanyAddressCity);
columns.Bound(company => company.CompanyAddressStateAbbreviation).Width(80);
columns.Bound(company => company.CompanyAddressZip).Width(100);
columns.Command(command =>
{
command.Edit();
command.Destroy();
}).Width(180);
})
.ToolBar(toolbar => toolbar.Create())
.Editable(ed => ed.Mode(GridEditMode.PopUp).TemplateName("CompanyCreate")
.Window(window => window.Title("Company Profile").Name("CompanyEdit"))
)
.Groupable()
.Pageable()
.Sortable()
.Scrollable()
.Filterable()
.DataSource(dataSource => dataSource
.Ajax()
.ServerOperation(false)
.Events(
events =>
{
//events.Change("");
events.Error("error_handler");
events.DataBound("reload_grid");//gives error
}
)
.Model(model => model.Id(company => company.Id))
.Create(update => update.Action("CompanyCreate", "Company", new { act = "Create" }))
.Update(update => update.Action("CompanyUpdate", "Company", new { act = "Update" }))
.Destroy(update => update.Action("CompanyDestroy", "Company"))
.Read(read => read.Action("CompanyRead", "Company"))
)
)
<script type="text/javascript">
// get a reference to the grid
var grd = $("#grid").data("kendoGrid"); // Not working. grd is shown as undefined.
$(".k-grid-add").on("click", function (e) {
var insertMode = e.model.isNew(); //gives error
var window = e.container.data("kendoWindow");//gives error
e.container.kendoWindow("title", "Add new record");//gives error.
});
function reload_grid(e) {
//alert("reload");
}
</script>.

