Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I am creating a visual web part in Visual Studio 2010 for SharePoint 2010 Server. I would like to use a DropDownList that shows data from an external content type (that is tied to a SQL Database table). Does anyone know of a nice tutorial to point me in the right direction?

“A nice to have feature”, I would like to implement is a external content type “picker” in the properties. The functionality should be like the web parts that are found in “Business Data” under web parts.

share|improve this question
    
If you successed, how did you do it? –  e.ozmen May 21 '13 at 20:48
add comment

2 Answers

I would suggest that you should setup Business Connectivity Services if you can. This will allow you to connect to your external data sources in a managed way. You would then setup an External Content type and generate an external list from that. From there you would then query the list for your data and display the results with the dropdown list.

A lot of steps there, however this would be the "SharePoint" way of doing it.

share|improve this answer
add comment

"Nice" is the matter of taste, i.e. subjective.

Internet search gives a plethora of online walkthroughs, step-by-step guides and tutorials on how to implement each of the mentioned aspects , including video- and audiolessons online.

And, it is much simpler to understand short, confined to an isolated topics guides and than use what you need than be buried and confused in over-complicated examples.

Why do you specifically want to show drop-down-list from external sources anв what are the problems with following zillions of tutorials?

If to speak about DDLs, how I call drop-down-lists, I would recommend to look at:.

share|improve this answer
add comment

Your Answer

 
discard

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.