SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have customer list in sharepoint 2010 site with a column name company.

In the new item form of the customer i need dropdown list with the name of companies. The thing is i need to fetch this list of companies from database and display in dropdown list.

I know this the possible if i create a web part in visual studio but in that case i need to deploy a new list with all data to be added again ie lots of rework .

i want to avoid it . Pls suggest...

share|improve this question
up vote 1 down vote accepted

If you need exactly drop down, then you can create external list and add lookup for external list to the customers list.

Another way - create external datasource and add external datacolumn to customers list. At this point you will have entity piecker (seem to the user piecker) to choose value.

share|improve this answer
I tried adding external column but it say external content types not available. what i need to do. – Mohit Jan 17 '12 at 11:14
You need to create exernal content type. In the following link you will find instruction how to create external content type based on sql server table. – IAfanasov Jan 17 '12 at 11:23

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.