View Complete Post
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.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.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
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:
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?
It is possible to create a column in a List in SharePoint by the following ways.
1.Creating a column directly in the server 2.Creating it by using Object Model (While creating a list in the sharepoint, webservices for the list will create the list. In the same way upon addition of columns,fileds, updation,deletion will be handled
Is there any other way creating column by using XML or any method which will be called to create a column in the list without calling webservices or using Object model?
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
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
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!
I created a sharepoint list instance in visual studio 2010 with English field names and not-english display-names.
when I deploy the solution and browse to the list I get non-readable field names. I tried to add
"xml version="1.0" encoding="utf-8" "
to the schema.xml file but didn't change anything. any clue?