.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Join Entities in BDC For Business Data Field In List

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :SharePoint


I'm having a devil of a time joining two tables for a BDC to be used as a Business Data field in a list. I've seen plently of examples  connecting two tables to use with web parts, however i haven't seen anything about using an association in a list. Before i continue to beat myself up i need to know that this is possible.


If that's confusing here's what i'm trying to do.

I have two tables Locations and Region. I need the Region_Name from the region table based on the Location_Id (primary key) from the Location table. Locations is connected to Region by Region_id as a foreign key.


Any help would be immensely appreciated.

View Complete Post

More Related Resource Links

Business Data List web part, format field from database as hyperlink


I have a BDC with an entity that selects fields from a table. One of the fields is the full pathname to a file, or it could be a hyperlink.
When I display the entity in a Business Data List Web Part, all fields are displayed as text, without any formatting. I know the formatting can be modified using the XSL editor (under modify web part), I have found a sample with date-time format . Some basic formatting can also be done with de sharePoint designer, but nowhere have I found an example that allows me to format the column with the link as a clickable hyperlink.
My strong points are sql server and .net , but not XSL , can anyone give me an example of how th eformatting needs to be done in XSL?

tnx in advance

Jan D'Hondt - Database and .NET development

Read data from BLOB field and write to sharepoint list

Hi, I want to read the data from BLOB field and write it into sharepoint list item. Please provide some pointer to archive above objective.   Thanks in Advance.

Calculated date field displays differently in List View and Data View web parts

In SharePoint GUI I created a simple custom list with a calculated Date/Time field (Due).  The calculation is =[Created]+7.  I'm trying to display this data on a page using a DVWP.  But first, for testing purposes, I also created a second calculated Date/Time (TestCreate) field in my custom list that is simply =[Created]. In the List View from within SharePoint, the dates show as expected (for example): Created = 8/12/2010 3:45 PM Due = 8/19/2010 3:45 PM TestCreate = 8/12/2010 3:45 PM In SharePoint Designer, I added a Data View web part and the above three data elements (each configured to display mm/dd/yyyy hh:mm:ss tt).  I see the time displayed for the example list item as: Created = 8/12/2010 3:45:30 PM Due = 8/19/2010 10:45:00 AM TestCreate = 8/12/2010 10:45:00 AM I've tested a couple scenarios and the calculated fields always display five hours in the past (along with dropping the seconds).  It seems like the DVWP is returning the date in a different time zone (with no seconds).  The lcid is set right (1033).  I didn't see any time zone settings for the DVWP specifically.  I'm basically stuck.  Could someone help me figure this one out. Thanks.

Business Data List Menu Questions

I've got two questions relating to the business data list.  I took a look at the following article which seems to indicate this can happen, but I wasn't clear on how: http://sharepointmagazine.net/technical/administration/everything-you-need-to-know-about-bdc-part-4-of-8 First, in the section where it discusses the Business Data Actions, at one point it says "Incidentally, you can also access these actions by clicking the View Profile context menu as shown here", but I have yet to be able to get said context menu to appear in the data list.  I setup my BDC connection, have the data list displaying data, connected it to the actions webpart which shows the available actions, but there seems to be no context menu.  No dice here.   Second, in the Business Data List Advanced Settings section, it mentions "Keep in mind that the XSL contains not only the HTML results, it also contains the HTML for the selection criteria, the Actions toolbar, and the column headers."  I am wanting to add options in the mentioned Actions toolbar, but I don't seem to understand how to do so at this point.   Hopefully someone in this community can shed some light.  If I come across the answer, I'll be sure to update.

Binding list to form not working with '&' character in list field data

Hi, I have a SharePoint list with a field called Title. I have a form based on this list with the field bound to the form as a label (for workflow to access). Here is the code for the form field. <asp:Label runat="server" id="ff2{$Pos}" text="{@Title}" __designer:bind="{ddwrt:DataBind('u',concat('ff2',$Pos),'Text','','ID',ddwrt:EscapeDelims(string(@ID)),'@Title')}" /> I have a workflow that runs through a form action button which take ff2 (title) and  does other stuff. The problem I have is with records where the value of 'title' contains the '&' character (example ab&cd). Blank is pulled in by the workflow when I get the value of ff2. I am guessing it has to do with the data binding and/or escape (special) characters coming through but I don't know how to fix it. Any help will be greatly appreciated

problem in Business Data list webpart

<Entity EstimatedInstanceCount="100" Name="Customer">



problem in Business Data list webpart

<Entity EstimatedInstanceCount="100" Name="Customer">



show search result as default parameters when initiation of business data list



I want to show search result as default parameters when initiation of business data list.

Is there any solution to solve this problem. Thanks.

Submitting data to a lookup field in a SharePoint list


I'm trying to submit values to a SharePoint list that contains text fields and lookup fields.  I'm doing this with a WebServiceConnection and an XML file.  When I execute the submit without the lookup field, it works perfectly.  When I execute the submit with the lookup field it doesn't error out but my list is not updated.  Can anyone help?

Issue Displaying Data from Oracle using Business Data List WebPart


I have issue retrieving data from a remote oracle database using Business Data List WebPart. I have created an BDC definition
file using the BDC Meta Man tool. Then I imported this defination file into the Shared Services, so no issue it successfully
imported the file.

Now when I try to display the data using Business Data List WebPart, it fails to display any data. It gets the column headings
but no data. I get an error stating "An error occurred while retrieving data from OracleInstance. Administrators, see the server
log for more information."

The SharePoint log has the following exception:

Exception handed to HandleRuntimeException.HandleException System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.     at System.Data.OracleClient.OCI.DetermineClientVersion()     at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)     at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)     at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConn

Data Form Web Part - Sharepoint Dropdown List as a field in Edit View - Possible?


Hi guys,

I'm building a Sharepoint page with a data form web part that uses custom SELECT and UPDATE statements with an SQL Server connection in order to retrieve and store records of information.

I'm getting along fine, records seem to update how they should etc, but I've ran into a problem with one thing: Sharepoint dropdownlists in 'Edit Template'

So the issue is this: if I replace a textbox field with a dropdown list that is populated with a separate SQL datasource, the dropdown list seems to be unable to show the current value of the field.

E.g. I have a dataview which has a field "FruitID", which I can update just fine by setting the ID value to different numbers. The SQL datasource uses the FruitID to display a list of all available Fruits, (e.g. 1 = Banana, 2 = Apple, 3 = Cherry, etc).

If i open the dataview in editmode, the default value in the dropdown is null, despite the real value of the field being "2", which should show "Apple" in the dropdown.

I can select a fruit and click save, and it will update just fine. But the initial display needs to show the correct value to start with.

Is there a custom binding I should be coding to make this work? I can't configure dropdown <items> on an individual level as they are populated from the SQL server. I can't set "SelectedI

External List Error - Access denied by Business Data Connectivity


Hello Community,

Background: In SPS 2010 I created an External Content Type that is displaying the Customers table from a Customers database in SQL Server 2008. (I also added myself as the DBO for that database.) I configured the ECT to authenticate with the User's Identity and to also use the Secondary Secure Store Application ID "contoso\administrators". I then added both these accounts to the Business Data Connectivity Service and granted them all four permission sets. I configured the ECT Operations to perform all operations, and I filtered the return by limiting it to a 100 items.  Using the Create List and Form wizard I then created an External List from the ECT. 

Problem: When I display the External List in the browser I get this error - Access denied by Business Data Connectivity.

I have read several blogs about this issue (which seems to be common) but I still can't resolve it.  Can anyone help?



Tom Molskow - SharePoint Architect -

How To configure Asp.net Login name control with list column Data Field?



I am trying to access site username and insert that name into list

I am trying to configure asp.net login name control with list column but for that control not having any property to configure that with list column

Is there any solution to configure asp.net control with list column by using sharepoint designer 2010?



How to pull data from SharePoint List to Infopath field?

I have customer's name, address, account number, etc in Sharepoint list. In infopath I have a field's like Customer Name, Address, Account number..I created a data connection for Customer's name and I want to populte the related data of that customer in Infopath field by calculated formula or something. When ever we pull some one's name ..I need that customer's Address and other details about him in INfopath form. The data should keep changing if I pull out some other customer's name..Does any one know how to do this? Seems simple..but not able to it though...

Business Data List Caching


I'm trying to implement Business Data Lists hitting our DBMS. The queries are very resource intensive, but the data is not going to change much day to day.

Even though I have the "Enable Data View Caching" enabled and the Data Caching Timeout set to 24 hours, 8 hours, etc etc I'm still seeing trips to our DBMS.

What gives? I thought DVC was supposed to enabled out of the box on these web parts? http://support.microsoft.com/kb/2000112 This says it won't work on non Publishing Pages, but (as far as I know) all my pages are publishing pages.

Web Part List - Business Data List missing?


Hi there,

I am working with sharepoint 2007and I am trying to add a webpart list, specifically a Business Data List.

I am trying to do it through Site Actions> Edit Page.

Any clue?


Thanks in advance,


Column filter in Business Data List web part does not work for all fields


I have a BDC entity whose fields contain a variety of data – numbers, dates and strings.  When I use the business data list web part I find that some of the columns’ dynamic filtering (accessed from the list’s column header) doesn’t work.  For these problem fields, the filter values load correctly but when I select a value all records disappear.  Initially I thought this was limited to just string columns but there is one string column that does filter correctly.

Here are some things that may be useful to know:

1.       The datasource is a SQL view and all fields are varchar(255)


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend