.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

Business Data List Menu Questions

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :SharePoint
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.

View Complete Post

More Related Resource Links

problem in Business Data list webpart

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



problem in Business Data list webpart

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



Business Data Item Builder Missing "Connections" menu option.


On the Business Data Item Builder menu there is typically an option that says "Connections" and then you can connect the item builder to a Business Data Item Web Part. Our Business Data Item Web part is set up properly and our ADF file (and query string) is unchanged, but the Connections option has disappeared. Any help or insight into this issue is much appreciated.

Join Entities in BDC For Business Data Field In List



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.

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.

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

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

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 -

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)


Show custom error message inside SharePoint Business Data List web part?

I am using SharePoint 2007 Business Data List web part to show external information retrieved from my simple web service. Is there ability to show custom error message on Business Data List web part?

Specifying the finder method for a business data connected list column's object picker.



I have a BDC xml file which specifies a finder and a specific finder method. These both work fine.

What I want to do is configure the application so that when connected to a list column the object picker uses my finder method rather than the specific finder method which it defaults to. Is this possible?

For further explination if you look at the following image http://i56.tinypic.com/2n22o3m.jpg

If I want to find the department using the objet picker I have to type the full identifier.

If I click the browse (address book icon) to popup the browse window I can then use my finder method. I want the initial object picker to use my find method and if there multiple matches be able to pick one using the popup you get when the message "No exact match was found." is displayed.

Hope this makes some sense!

Cheers Dave

How to automatically resolve external business data in a MOSS 2007 document list


Here's what I have so far...

1.      I have a document list in MOSS 2007.

2.     Each document in the list may be sent to an external system for further processing.  This was done by adding a custom feature to the document libraries actions menu in SharePoint.

3.     The external system uses it's own SQL Server database.  A table in this database references the SharePoint document’s GUID.  Additional columns in the table are updated during external processing data such as status.

The problem I'm trying to solve is this:

1. I would like the see the external processing status for a document in the original SharePoint document list.  This status will change and needs to be updated for each document automatically.

I tried setting up a business data column in the document list.  I created the XML definition of the external SQL Server table using the MOSS 2007 SDK and imported the definition.  I added the business data column to the list

Business Data List Exceptions


This is a multi faceted question, but any help is appreciated 


  1. I have a Application Defination that loads normally with the exception of not being able to create the profile pages
  2. The database back end of Firebird through ODBC
  3. All the data is coming from stored procedures


  1. Why is that I have some string fields that if they are null, I get the following error: "An error occurred while retrieving data from <LOBInstance>. Administrators, see the server log for more information."
  2. When I check the logs, it's a System.OverFlowException. How could there be an overflow with a string?
  3. I'm not exceedingly familiar with XML, but isn't there a way to say a field can be nullable? It seems like I came across a similar problem working with Xpath / Xpathnavigator, but it was a while ago and I can't remember the circumstances
  4. If I change it so the output is a blank string, I suddenly get "The title property of entity <EntityName> is set to an invalid value"
  5. The error from the logs is "Exception handed to HandleXslException.HandleException System.ArgumentException: '.', hexadecimal value 0x00, is an invalid character"

Business Data List has no Business Data Type available in the picker

I created an ADF file.  I import the file into sharepoint.  I set the permissions.  I go to the page and add a Business Data List.  I modifiy the shared web properties.  I go into the Business Data Type Picker and I have nothing available to select.  I search and still cant find it.  Can anyone tell me why this is blank?????

Frequently Asked Questions - SQL Server Data Types

This is good and precise introduction and Frequently Asked Questions - SQL Server Data Types
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