or
<!DOCTYPE html>
<
html
>
<
head
>
<
title
></
title
>
<
script
src
=
"Scripts/jquery.min.js"
type
=
"text/javascript"
></
script
>
<
script
src
=
"Scripts/kendo.web.min.js"
type
=
"text/javascript"
></
script
>
<
link
href
=
"Content/kendo.common.min.css"
rel
=
"stylesheet"
type
=
"text/css"
/>
<
link
href
=
"Content/kendo.blueopal.min.css"
rel
=
"stylesheet"
type
=
"text/css"
/>
</
head
>
<
body
>
<
input
id
=
"datetimepicker"
value
=
"10/10/2011 12:00 AM"
style
=
"width:200px;"
/>
<
script
>
$(document).ready(function () {
// create DateTimePicker from input HTML element
$("#datetimepicker").kendoDateTimePicker();
});
</
script
>
</
body
>
</
html
>
<
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
>