{"id":743,"date":"2012-06-10T14:44:42","date_gmt":"2012-06-10T14:44:42","guid":{"rendered":"http:\/\/mahenderpal.wordpress.com\/?p=743"},"modified":"2015-10-05T09:50:51","modified_gmt":"2015-10-05T09:50:51","slug":"show-ms-crm-2011-optionest-values-in-dropdownlist-in-asp-net","status":"publish","type":"post","link":"https:\/\/himbap.com\/blog\/?p=743","title":{"rendered":"Show MS CRM Optionset values in Dropdownlist in Asp.net"},"content":{"rendered":"

Sometime customers have requirement to create MS CRM records through custom asp.net pages, and if we have optionset in our entity we might want to display optionset valeus in dropdownlist in our Web page. We can use following code to populate\u00a0optionset values in dropdownlist.<\/p>\n

public\u00a0Dictionary<\/span><\/span><\/span><<\/span><\/span>int<\/span><\/span><\/span>, <\/span><\/span>string<\/span><\/span><\/span>> RetrieveOptionsetMetadata(<\/span><\/span>IOrganizationService <\/span><\/span><\/span>_iOgranizationService)<\/span><\/p>\n

{\u00a0\/\/Dictionary to store value and text<\/span><\/p>\n

Dictionary<\/span><\/span><\/span><<\/span><\/span>int<\/span><\/span><\/span>,<\/span><\/span>string<\/span><\/span><\/span>> _DropdownDatasource=<\/span><\/span>new<\/span><\/span><\/span>Dictionary<\/span><\/span><\/span><<\/span><\/span>int<\/span><\/span><\/span>,<\/span><\/span>string<\/span><\/span><\/span>>();<\/span><\/p>\n

\/\/Create request to fetch optionset<\/span><\/p>\n

RetrieveAttributeRequest<\/span><\/span><\/span> _Request = <\/span><\/span>new\u00a0<\/span><\/span><\/span>RetrieveAttributeRequest<\/span>{<\/p>\n

EntityLogicalName =“EntityName”<\/span><\/span><\/span>, \/\/Change entity name here<\/span><\/p>\n

LogicalName =“OptionsetFieldName”<\/span><\/span><\/span>, \/\/Change field name here<\/span><\/p>\n

RetrieveAsIfPublished =true<\/span><\/p>\n

};<\/p>\n

\/\/ Execute the request<\/span><\/p>\n

RetrieveAttributeResponse<\/span><\/span><\/span> _Response =(<\/span><\/span>RetrieveAttributeResponse<\/span><\/span><\/span>)_iOgranizationService.Execute(_Request);<\/span><\/p>\n

PicklistAttributeMetadata<\/span><\/span><\/span> _PicklistAttributeMetadata = (<\/span><\/span>PicklistAttributeMetadata<\/span><\/span><\/span>)_Response.AttributeMetadata;<\/span><\/p>\n

OptionMetadata<\/span><\/span><\/span>[] optionList =_PicklistAttributeMetadata.OptionSet.Options.ToArray();<\/span><\/p>\n

foreach<\/span><\/span><\/span> (<\/span><\/span>OptionMetadata<\/span><\/span><\/span> _Optionset <\/span><\/span>in <\/span><\/span><\/span>optionList) {<\/span><\/p>\n

_DropdownDatasource.Add(int<\/span><\/span><\/span>.Parse(_Optionset.Value.ToString()), _Optionset.Label.UserLocalizedLabel.Label);<\/span><\/p>\n

}<\/p>\n

return <\/span><\/span><\/span>_DropdownDatasource;<\/span><\/p>\n

}<\/p>\n

After that we can set datasource for dropdownlist like below<\/p>\n

DropDownList1.DataSource = RetrieveOptionsetMetadata(_iOgranizationService);<\/p>\n

DropDownList1.DataBind();<\/p>\n

Enjoy !!!<\/p>\n","protected":false},"excerpt":{"rendered":"

Sometime customers have requirement to create MS CRM records through custom asp.net pages, and if we have optionset in our entity we might want to display optionset valeus in dropdownlist in our Web page. We can use following code to populate\u00a0optionset values in dropdownlist. public\u00a0Dictionary<int, string> RetrieveOptionsetMetadata(IOrganizationService _iOgranizationService) {\u00a0\/\/Dictionary to store value and text Dictionary<int,string> _DropdownDatasource=newDictionary<int,string>(); \/\/Create request to fetch… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2,3,5],"tags":[],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/743"}],"collection":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=743"}],"version-history":[{"count":4,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/743\/revisions"}],"predecessor-version":[{"id":1691,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/743\/revisions\/1691"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=743"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=743"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=743"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}