How to list values from picklist in asp.net

All replies

• 

  

  1

  Sign in to vote

  
  

  You will need to use the MS CRM Metadata  service. Please see link below.

  http://msdn.microsoft.com/en-us/library/cc151046.aspx

  
  

  Here is the sample code to retrieve picklist value.

  RetrieveAttributeRequest attributeRequest = new RetrieveAttributeRequest();

  attributeRequest.EntityLogicalName = <Entity Name i.e. contact, account>;

  attributeRequest.LogicalName = <your picklist attribute name>;

  attributeRequest.RetrieveAsIfPublished = true;

  
  

  RetrieveAttributeResponse response = (RetrieveAttributeResponse)metaService.Execute(attributeRequest);

  PicklistAttributeMetadata picklist = (PicklistAttributeMetadata)response.AttributeMetadata;

  
  

  
  

  foreach (Option o in picklist.Options)

  {

      // Get Option value.

  }

  
  

  
  

  You could also do the same using SQL but I would advise against it.

  
  

  Hassan.

  
  

  ---

  Hassan Hussain | http://hassanhussain.wordpress.com/

  • Proposed as answer by Hassan Hussain Friday, June 19, 2009 3:29 PM
  • Marked as answer by Yuhe Friday, June 19, 2009 3:48 PM

  Friday, June 19, 2009 3:29 PM
• 

  

  1

  Sign in to vote

  Hi, Hesper.
  
  Use RetrieveAttribute message to retrieve metadata of your picklist attribute against Execute Method of MetadataService. Cast retrieved in response AttributeMetadata to PicklistAttributeMetadata and use it in your code.
  

  ---

  Truth is opened the prepared mind My blog - http://a33ik.blogspot.com

  Friday, June 19, 2009 3:34 PM

  Moderator
• 

  

  0

  Sign in to vote

  thanks a lot. It's really helpful.
  

  Friday, June 19, 2009 3:48 PM