0
votes
1answer
31 views

SharePoint: Perform a query to load data into external list and display the results in a list within the webpart

I am relatively new to coding and I am trying to complete a project in Sharepoint. I have a webpart which includes Peoplepicker. When the submit button is pressed the first username passed is used as ...
0
votes
1answer
145 views

Is it possible to link existing Sharepoint 2010 lists to SQL server databases?

I created a SQL server database and added a table to it. Then I used Sharepoint Designer 2010 to create an external Content Type using this table. Now I can alter the according Sharepoint list which ...
2
votes
1answer
184 views

Timestamp in Sharepoint external content type not matching value in SQL table

I have an external content type in SharePoint 2010 pulling data from a SQL 2008R2 DB using BCS. All the data comes back fine but the Time stamp column is off by 2 hours when I compare the values ...
1
vote
0answers
370 views

Problems Connecting to SQL Server external list

I'm a newbie. I was exploring how to view/edit SQL Server database tables in Sharepoint. After some research I did a two-step process Create an external content type (using Sharepoint Designer) to ...
0
votes
2answers
120 views

External list not implementing TimeSpan field

I am developing an external content type with sharepoint designer, based on a microsoft sql server table. One of the columns has the time(0) format. This is interpreted by sharepoint designer as ...
1
vote
2answers
91 views

How can i retreive data from Web Server to my Intranet SP site

Would you please let us know the steps to connect a external Web Service that has specific attribute (GetAttributeProductsByID , GetAttributeProductsByName ... etc ) with an Intranet Sharepoint site ...
1
vote
2answers
2k views

External Data field - problem with refreshing (SP 2010)

I have created a custom list with a field (column) of 'External Data' type, connected to my external content type. External Content Type's source is an SQL view. My problem is, when I make changes on ...
1
vote
2answers
5k views

Can't Create External Content Type linked to SQL Server

In Sharepoint 2010, I am trying to create an External Content Type, and use a connection to a SQL Server. But, in Sharepoint Designer, when I am in the wizard to create an ECT, I'm having trouble ...