.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 Item Builder Missing "Connections" menu option.

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

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.

View Complete Post

More Related Resource Links

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.

New Item Form with Business Data Column SharePoint 2010


I am suprised that this issue still exist with the new sharepoint 2010, I was trying to create a new page, and I inserted a "New Item Form", this list contain a business data column, when I insert a new item, the business data coulmn doesn't get saved, this issue was there in MOSS 2007



Data view web part and item menu


Good morning, I'm using the SharePoint Designer 2007 and I would like to show the item menu using the data view web part. Below is an example of what I want to do:

How can I do that?

Disabling the "Open with Report Builder" menu item



We are using MOSS 2007 integrated with SQL Reporting Services. In the report viewer, there is a menu item called "Open With Report Builder". We do not want this menu item to be displayed or, alternately, would like to disable it. I assumed that this could be done by configuring the SSRS integration property "Enable ad-hoc reporting" in central admin to FALSE. Alas, this is not the case. The report builder menu item is still there and when you select it, it starts to install the application. How can I either disable or hide this menu item in the report viewer?

Thank You.

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,


data connections in data connection libraries as consumed by Report Builder and SSRS


A data connection to a SQL DB is created and published to a data connection library in SharePoint 2010.  When Report builder or SSRS consume this connection, does the actual network connection happen between the SP server and the DB or the client machine and the DB?  And is this different based on whether you use SSRS or Report Builder?  

The reason for the question is that the firewall is open between the SP farm and the DB but NOT between the client machine and the DB and I'm trying to figure out if this will be a problem or not.

Additional clarifications that may be helpful.  SSRS (SQL 2008 R2) is in SharePoint integrated mode and we are specifically talking about rsds files.

Missing 'new item templates'


 Hi all,

          I am a 'newbie' to VWD and I am slowly working through the Basic Walkthrough Help files, and learning plenty along the way.

However, when I tried to create a new database in the LINQ control walkthrough I found that the option to create a new database is missing, and further investigation has found that many other new item templates are missing.

I am using a brand new machine with Windows 7 Ultimate and have enabled IIS and .NET from Control Panel-Programs-Turn Windows Features On-Off. I used the WPI to install all basic elements eg. IIS Components, SQL Server Express.

The only 'new item templates' I have when I right-click the App_Data Folder and choose 'new item' are:-

ADO.NET Data Service

AJAX Enabled WCF Service

Dynamic Data Field

SQL Server Database

Text File

XML File

Does anyone know where I have gone wrong.


Michael J. Hill

How to keep the hover for Parent menu and set the selected menu item css for child menu item?



I'm using cssfriendly control adapter for menu. My asp.net menu control's datasource is a sitemap file I'm using which contains all the urls.

I have the following questions:

  1. Is there a way to keep the parent menu item hovered while hovering over the respective child menu items?
  2. Is there a way to keep the child menu item selected? I am able to set the css for the parent menu, however I was wondering if the same is possible with the child items.

Please help! Smile


Moneka Smile

Input Validation: Enforcing Complex Business Data Rules with WPF


Windows Presentation Foundation has a rich data binding system that includes flexible support for business data validation. We take a look at implementing some complex data input validation scenarios that include customized data errors for users.

Brian Noyes

MSDN Magazine June 2010

Mine Your Business: AMO Lets You Dig Deeper into Your Data from Your Own Applications


Analysis Management Objects (AMO) for SQL Server 2005 facilitates client-side custom programming as Decision Support Objects (DSO), the object model in SQL Server 2000 Analysis Services. With AMO, a whole range of data mining questions can be answered at the operational level. This means that sales and marketing departments get answers more quickly and thus can make informed decisions.

Liu Tang and Paul Bradley

MSDN Magazine June 2005

ASP.NET 4.0 Menu Top Level selected item style


I want to apply a css class to the level 1 menu item (parent) when it or any or it's children are selected.

I've looked at MSDN documentation and any number of examples and walkthroughs but I haven't come up with a way of managing this. I was thinking something like this might work but the style is not being applied to the parent. To further complicate matters, if I try to apply a css style to StaticSelectedStyle it doesn't pick it up at all.

Menu Markup:

<StaticSelectedStyle  Font-Bold="True" ForeColor="#3333CC" />

Code Behind:

        protected void MenuItemClick_NavMenu(Object sender, MenuEventArgs e)


            MenuItem parentItem = e.Item.Parent;

            if (parentItem != null)


                parentItem.Selected = true;



problem...i want a list item to populate all data in gridview!!!


i have a dropdownbox and a gridview

what I want is to have a list item which populates all data in a gridview.

I have tried using list item selected value=0 but to no avail.

what is the easiest way to achieve this?

Attach Workflow to Task List, don't get option to manually start workflow via dropdown on task item



I am running WSS 3.0 with other workflows which are functioning correctly.  I created a new workflow in Visual Studio 2008 and was able to successfully run it in my dev environment.  I attached the workflow to a task list in my dev environment and was able to manually start the workflow by using the drop down workflow option and using the menus to manually start it.  I installed this workflow in our production environment and attached it to the task list (which had a SPD workflow attached to it which stopped working about a month ago).  I made sure that the option to manually start the workflow was checked.  When I tried to manually start the workflow, (hover mouse over title, drop down) there isn’t a workflow option.  The workflow also will not start automatically when a task is changed.


I attached this same workflow to a different task list in production and get the option to start it.


I have tried creating a small workflow in SPD 2007 and attaching it to the task list.  It shows that it is attached, when I look at the workflows that are attached to the task list, but I still don’t get the option to manually start it.


I have checked my security and I have fu

Business Data Error: System.OverFlowException


I have a Business Data Catalog file I've uploaded to connect to our back end Firebird DBMS through ODBC.

The SharePoint server is MOSS 2007 x64. The web front end server(s) all have an x64 Firebird Engine and ODBC driver with verified connectivity to Firebird.

When I use one of the methods, I can see connections being made to our Firebird server and the query being passed. I know the query returns results (it's a stored procedure with no parameters), but I get the following error "An error occurred while retrieving data from MROTest1. Administrators, see the server log for more information" in IE. If I look in the server logs, I see (12\Hive\Logs)

Exception handed to HandleRuntimeException.HandleException System.OverflowException: Arithmetic operation resulted in an overflow.     at System.Data.Odbc.OdbcDataReader.GetData(Int32 i, SQL_C sqlctype, Int32 cb, Int32& cbActualOut)

Business Data Column cascade


Good afternoon, I would like to know if is possible to have two business data columns linked to each other. This is the scenario that I want:

BD Column 1 called State with all US states

BD Column 2 called City with all the cities based on the state selected on BD Column 1

Regarding Business data catalog in SharePoint


Hi All,

          I am using business data catalog to display the records present in the Active Directory based on the user selection of samAccountName. Since the number of records present in Active Directory are more than 3000 the user has to iterate through each page to get to a particular record. I want to add a kind of filter to my Definition file that user can search for a particular samAccountName from the list of samAccountName displayed in the business data list web part. I am using office server SDK by microsoft to generate the application definition file.

Any help regarding this will be appreciated.



wss2.0 Infopath 2007 'This form requires connections to data sources when it is loaded. At least on


Hi all

I have a user who receives the error 'This form requires connections to data sources when it is loaded. At least one of these connections is not available. As specified by the form designer, this form will not open' when trying to Submit an infopath form located on a WSS2.0 site.

The user has been having this issue since upgrading to Office 2007 and IE7. I have had the user run an Office Diagnostics but this has not resolved the issue.

I am not aware of any other users experiencing this issue.

Any ideas please?

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