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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Adding an External List to SPS 2010

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :SharePoint
 
Hello Community,
I have created an External Content Type, and from that External Content Type I have created an External List.  Unfortunately whenever I display the list I get the error message below:
Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator.

Correlation ID:b2acc856-8344-41f9-9574-d1a4d3904e33

Has anyone else experienced this and if so do you know how to fix it?

Thanks!

 

Tom

Tom Molskow - SharePoint Architect - Linked-In - SharePoint Gypsy


View Complete Post


More Related Resource Links

Create Lookup Site Column based on External List (SharePoint 2010)

  

I've got an External List and I want to create a Site Column, which is Lookup to a column in my external list. If I tick any of the columns in 'Add a column to show each of these additional fields' and click OK i get the following error message:

[NullReferenceException: Object reference not set to an instance of an object.]
  Microsoft.SharePoint.SPBusinessDataField.IsInDefaultView() +58
  Microsoft.SharePoint.SPBusinessDataField.CreateSpFieldForBdcType(String bdcName, Boolean hidden, Boolean readOnly, Boolean idField, SPAddFieldOptions op) +809
  Microsoft.SharePoint.SPBusinessDataField.AddNeededSecondaryFields(String wssNames, String[] oldNames, String[] newNames, SPAddFieldOptions op) +315
  Microsoft.SharePoint.SPBusinessDataField.OnAdded(SPAddFieldOptions op) +240
  Microsoft.SharePoint.SPFieldCollection.AddFieldAsXmlInternal(String schemaXml, Boolean addToDefaultView, SPAddFieldOptions op, Boolean isMigration, Boolean fResetCTCol) +759
  Microsoft.SharePoint.SPFieldCollection.Add(SPField field) +61
  Microsoft.SharePoint.ApplicationPages.FieldNewPage.Save() +513
  Microsoft.SharePoint.ApplicationPages.FieldNewPage.BtnOk_Click(Object sender, EventArgs e) +46
  System.Web.UI.WebControls.Button.OnClick(EventArgs e) +114
  System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +139
  Syste

Adding Multiple hyperlinks to form connected to SharePoint 2010 list

  

I have a SharePoint 2010 list and am using an InfoPath 2010 form to create items. I am trying to allow users to reference other list items by inserting a hyperlink to other items in the same list. I have created a column in the list containing each items URL. I then created a drop down list in the InfoPath form that queries this column, so that it contains all the items URL’s. I also created a button and a hyperlink field in the InfoPath form. I would like the user to be able to choose an item from the drop down list, click the button and have the hyperlink inserted into the form. Then be able to choose another item from the drop down list, click the button and have another hyperlink inserted. I added a rule on the button that when clicked, sets the value of the hyperlink field to the value of the drop down item picked. This works, however, only allows for one hyperlink to be inserted.

I have also tried to use the multiple selection list box, by querying the URL column as the choices. This allows for multiple selections, however it shows up as text a

Calendar View for External Data List in SharePoint 2010?

  
Hello,

I'd like to create a calendar view from data contained in an External List.  My external content type has a Start Date, End Date, and other calendar fields.  Is this possible using the out of the box BCS?

For extra credit - I'd like to then use this calendar as an overlay on other calendars within my SharePoint 2010 application.

Thanks for your help!

Adding Multiple hyperlinks to form connected to SharePoint 2010 list

  

I have a SharePoint 2010 list and am using an InfoPath 2010 form to create items. I am trying to allow users to reference other list items by inserting a hyperlink to other items in the same list. I have created a column in the list containing each items URL. I then created a drop down list in the InfoPath form that queries this column, so that it contains all the items URL’s. I also created a button and a hyperlink field in the InfoPath form. I would like the user to be able to choose an item from the drop down list, click the button and have the hyperlink inserted into the form. Then be able to choose another item from the drop down list, click the button and have another hyperlink inserted. I added a rule on the button that when clicked, sets the value of the hyperlink field to the value of the drop down item picked. This works, however, only allows for one hyperlink to be inserted.

I have also tried to use the multiple selection list box, by querying the URL column as the choices. This allows for multiple selections, however it shows up as text a

Sharepoint 2010 BCS-External List in a GridView

  

Hello Everyone,

In sharepoint 2010, using Business Connectivity Services(BCS) we are able to create an external list ( a list of data from back-end).

My question is --- it possible to show the data from BCS into a gridview instead of a LIST?

currently I am doing code in a visual webpart like:

  1. gridview1.datasource=mynamespace.myclass.ReadList();
  2. gridview1.databind();

But I found that ,its not good for all kind of tasks like  -----sharepoint designer external content types etc..

any other options like Business Data WebParts?


Like Cricket

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?

Regards,
Chirag

Connect to Outlook not working for an External List in 64-bit Office 2010

  

I've used Business Connectivity Services in SharePoint 2010 to create an External Content Type with Office Item Type 'Contact'. I then created an External List in a SharePoint site to display the items in the External Content Type (after granting permissions on the ECT). When I click 'Connect to Outlook', a VSTO is created and installed. It says, the install is succesful. However, I do not see the contacts in my External List in Outlook. This is a 64-bit version of Outlook 2010. When I click 'Connect to Outlook' again, I get an error: "Cannot install or update this external list on client machine because another update is already in progress".

From another client machine where I installed the 32-bit version of Office 2010, this functionality works great. It seems the VSTO SharePoint BCS creates when you click 'Connecto to Outlook' on an external list, is not compatible with 64-bit versions of Office. Just to make sure there were no other differences between my two machines, I went back to the 64-bit Office client, uninstalled all Office software, then installed the 32-bit version of Office 2010. I then did my test again, and everything worked just great.

So, my conclusion is: Connect ot Outlook does not work on a SharePoint 2010 External List when you are running 64-bit Office 2010.


How exactly does a SharePoint 2010 External Content type / list work?

  

Hi,

I'm trying BCS on an SQL table which contains about 300,000 rows. Following is what I've observed:

1. A "SELECT * FROM <TABLE>" query fired on the SQL Table using SQL Management Studio returns all the result in 12 seconds
2. The same data when accessed by browsing the default view of external list (to which an External Content Type (ECT) built over the same SQL table in SharePOint Designer 2010 is attached) takes about 3:14 minutes

If I edit the ECT (using SharePoint Designer) and set limit as 100,000, it takes about 49 seconds to load, and further reduction in limit reduces the time to load.

My questions are:

1. What is it that causes so much delay in accessing the rows, as SQL delivers them in 12 seconds? Can anyone please help me understand the BCS / ECT architecture- how it accesses data, etc.
2. Can I implement paging in ECTs created using SharePoint Designer 2010?

Any help shall highly be appreciated. Thans in advance!

 


Creating a SharePoint 2010 External List Application Using VS 2010

  
to create an External List using Business Data. I noticed that they showed methods for the code but showed no foundation or a Use Case, nor did it discuss the LOB System and how the class entity relationship is defined.

Adding Search Refinements in SharePoint 2010

  
I have been playing around with SharePoint 2010 Search this morning. I love the new UI. The search refinements panel is just begging to be messed with. In my case I wanted to add the file extension JPG as an Image Type refiner.

Way of adding items in Drop Down List or List Box using Javascript

  
The article Way of adding items in Drop Down List or List Box using Javascript was added by raja.s on Sunday, June 06, 2010.

Hi,script type="text/javascript"> function AddItem(Text,Value) { // Create an Option object var opt = document.createElement("option"); // Add an Option object to Drop Down/List Box document.getElementById("DropDownList"

Array List with unique id while adding student info

  
Hello Frds,

I'm having arraylist to add student info but i have to create unique id per record below is my class.

Student objStudent=new Student(123,"Nj");
statArray.Add(objStudent)

public class Student
{
  private string name;
private int RollId;
public string Name
{

    get { return name; }
set { name = value; }

  }
public int Id
{
    get { return RollId; }
set { RollId = value; }
   }
public Employee(string name, int id)
{

    {
this.name=name;
this.Id=id;
}
}





Workflow field not being added to list or views when adding a workflow

  

This problem just started happening in my entire site collection.  Anytime I associate a workflow to any list or doc lib the Workflow column that shows the status and links to the history is not beind added to the list or any views and is nowhere to be found.   Here's exactly what I'm doing:

1.  Go the List settings -> workflow settings -> add a workflow (for this example the OOB approval workflow)

2.  After adding I go to the List, the workflow column doesn't exist.

3.  I go to "modify view", and the workflow column is not listed in the available columns.

Any help is greatly appreciated.


Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

  
Learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010 to read and write data to the AdventureWorks sample database.

Sample: Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

  
Explore the code in this visual how-to article as you learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010.

Creating SharePoint Server 2010 External Content Type Associations with SharePoint Designer 2010

  
Learn how to use Business Connectivity Services (BCS) to create associations between external content types in SharePoint Designer 2010 without using code.

Quick Note: Create Custom List Definitions in SharePoint 2010

  
In this exercise, you create a custom list definition in Microsoft SharePoint 2010 and then create an event receiver that is triggered when the list is used.
Categories: 
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