Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

multi select column from BDC

  Asked By: Jesse    Date: Oct 06    Category: Sharepoint    Views: 1330

Is it possible to derive a content type column from BDC? if not is it possible to populate a sharepoint list from BDC? I am have a Job Title column values coming from external db thru BDC. I am looking for a way to have a multiple select from BDC.

if the above is not possible at all, is it good idea to add/update/delete sharepoint list data from backend using transact-sql(not sure if this is possible...everywhere i read DO NOT modfiy content database using sql)

Thanks a lot folks if you can direct me to a good resource

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Eashan Nadkarni     Answered On: Oct 06

Multi select  column from a BDC is not possible. Looks like they had in beta version of MOSS 2007 but not in production. So i approached the alternate way of populating sharepoint  list from external  table using sharepoint's webservices and CAML.

below link can demonstrate step by step instruction.

msdn.microsoft.com/en-us/library/ms440289.aspx

if the external table is from a sql server database, alternatively we can use SSIS
http://www.devx.com/dotnet/Article/35070/0/page/1

 
Didn't find what you were looking for? Find more on multi select column from BDC Or get search suggestion and latest updates.




Tagged: