I wanted to post a reminder that SharePoint Saturday Boston is coming up next Saturday, March 14, at the Microsoft offices in Waltham, MA. I’ll be doing a session entitled Developing with SharePoint Designer: The Middle Tier, Focus on Data View Web Parts (DVWPs) and talking about a lot of the techniques that you’ve seen…
When you are building a DVWP in SharePoint, there are some project (Web site) and list properties that are available to you directly from CAML that aren’t well-documented, which you can use if you request them directly. For instance, if you add the following to your CAML <ListProperty Name=”Title” /><ProjectProperty Name=”Title” />, the titles of…
I think I’ve found a bug in using aggregate data sources in DVWPs with SQL Stored Procedures. I’m trying to use the results of a Stored Procedure combined with the content of a list in SharePoint. I’ve isolated the issue to the Stored Procedure. The first asp:SqlDataSource statement below is what I want the data…
Sometimes when you create and configure a Data View Web Part (DVWP), you’ll see the PermMask column show up on its own in the DataFields or the CAML in your DataSource. This happens most often when you are building a Crosslist query (DataSourceMode=”CrossList”). The PermMask column contains the permissions mask for the item for the…
Another name drop and tip ‘o the hat to Mauro Cardarelli for bringing this one to my attention. SharePoint Saturday is coming to Boston. I’m going to see if I can’t get in as a speaker to talk about my SharePoint Designer DVWP stuff. Working title: Developing with SharePoint Designer: The Middle Tier, Focus on Data…
I think I’ve found an interesting (if you think things like this are interesting) difference between Document Libraries and Custom lists when it comes to the use of Site Columns. I had some filtering code in a DVWP that ought to have worked the same way on both a Custom List and a Document Library,…
When you want to display blog posts and announcements with DVWPs in your SharePoint Site Collection, you usually don’t want to display the full posts, but just enough to indicate what the item is about and to let the user know if they should click to see more. An example might be showing the last 3…
SharePoint has a nice capability on many pages where, if you pass a Query String parameter named Source with a value of a page URL, the user is returned to that page when they are done with the activity. An example would be when a user clicks on an ‘Add new document’ list on a…
I figured out a great little trick for sorting a DVWP-based display based on a column name passed in the Query String. You can see this in action in the default All Items or All Documents views in lists or libraries. When you click on the column headers that allow sorting, the browser is sent…
This is another idea that I was certain I’d posted about long ago, but I can’t seem to find. It’s especially useful if you are developing Data View Web Parts (DVWPs) in one environment and then porting them to another on any sort of frequent basis. When you create a Data Source for a SharePoint…