dataviewwebpart

Passing parameters to an RSS Feed from a Data View Web Part in Sharepoint

I have a Data View Web Part in Sharepoint that is being fed from an RSS Feed. I have the Data Source configured properly to read the RSS Feed and I have added serveral runtime parameters. My question is, how do I supply these values at runtime? For example, one of the parameters is startDate and this should be populated with the current ...

Filter a Data View Web Part by "last 3 days"

We have a custom list that has a column called "Connection Date" and need to display the most recent list items (relative to this "Connection Date" column) in various places across the portal. the Data View Web Part appears to be the best solution, but I'm having difficulty finding the right method & syntax to filter by date. I can cre...

SharePoint DataView Show Items from last week.

I have a SharePoint DataView WebPart that is set up to combine data from a few different lists. I want to filter the data to only show data from last week. I am able to filter it to show data from this week, but have been unsuccessful in getting last week's data to show up. I have the web part filter set up like below: This transla...

Dataview web part fails after minor changes.

We're working with a sharepoint 2007 site that has a number of dataview webparts showing different views of a document repositry. Each time we make even the most minor change (such as changing the chrome settings or adding a class) to the XSLT or webpart settings the DV webpart refuses to render. Our XSL is vaild, as is the page the GU...

sharepoint data view web part xslt without schema

I'm trying to use a data view web part (via SPD 2007) to consume the results of a SOAP-based web service and render portions of said results using XSL transforms. The problem I'm having is that the designer isn't much help because the schema for the web service doesn't actually include the elements of the results, so there's no way to d...

Basic Data View Setup Throws Error When Trying to Edit or Insert SQL Server Data on SharePoint Page

Using: - MOSS 2007 - SQL Server 2005 (and Management Studio Express) - SharePoint Designer 2007 - Northwind Database (dbo.categories) First, I am a total novice, so I am fully expecting a user error answer ;) Here is what I did: - Opened a blank Web Part page in SharePoint Designer - Inserted a Data View - Set up a connection to the No...

Can the ID from a referenced column be obtained when using SharePoint's Data View Part?

I have a Data View Part pulling from a list that has a lookup column to another list (title linked by ID) And somewhere in the XSLT of the data view web part configuration, it reads <xsl:value-of select="@ColumnX"/> Now since ColumnX is a reference to another list (linked to item), how do I go about obtaining the ID rather than the t...

SharePoint WSS 3.0 - Fastest approach to build data-bound forms?

Pardon the vague question, but I've just inherited a project to build a couple dozen forms pulling data from a SQL 2005 database. The forms are mostly standard database lookups with just a couple updates so the data layer is very simple -- I'm the DBA -- but we just recently started using SharePoint WSS 3.0 for a departmental web site an...

Paging To The End Of A Data View Web Part

Hi all! Hopefully you can help me with this. I've displayed an Announcement web part on a page with 20 items. I opened up SharePoint Designer 2007 and set the paging to 6 items. I've added a little bit of (OOB) functionality so that I have buttons for START, PREVIOUS, and NEXT. These work well without any problems but I'm wondering how...

Sharepoint data view web part toolbar sorting default

I have a data view web part on a page which is displaying a table of data. I want to allow users to choose which column to sort by. I think the only way to do this is go into the data view properties, and enable the toolbar with sorting. This works and allows the user to select a column to sort using a dropdown list of columns. The defa...

SharePoint Data View Web Part ParameterBinding and Filtering...WSS vs. MOSS

I have a DataViewWebPart that is filtered based on a text box which contains the a string. When run under WSS, the first time the page loads, it filters the data fine. When run on a MOSS machine, the first time the page loads, no data is appearing. The text box has the correct value in it to filter. I also have a drop down list in a...

Remove output-escaping in xslt

tag is added to the text if i set format as "Text". i want to remove this tag programatically. Is there any way to convert the string from text format to Rich text format programatically. I know we can do it by clicking the smart tag and selecting format as "richtext", however problem with this is it will not display the tag in string...

Dataview webpart to display data from multiple list across site collection in Sharepoint.

Hi all, I have two site collections named SiteColl1 and SiteColl2. SiteColl1 contains List1. SiteColl2 contains List2. Now I want to display data from both lists [List1 and List2] in Dataview Webpart. My Dataview webpart is placed in SiteColl1. Is it possible to do the same? If YES, please suggest!!!! Cheers!!! Ketan ...

Assign Query String Values to Selectcommand parameter in <SharePointWebControls:SPDataSource> in Data view web part in MOSS 2007

Hi, I have two pages EventList.aspx and EventDetail.apsx. When user selects any events [basically list item] on EventList.aspx page [all events are rollup in single sote collection] in am redirected to EventDetail.aspx page with QueryString ListID and ListItemId. On EventDetail.aspx page i am using < SharePointWebControls:SPDataSourc...

Building a custom DataFormWebPart

Hi All, Can anyone tell me how I should go about building a custom dataview webpart (i.e. dataform web part)? this is the code that I have got so far: [DefaultProperty("Text"), ToolboxData("<{0}:DataViewWP runat=server>"), XmlRoot(Namespace = "DataViewWP")] public class DataViewWP : Microsoft.SharePoint.WebPartPages.DataFormWebPart { ...