.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

New Item Form with Business Data Column SharePoint 2010

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

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



View Complete Post

More Related Resource Links

Consuming External Data Using SharePoint Server 2010 Business Connectivity Services and an Excel 201

Learn how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Module 6: Accessing External Data with Business Connectivity Services in SharePoint 2010

SharePoint 2010 provides a new set of technologies known as Business Connectivity Services for retrieving, editing, updating, and deleting data from external systems.

Problem with Retrieving data from lookup column using SharePoint 2010 Linq Concept

Hi I am working with sharepoint linq concept. When I am giving a query with lookup column It's working fine.  But when i am trying to retrieve the data from a look up column to spgridview. I was unable to get the output. Here is the above code which i have worked.   string strTitle = string.Empty; string strStatus=string.Empty; var context = new LinqSampleDataContext(SPContext.Current.Web.Url); EntityList<SharePoint2010ConceptsItem> Concept = context.GetList<SharePoint2010ConceptsItem>("SharePoint 2010 Concepts"); var query = from cs in Concept where cs.Status.Title.ToString()!="Completed" select new { cs.Title, cs.Id, //cs.Status }; sgvConcepts.DataSource =query; sgvConcepts.DataBind();   Any help me plz how to retrieve the data from a lockup column.bvnprasad

Infopath Form Data submitting to Sharepoint 2010 List

Making a Client intake form that once submitted will send data to  a sharepoint 2010 List called contacts. Short Summary the form will have repeating fields and alot of information to submit. I have looked and read all over but I cannot find an easy step by step guild on how to submit the form data like that. Long Summary on the sharepoint site a button will open a form for adding a new client.  once the form has been filled out and the user hits submit sharepoint will then create a User File, in clients file, and take the data and put it into contacts list. I am trying to make use of Sharepoint as I would with access, meaning the more information I have on a client the easier it will be to mail merge letters, motions, basicly any file prepaired stuff. So once I have css designed forsharepoint to make it look the way I want then the forms should intergrate perfect

Invalid data has been used to update the list item in sharepoint 2010.

I have created a custom list definition with one lookup field <      Field ID="{865CD714-7DF6-4F65-9DBC-5FE910B10BC5}" Name="CompanyName" DisplayName="Company Name" Group="Custom contents" Description="Select Company" Type="Lookup" ShowField="CompanyName" Required="FALSE" FieldRef="CompanyName" List="Lists/LookupListDefinition-ListInstance1" ReadOnly="FALSE"></Field>   <nativehr>0x80070057</nativehr><nativestack></nativestack>Invalid data has been used to update the list item. The field you are trying to update may be read only. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. My solution is perfectly get deployed on site. I can see the list instance created on site its also appears on quicklaunch. When i am trying to add the item into the custom list using UI then i am getting the input form correctly i can see the lookup values in dropdown list but when i click on save button then its give me an error as mention above. For debugging purpose i have created the event reciver class for list item adding event. In that i have check the column status and

SharePoint Designer 2010: Business data connectivity metadata store is unavailable

Running SharePoint Server 2010 RTM. Fresh install in production not via the wizard but a vanilla install and bringing services up one by one. Just brought up the Business Data Connectivity Service. Other services currently up are Managed Metadata Service and User Profile Service. Two web applications with services deployed to both web applications. The scenario below holds true when connecting to a site on either web application. 1) Open a site, i.e., root portal site, in SharePoint Designer 2010 2) Click External Content Types. Error returned: "The Business Data Connectivity Metadata Store is currently unavailable" is returned. 3) Click Ok then click New | External Content Type. Error returned "THe server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults...". The Business Data Connectivity Service status in Central Administration is Started. Any ideas?

SharePoint Designer 2010 External Content Types Data Source Already Exists in Business Data Connecti


I used the Secure Store to create connection in SharePoint 2010 Designer External Content Types Data Source Explorer.  Later I changed some column names in the table.  I deleted the connection from Data Source Explorer and recreated it. I right clicked on the table and selected Create All Operations. When I clicked the Finish button, I got "The system definition with the same name as this data source already exists in the Business Data Connectivity Metadata Store and it refers to a different data source.  Cannot complete operation generation.  Add a connection to this data source with a different name and try again." 

I re-created the Secure Store using a different name in SharePoint 2010 Central Administration.  I didn't find the option to choose the connection name in SharePoint 2010 Designer. After I clicked Add Connection, I entered the Database Server and the Database Name, selected Connect with Impersonated Window Identity, entered Secure Store name, and clicked OK. The connection created with the database name as before.

Fast Search 4 Sharepoint 2010 Business Data Connectivity (BDC) - IEntity Could not be found


Hi, I am using Fast for Sharepoint and I have created a simple Employee database in SQL server 2008 and I am trying to crawl this database.

Using Sharepoint designer, I have created an external repository and I have configured it to look at my test database. After trying to crawl this database - I get two successfyul documents crawled - which are just junk documents. And 5 errors.  The errors say:

Error while crawling LOB contents. ( IEntity could not be found using criteria 'Id=2502'. )

I also noticed that if I was to disable "Defaul Action" from the BDC configuration, then I get all successful crawled documents. However, if I click on any of those documents in the search page, then it brings me to "unkown page". 

This makes sense since Default Action (View Profiles) is disabled. Does anyone know how to avoid this error message above without having to disable Defaul Action check box? 

P.S. I can also see that the connection between SQL Server - BDC - SP is working since when I create a user profile page, I can see that data populate.  

Item Event Receivers or way to validate data entered for External List in SharePoint 2010?

Hi everyone,

Are there Item Event Receivers for External List in SharePoint 2010? If not, is there a way to validate the item data entered from External List UI in SharePoint site?


The Business Data Connectivity Metadata Store is currently unavailable in sharepoint designer 2010

I am getting the following error when runnind SP designer and trying to create new  external content types.

"The Business Data Connectivity Metadata Store is currently unavailable."

checked in ULS Logger, the actual error is "SharePoint Foundation Claims Authentication 8305 Critical An exception occurred when trying to establish endpoint for context: The 'CustomBinding'.'http://tempuri.org/' binding for the 'IWSTrustChannelContract'.'http://tempuri.org/' contract is configured with an authentication mode that requires transport level integrity and confidentiality. However the transport cannot provide integrity and confidentiality.. 5d0b275a-dfa8-4834-ba5a-d8ed7d58abd1"

googled it, found some fix:

1. install the hotfix

2. simply checking the services are running

3. checking for necessary security permissions on the BDC Service Application

4. using the 'disableloop

Building InfoPath forms against Sharepoint 2010 Data Connection Library and Form Services...


Hi Sharepoint Experrts,

I'm trying to develop InfoPath 2010 forms that use External Lists that have been created in Sharepoint Server 2010.  I have problems when testing the forms because access is denied to the external lists.

When I try deploying the forms to the sharepoint site, I cannot upload the form template because it says I have to be a member of the local administrators group.  However, I'm running the administrator account used to install and setup sharepoint on the Windows 7 development machine I'm using.

I also tried loading the InfoPath Data Connections to a data connection library on my Sharepoint site... I can see the files when I login to the site but when I try creating a New form from a Data Connection File, I get an error message "This location does not contain any data connection files with the appropriate settings".  What ARE the appropriate settings?

I'm just really confused about this because I cannot seem to be able to build forms that use data connection files loaded onto a Sharepoint site or central server....

I appreciate any help I can get!




Thanks, KBW

Accessing SharePoint 2010 Data with Server-Side APIs

Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

Office Add-Ins: 3 Solutions for Accessing SharePoint Data in Office 2010


SharePoint 2010 introduces a number of new ways to access business data and present it to the user. We'll show you several options that range from no-code solutions to fully integrated Office add-ins.

Donovan Follette , Paul Stubbs

MSDN Magazine July 2010

SharePoint 2010 and BCS: Using Business Connectivity Services in SharePoint 2010


Kirk Evans shows how to take advantage of SharePoint 2010 Business Connectivity Services (BCS) to develop solutions with deep integration of external data and services. BCS builds upon its BDC predecessor in the key areas of presentation, connectivity, tooling and lifecycle management.

Kirk Evans

MSDN Magazine December 2009

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.



Sharepoint list group by column data ,display in webcontrol like panel or label


I  have a sharepoint list[Managers] with groupby sector column. like below




Each Sector group by column data i want to display in label or panel control.

How to do that ? how to write the logic?



Regards, Mansoor
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