.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

Binding a DVDropDown control to a XML data source

Posted By:      Posted Date: October 01, 2010    Points: 0   Category :SharePoint

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?



View Complete Post

More Related Resource Links

Extreme ASP.NET: The Only Data-binding Control You'll Ever Need


Fritz Onion demonstrates how the ListView control in ASP.NET 3.5 makes data-binding tasks easier with support for styling with CSS, flexible pagination, and a full complement of sorting, inserting, deleting, and updating features.

Fritz Onion

MSDN Magazine March 2008

Extend ASP.NET: Simplify Data Binding In ASP.NET 2.0 With Our Custom Control


The wwDataBinder control addresses simple control data binding--binding simple form controls like textboxes, checkboxes, and the selected values of list controls to individual data or object values.

Rick Strahl

MSDN Magazine December 2006

Menu Data Binding from XML source

Hi , I have the following complex XML structure. I need to bind the values to menu via Binding from the XML source <Editions>      <Edition Name="A">            <Products>                  <Product Name="1">                        <Platforms>                              <Platform Name="11">                                    <A1 Name="A"/>                                    <B1 Name="B"/>                                    <C1 Name="C"/>  

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).

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?


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

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?

Need help on Data binding with DPs and Control Loaded event



I have a very interesting issue and i have been breaking my head on it since a long time.

I am new to WPF and related things like MVVM and all.

I have a window in which i place a user control which hosts a TabControl inside it.

This tab control has Custom Radio Button and Combo boxes which expose few Dependency Properties, Now while these custom controls are loaded author checks for the values and does 'something particular' which is intended behavior. However in my case while the control is being loaded the DPs have null values. I see the DP property changed events being fired post Load of that control only in my case. It works okay on other windows.

This is kind of strange to me as I would expect that the DPs would be bound to related values before the control gets loaded, but i dont see that behaviour here.

 I have read on MSDN that the DPs should be set properly before load event, and in a sample application i see it behaving as per MSDN.

Binding is happening properly as there are no errors in out put window + I get the DP - Property changed events as well, but this happens only after load (I dont know why??)

Any help would really be appreaciated.



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 Data Source Control

How can we get distinct records from sp list in spdatasource control using sharepoint designer?

"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?


Trouble binding InfoPath "template part" to data source


I created an InfoPath template part using an XSD.  I added it to my custom controls, but when I try to insert it into the main template, it asks to be bound to a data source.  I have created a group to bind it to in the data source, and I created a "complete XML document or schema" based on the same XSD as well.  It matches the schema in the template part exactly.  The template part won't bind to either node.  I get the error message, "Requirements_Template_Part cannot be bound to the selected field or group." 


This XSD is complex and contains a repeating table.  I read somewhere that this might be a problem.  Unfortunately , the XSD cannot be changed much though this is a format imposed on us from another group.  A coworker is writing a transform to cull out the data from this XSD and feed it into another system.  He says he will update the XSD from time to time, and I thought that a template part would make it easy for me to update it whenever he updates his XSD.

How to pass control reference to its property in data binding expression


Here is data binding expression (dropdown list is nested in gridview)

<asp:DropDownList ID="ddlEmployees" 
         DataSource='<%# PayCheckBO.GetEmployeesNameIdPair() %>' 
         SelectedIndex='<%# GetSelectedIndex(HOW TO PASS REF of ddlemployee HERE)%>'/>

Code Behind has function which looks like

public int GetSelectedIndex(DropDownList ddl)
        //loop through the item in the dropdownlist
        //return index based on xyz checks

The whole reason for passing the reference is to save round trip to database and not to use SESSION

DataReader Source Data Flow control not in the Toolbox of BIDS ???


I find this advice in the SSIS forum . . . but I can't find the DataReader Source in the Data Flow source items . . . nor do I seem to be able to 'Add Item' that time.

Advice appears to be I should use DataReader Source when pulling data from Oracle using ODBC e.g.:

"ODBC is supported in the data flow by the Data Reader source adapter. I think the original problem may have been that you were trying to use the Data Reader source with an ODBC connection manager.

To extract data from an ODBC source, try the following:

  • Add an ADO.Net Connection Manager.
  • Edit the Connection Manager editor and select the ODBC Data Provider
  • Configure the Connection Manager to use your DSN or connection string
  • Add a Data Flow Task to your package.
  • Add a Data Reader Source adapter to your data flow"

Any help getting the DataReader Source to appear in the BIDS toolbox appreciated.

Thank you and a Happy time with family tomorrow,



The project file is not bound to source control, but the solution contains source control binding in

This may be more of a SQL Server Management Studio question, but I couldn't find a SSMS forum...

I've got a database solution that contains several projects.  They're just to keep track of changes to stored procedures, triggers, views, etc in a few databases I maintain.  There is a problem with two of the projects though.  No matter what I do, I can't seem to get them bound to source control right.  When I open the solution, I get:

The project file is not bound to source control, but the solution contains source control binding information for it.

With two options, use solution binding and remove solution binding.  If I keep the solution binding, everything works fine.  But it's really annoying to have to deal with every time I open the solution.  If I remove the solution binding, the projects are now unbound again.  If I try to fix them (using the change source control or Add Selected Projects to Source Control options under the File->source control menu), I just end up in the same situation.  I've even tried deleting the projects and re-creating them from scratch, then re-adding them to VSS.  If I open the solution files in a text editor I can see the SCC tags in every project, but these two.  Since I can't manually add the tags, and Management Studio itself only seems to want to bind them the wrong way, I'

Binding WPF Controls to an Entity Data Model

In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.
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