.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

Enabling editing on dataview created from linked data source

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#


I'm working with MOSS 2007. Created a linked data source using 2 custom lists in the site and created a dataview. One of the columns shows a joined subview of the 2nd list from the linked data source. I'd like to enable the editing option (edit, insert) for this joined subview, but that option seems to be disabled (grayed out). In fact, the editing option is disabled for the main dataview as well.

Has anyone done something similar to this? Please advise.





View Complete Post

More Related Resource Links

GridView editing without using data source controls?


I am binding my gridview without using a datasource control and instead doing it in the code behind. However, I would like to use the inline editing features of the gridview. Could someone please point me to an example that does gridview editing/updating 'manually' in the code behind?


Enabling Edit , delete and insert in Data view with linked sources


Hello ....


I create a data view in sharepoint designer 2007 that has linked sources (Join between two lists) ....


How can I enable edit, delete and insert links in this data view  ????.... taking in consideration that options available in data view properties appear in gray ...



Cannot drag an Entity Framework Data Source (created in a separate solution) onto WPF Design Surface


I receive the error Cannot add the control to the design surface or bind to the contol because the type Pec.CustomerEntity.Carrier, Pec.CustomerEntity,Version=, Culture=neutral, PublicKeyToken=null cannot be resolved.  Please try to build the project or add necessary assembly references  (I have rebuilt and it still doesn't work)   -  when I try to drag the data source onto the window. 

If I create an entity framework project within the wpf application solution and create a data source and reference to it, it works fine when I drag the data source onto the window.  I only get the error when I create a reference to an EF project .dll created outside of the wpf project.  I am using Visual Basic 2010.    I have also tried adding the project to the wpf solution and it still gives me the error. 

SharePoint Designer crashing when editing Data Source

Environment is SPD SP1, WSSv3 SP1 + Infrastructure Update

When I add a datasource (e.g. insert the datasource of one list into the NewForm.aspx of another list), I can configure what fields, sorting, filtering, etc.  It adds correctly.  I then add my Data View DropDownList to the form.  When I go back and look at my datasource (spdatasource1), the bottom two dropdowns are blank.

If I attempt to configure the datasource, I get the following error:

Error invoking 'Configure Data Source...'.  Details:
Exception has been thrown by the target of an invocation.

SPD then crashes.  This is preventing me from really adding any new datasources as the new datasources essentially get added unconfigured, even though I went through the proess of configuring them.

Problem signature:

Problem Event Name: APPCRASH

Application Name: SPDESIGN.EXE

Application Version: 12.0.6211.1000

Application Timestamp: 46d4b150

Fault Module Name: ntdll.dll

Fault Module Version: 6.0.6001.18000

Fault Module Timestamp: 4791a783

Exception Code: c0150010

Exception Offset: 0005b84e

OS Version: 6.0.6001.

Locale ID: 1033


How do I find which Linked Data Source I've used?


I've got several Linked Data Sources, with different names, that I created for testing purposes, and all use the same 2 lists. How do I find which one I actually used in my DVWP? When clicking within the DVWP in question, the 'Data Source Detail's window only shows me the title of my DVWP, for the 'Current Data Source' at the top. I searched the code view but only found the names of the individual lists.

Thanks in advance for any help.


Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server


Dear All,

please to try to help me what could be the problem ?. when  i try to excute my stored proc in my sqlserver management studio it excuting fine when i trying to Excute using Asp.net application it giving Error. iam working on Sql Server, mt linked server is Oracle. my proc is like :

select  ID,Name  from OPENQUERY(TEST, ''
 ID ,
 Name  from Details)

Error:Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "TEST".
OLE DB provider "OraOLEDB.Oracle" for linked server "TEST" returned message "ORA-01017: invalid username/password; logon denied".
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Please try to guide me i unable run using asp.net App

thanking you,


Sharepoint 2007-Maximum document libraries that can be added to Linked Data Source


I have a requirement as below:

1. I need to create a web part which allows users to filter the document library columns based on their needs.

2. There are around 10 document libraries with around 11,000 files and I linked them using Linked Data Source.

3. I tried to create a DVWP. It inserted all the records thought but I am not able to apply the Data View properties like 'Filter', 'Sort' and 'Group'.

Is there a limit to the number of records that can be added to a linked data source. If so how many?

Is there any other way we can do it?

Editing the Data in a GridView

In addition to deleting a GridView's underlying data, another common need is to allow end users to edit the data displayed in a GridView. With ASP.NET 1.x's DataGrid control, editing the data is certainly possible, but requires creating three event handlers and writing a dozen or so lines of code. With the GridView and ASP.NET 2.0, it is possible to create an editable GridView without writing a single line of code! All of the necessary functionality is encapsulated within the GridView.

The GridView allows editing on a row-by-row basis. An editable GridView contains an additional column with an Edit button in each row. When the end user clicks on an Edit button that row becomes editable, causing the Edit button to change to Update and Cancel buttons and the other columns to become TextBoxes. The end user can then update one or more column values and click Update to save their changes.

Toolbox: Data Snapshots, Subversion, Source Code Organization and More


If you want to save, organize, and annotate snapshots of your database data, find an easy way to install and configure Subversion, and automate the organization of your source code, then you'll want to read more about these latest tools.

Scott Mitchell

MSDN Magazine August 2009

Data Points: SqlConnectionStringBuilder, DataView, and More


Several significant enhancements have been made to ADO. NET 2. 0 in the areas of improved performance, increased flexibility, and added features. In my last column (Data Points: DataSet and DataTable in ADO.

John Papa

MSDN Magazine January 2006

Data Points: Data Source Controls in ASP.NET 2.0


ASP. NET 2. 0 introduces a series of new tools that improve data access including several data source and data bound controls. The new assortment of data source controls can eliminate a ton of repetitive code that was required in ASP.

John Papa

MSDN Magazine January 2005

Data Points: Updating Data in Linked Servers, Information Schema Views, and More


Every day a developer somewhere needs to write code to iterate through SQL ServerT system objects, query and update tables in linked servers, handle optimistic concurrency, and retrieve column and stored procedure metadata.

John Papa

MSDN Magazine November 2004

Empty Website Data Source windown


Hi all,

I am Visual Web Developer user and facing a problem when I am creating a local report (.rdlc) file.

I am using Business objects as the Data Source for this report. It was working perfectly until all the items in the Website Data Source window suddenly "disappeared". The "Add New Data Source" button on this window is also disabled. Now the window is just like a blank box only. And I can't continue working with the report file like this...

I have tried undoing what I did before but it does not help at all...

Any reason for this to happen? There is no sign or something at least indicating what is wrong.

Please help.


 ps: found a similar thread in this forum but not solved

The report cannot be opened because the data source associated with it is not a report model.


i tried to open a report i created in sql business intelligence development studio in the report builder in wss3 and it gave me this error:

Microsoft.ReportingServices.ReportBuilder.ReportModel.Report: The report 'http://servername:port#/Reports/report.rdl' cannot be opened because the data source 'http://servername:port#/DataSource Library/datasource.rsds' associated with it is not a report model.

This report was not created in Report Builder. Try opening this report in Report Designer instead.

can i fix this so i can open my reports in report builder?


BDC Entity as a Data Source for a Lookup column

Is it possible to create a custom lookup field type to have a BDC entity as the data source?

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