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


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Fauzul Azmi
Asad Ali
Post New Web Links

Creating a SharePoint 2010 External List Application Using VS 2010

Posted By: sagar pardeshi     Posted Date: February 10, 2011    Points: 2   Category :SharePoint
 
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.


View Complete Post


More Related Resource Links

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.

Error creating Read Item or Read List operation in Sharepoint Designer 2010

  
In terms of high-level requirements, I need to pull in lists from a couple of different web apps.  To do this, I’m using SPD 2010 to create an External Content Type for the list of interest.  I’m able to create a SOAP Service or WCF Service connection just fine.  However, when I try to create the external content type and create a Read Item Operation on one of the GetList or any other Get* (or other Update methods for that matter) methods, I get the following error:"The method that your operation is based on has parameters with complex types that do not have default parameterless constructor.  This kind of data source methods cannot be used in Business Data Catalog."I tried defining an operation on the “AddAttachment” method, and that worked just fine.  I also tried providing default values to the listName and viewName parameters when creating the SOAP Service connection, but still get the error.  Same issue with a WCF Service connection as well. Does anyone know if this is a 2010 issue, or am I approaching this requirement incorrectly?  What are other approaches for connecting to lists that reside in a different web app than yours? 

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

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!

Error Creating External Content Type using Sharepoint Designer 2010

  
I am trying to create an external content type using Sharepoint Designer 2010. I ran SD on my local machine and connected to a site on some other machine running Sharepoint Server 2010. The Db on which I want to create my ECT resides on my local machine. When I try to use User Identity to connect to my local Db server, it gives me the error that login failed for user <my domain username>. I have both sql server and windows authentication mode login enabled on my sql server. Any help in this regard is appreciated.

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

Creating SharePoint 2010 List Definitions in Visual Studio 2010 (Visual How to)

  
Watch the video and explore code as you learn to create list definitions and list instances for SharePoint 2010 by using Visual Studio 2010.

Video: Creating SharePoint 2010 List Definitions in Visual Studio 2010

  
Watch this visual how-to video and learn to create list definitions and list instances for SharePoint 2010 by using Visual Studio 2010.

Creating a column in the List using SharePoint 2010

  

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 by webservices)

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?


Cheers! Maruthu | MCP - Microsoft Certified Technology Specialist | http://twitter.com/Marutha_Chalam

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 list with non-english field names in Sharepoint 2010 from visual studio

  

Hi experts,

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?


Search and Destroy,,,

Sample: Creating SharePoint 2010 List Definitions in Visual Studio 2010

  
Explore the code in this visual how-to article as you learn to create list definitions and list instances for SharePoint 2010 by using Visual Studio 2010.

Creating Dialogs and Ribbon Controls for SharePoint 2010

  
SharePoint 2010 provides new user interface components, such as server ribbons, and the new dialog platform. As a developer, you can create controls for the server ribbon and dialog boxes for the dialog platform.

SharePoint 2010: Application Lifecycle Management (ALM) Resource Center

  
Are you looking for information about BCS? BCS enables users to read and write data from external systems-through web services, databases, and .NET assemblies.
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