.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

Display data from two lists in a single Data View - how to edit/delete/view items?

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :SharePoint

I have an aggregate dataview from two lists. (something like this http://office.microsoft.com/en-us/sharepoint-designer-help/display-data-from-multiple-sources-in-a-single-data-view-HA010099144.aspx#BM3)

The problem is, that when I click on "Data view properties", the options in Editing tab (edit link, delete link and view link) are greyed out.

 I'd like to create custom delete/edit/view link for rows in that dataview with linked source. Any idea?

View Complete Post

More Related Resource Links

how to display multiple calendar list data in single calendar view

Hi, Normally, we can used to extend the ListViewWebPart's ViewType property to display a particular calendar list items in Calendar View in our custom webpart. Is it any way to display multiple calendar list data in a single calendar view ?? or please provide some pointers related to this issue. Any help is much appreciated.    

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



How to display the latest list items in the data view webpart

Hi Guys,

I am pretty new to the SharePoint designer. So don't know much of its capabilities.

I am creating a dataview webpart which display the data from the sharepoint list. In this webpart, i have to display data only for last created date means if we have data in list for 12th, 13th, 14th and 15th march data view display data for date 15th march.
I tried using the simple filter with current date but that not worked. Any idea how we can achieve this.

Thanks in advance,
Thanks, Cool Developer

How to properly configure permissions so users can view, add, edit, and delete list items, but not w

I am trying to figure out how to properly setup security so that it can be configured at the top-level, and then inherited all the way through. Here is what I would like to do: Each user can view, add, edit, and delete list items - but, users cannot modify or delete web part pages. The only way I know how to do this is set Contribute from the top-down, and then go into each Site Pages library and set Read access. The problem is that I have 100 sites, and I was hoping there was a way I could set security at the top, and inherit downward. Rather than having to go into all 100 Site Pages library and set Read access. Is there a way to do this? Thanks in advance.

In data view web part - how to display document name with link that opens lookup document rather tha

I have a list with a lookup column to create relationships with documents in a separate library. I am creating a data view web part to display each item in the list. One of the fields I want to display is the document field (the lookup column). I want this to be in the form of the related document's name with link to directly open the source document itself (Word, PPT, ...). Now I am only managing to display the document name linked to opening the document's display form of the related document library, and then I have to click the document's name there to open it. Alas one unnecessary click too many. Any wize tips? Henning

how to write xslt in data view web part to display visifire charts

Hello All, I am writing xslt to display created by column in visifire charts. but it is not displaying chart. same code for displaying custom column is working fine but i dont know where i am going wrong in case of created by column. i put internal name also which is author for this column but no luck. below is the code i had used to display visifire chart. <xsl:text disable-output-escaping="yes">     <![CDATA[                     + ' <vc:DataPoint AxisXLabel="DTL3]]></xsl:text>   <xsl:text disable-output-escaping="yes"><![CDATA[" YValue="]]></xsl:text>     <xsl:value-of select="count(/dsQueryResponse/Rows/Row[normalize-space(@Author) = 'A'])"/>     <xsl:text disable-output-escaping="yes"><![CDATA[" LabelText="DTL3]]></xsl:text>     <xsl:text disable-output-escaping="yes"><![CDATA[" Exploded="False]]></xsl:text>     <xsl:text disable-output-escaping="yes"><![CDATA["/>']]></xsl:text> but the same code for different column name is working fine. please provide your inputs, where i am doing wr

Auto-fill Title and other fields from a data View edit menu

How do I Auto-fill Title and other fields in a list from a data View edit menu. The Title and other current data should transfer from the data view row being edit. Can anyone point me into the right direction how to accomplish this? Thanks. Mike  

Show filtered data from multiple data lists in a view


I am attempting to build a very simple Sharepoint site with 3 data lists: 1) Themes,  2) Value Statements, 3) Supporting Details

Each Theme has 2+ Value Statements and each Value Statement has 2+ Supporting Details. 

Currently, I have the Forms setup so that when I enter a new Supporting Detail, the individual must select from the avaialable Value Statements (using a Lookup Column). 

What I would like to do, now, is allow an individual who is looking at a view of all the Value Statements to see the Title field of all the Supporting Details that have been entered for that particular Value Statement (with hyperlinks).

I'm guessing that I need to use SharePoint Designer 2010 to customize the view, but am not certain how to do it from there.


Combining view-only data and Dynamic Data on insert/edit pages


Hello all, here's a problem I've been trying to figure out an elegant solution for, but so far I'm coming up blank. I have a situation where I'd like to display view-only data and Dynamic Data together on the same page (without creating custom insert.aspx and edit.aspx pages). I've been playing around with using a SQL view, so that it returns me both my view-only fields and my updateable fields as well. I'm having issues with the insert side of things, the edit page works quite well, and I know I'm going to have to create custom delete logic. The major drawback to using a SQL view though is that to get it to behave you have to 'hack' the .edmx file, and I'm not sure I want to do that. So I guess what I'm asking is that has anyone had any success with this, or should I just bite the bullet and create custom pages for the situation of having view-only data and Dynamic Data on the same page? For the record I'm using the Release Candidate version of VS, and my website is an "ASP.NET Dynamic Entities Web Site". Thanks!

Create view by getting data from different lists.

I want to create a view by getting data from 3 different lists.Is it possible to create a view like that?

Custom Display in Data View column in SharePoint



I am using SharePoint designer 2007 to create Data View web part where I want custom display text in one column depending upon condition. In designer there is way to implement custom display which allows to change style conditionally. Is there any way to change the text conditionally?

Just to underline the problem I want to change text in Data View column conditionally.



Created a data view pages using sharepoint designer but can not display under browser



I created a data view page using the datasource I created connecting to our sql 2005 database.  I can see all data displyed in sharepoint designer 2007.

But once I preview it or run it from sharepoint site after saving it, I got this error.  Can anybody give me some clue or tips on how to fix it?

Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Windows SharePoint Services-compatible HTML editor such as Microsoft Office SharePoint Designer. If the problem persists, contact your Web server administrator.

Thanks a lot



Data Form Web Part - Sharepoint Dropdown List as a field in Edit View - Possible?


Hi guys,

I'm building a Sharepoint page with a data form web part that uses custom SELECT and UPDATE statements with an SQL Server connection in order to retrieve and store records of information.

I'm getting along fine, records seem to update how they should etc, but I've ran into a problem with one thing: Sharepoint dropdownlists in 'Edit Template'

So the issue is this: if I replace a textbox field with a dropdown list that is populated with a separate SQL datasource, the dropdown list seems to be unable to show the current value of the field.

E.g. I have a dataview which has a field "FruitID", which I can update just fine by setting the ID value to different numbers. The SQL datasource uses the FruitID to display a list of all available Fruits, (e.g. 1 = Banana, 2 = Apple, 3 = Cherry, etc).

If i open the dataview in editmode, the default value in the dropdown is null, despite the real value of the field being "2", which should show "Apple" in the dropdown.

I can select a fruit and click save, and it will update just fine. But the initial display needs to show the correct value to start with.

Is there a custom binding I should be coding to make this work? I can't configure dropdown <items> on an individual level as they are populated from the SQL server. I can't set "SelectedI

Vista and Office: View Data Your Way With Our Managed Preview Handler Framework


Stephen Toub shows you how to write your own Preview handlers for Windows Vista and Outlook 2007.

Stephen Toub

MSDN Magazine January 2007

Disable filtering on a Dynamic Data list view.


I have an entity set of NotificationTemplates, and each one of these has a collection of zero-many SmsTemplate entities. When editing or viewing a NotificationTemplate, I have a link to View SMS Templates. That link takes me to a List view for the SmsTemplates entity set, filtered for the NotificationTemplate I was viewing.

How can I prevent the user changing this filter to show SmsTemplates for another NotificationTemplate? That is, I want the filter, but it must be read only. The drop-down just mustn't drop down, it must just display the name of the NotificationTemplate that these SmsTemplates belong to. To view SmsTemplates for another NotificationTemplate, the user must click View SMS Templates from that other template.

This was originally asked by myself on SatckOverflow at: http://stackoverflow.com/questions/3514373/disable-filtering-on-a-dynamic-data-list-view

show data in grid view error Arithmetic operation resulted in an overflow.



i have a table there is 17 columns in 17 column 3 are number and other are varchar . when i try to display all data of that column error occures.

one more intersting think is when i try to display 6 column then grid show there data an no more error occures. 

when i run my project this error occures in grid view

Arithmetic operation resulted in an overflow. 

Entity Data Model and database view returning the same columns as there are in a table


When adding a stored procedure into the Entity Data Model I can select whether the procedure returns a scalar, a (new) complex type or one of the entity types I already defined. 

How do I do something similar for a view?

I mean assuming I have a view like this

CREATE VIEW FilteredFoos as SELECT Foo.* FROM Foo join ... WHERE ...

(that is a view that implements some involved filtering, but returns all columns from one table) how do I add it to the project so that I can use the entity set, but get the Foo objects, not some new FilteredFoo objects.

var foos = myDB.FilteredFoos.Include("Bar").ToList();

foreach (Foo foo in foos) { ...

Thanks, Jenda

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