.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

Sharepoint Data Source Control

Posted By:      Posted Date: October 26, 2010    Points: 0   Category :SharePoint
How can we get distinct records from sp list in spdatasource control using sharepoint designer?

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.

Connecting a Sharepoint Custom list with an external Data-source

Hi I am planning to connect a Sharepoint Custom list with an external Data-source. External DB will be in Access 2007 format. More Information: I need a solution that we can connect our sharepoint list (one-way) to online db in a way that new  information is directly updated in the sharepoint list, whilst other info changed in sharepoint list  is not synced back to original value. Is there a way to solve this? -saumil

Microsoft Excel and Sharepoint KPI's (External Data Source)

This is my first post i hope i get a clear answer for my question. I recenty have been working on KPI's drawn from Microsoft Excel documents that i created. However, as we know, external data sources in excel don't work with sharepoint. If that was possible it would have saved the company a lot of time and effort My questions are: Is there any way to have external data sources with some advanced modifications, or any other way that would simulate this process? (External data update) Can i directly update my data by tampering the database where the excel file is saved?   I don't know if the files uploaded in sharepoint are stored in a database, so i want some validation around this. (Name of the database, path etc.)   Hope you can shed some light to my questions Thanks in advance Theo

Binding the sharepoint treeview to the quick launch data source

Is there any way i can bind the sharepoint treeview navigation to the same datasource as the quick launch bar? I'm trying to create a consistent navigation structure within a 4-site deep structure so the quick launch bar is rather clunky to use, but the treeview picks up on document libraries i don't want it to (i only want it to show subsites and pages).

Sharepoint list as Report Data Source

My current environment is Sharepoint 2007 with SSRS 2008 in Sharepoint Integrated Mode. SSRS 2008 uses trusted authentication to communicate to Sharepoint 2007. Sharepoint 2007 is configured to use NTLM authentication (configured with a domain account). My settings within Central Admin are Authentication Type: Windows IIS authentication settings: Integrated windows authentication with NTLM. My question is: Do I need to configure Sharepoint to use kerberos to use Sharepoint Lists as a Report Data Source?  

SharePoint Data Source for InfoPath Issue

I've setup an InfoPath form which uses web services to pull an XML data source into the form.  The form works great internally, but when users on the extranet try to use it they get a "Cannot Access Data Source" error.  I have tried connecting to the web service via the extranet and it works just fine, but as a data source in the InfoPath form, extranet users cannot access it.  I've tried using both the intranet and extranet paths to the web service with no luck.  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.

Binding a DVDropDown control to a XML data source


I'm having a heck of time figuring how to get my DVDropDown control to display items from the SoapDataSource (SOAP web service) or XmlDataSource (REST).


If I create a data view for the same data sources, I can see the data just fine, but when I go to Data Fields dialog, I can select the data source in the dropdown but in all cases, the two other dropdown to pick the value and display text are blank and there's nothing for me to select though I know there should be columns available for selection.


I've also tried manually coding those parameters, accounting for the possibility that I may need fully qualified XPath to get to the column itself but that causes an error.


What could I be missing?



Unable to drag data source to control to bind


I have a simple test application following the directions from http://msdn.microsoft.com/en-us/library/dd465159.aspx .  When I attempt to drag the data source onto the design surface I get the following error:

Cannot add the control to the design surface or bind to the control because the type TestApp.AdventureWorksEntities cannot be resolved.  Please try to build the project or add necessary assembly references.

The project as been built and the data source is in the same namespace.  I did a search for this error and the only hit I found was here, and mentioned Tools->Options->Extension Manager, 'Load per use extensions...'.  This option is checked.  I've tried unchecking and restarted with the same behavior.

Any ideas?


How to create custom control in .net which can retrive data from sharepoint list and redirect to sit


Hi help me!

I am strugling this problem!

My requirement is I need to create a custom control which need to retrive data from sharepoint list, The list contain some sites information like Title, url, Scope my requirement is i need to display sites Title in my custom control and when i click on title (site name) in custom control it need to be redirect to that site and whenever list data updated automaticaly custom control data also need to be apdated automatically .

The data source control failed to execute the insert command


Hi All,

I have create table in SQL 2005 and retrive its data in to sharepoint  with the help of Database connection option through Sharepoint Designer. When configuring the connection i have selected a custom quer with stored procedure option and from the dropdown option selected the insert stored procedure everything is ok.

Stored Procedure
CREATE PROCEDURE ChangeTable_insert

 @PROJECT varchar(50) ,

INSERT INTO [dbo].[ChangeTable]





i have created new aspx page in Sharepoint Designer from the datasource details-->Insert selected fields as-->selected new item form and saved this page.
When i opened this page in to browser and try to save data it gives an below error
Go back to site 
Error: "The data source control failed to execute the insert command.
 Troubleshoot issues with Windows SharePoint Services."

please help me. i have to save data to sql database through sharepoint

thanks in advance

SharePoint 2010- Custom Fields Like Rating Control- Need Suggestion on Saving Data


Hi All,

I am in process of Developing a Custom Field for Rating control. Requirements are below.

1) This field will be used for Creating survey

2) It will be called Rating control with Attribute ( some enhancement over out of box rating control)

3) Respondent will rate each attribute for 1 question like

                Action: 3

                Comedy: 5

                Thriller: 7

I need suggestion on  How to save data for above Requirements. I have designed control and it works fine. Only thing I need help on How to and Where to Save data related to answer?


Thanks in Advance



Pathik Rawal Blog: http://pathikhrawal.wordpress.com

LINQ data source control and db connection string


I have designed a few pages which use LINQ datasources and Gridviews to maintain data.

I have built a data layer which happily uses System.Web.Configuration.WebConfigurationManager.ConnectionStrings("myConnectionString").ConnectionString

However, the LINQ data source controls use Settings.designer.vb MySettings class definition which is auto generated and doesn't except the above Connection string.

Any ideas?

The data source control failed to execute the insert command


In SharePoint Designer 2007 I'm trying to customize the edit form that you get when you create a list item in a SharePoint 2007 list (EditForm.aspx). I took the following steps:

1.       Open the site in SharePoint Designer 2007.

2.       Browse to the list and open the 'NewForm.aspx' web form.


SharePoint List Data Source with Express Edition


Hello All,

I am working on SQL Server Express Edition with Advance Services 2008 R2. I am using Report Builder 3.0 to build report.

In Report Builder, there is data source type called Microsoft SharePoint List .

Can anybody please confirm whether this option will work with SSRS in Express Edition? I did not get information from above link.



"The data source control failed to execute the insert command." when inserting to sql table with tri



I have a data view web part that inserts a new record into a sql table. This works fine.

I have now needed to add a trigger to the sql table that sends an email when a new record is inserted (the code for which works fine) but now my insert fails with 'The data source control failed to execute the insert command.'.

If I disable the trigger the form works fine again.

Any ideas what could be causing this?


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