Datasheet View Errors With Office 2007

We recently started upgrading all of our employees to Office 2007 (from 2003). We’ve seen a lot of different errors but nothing pandemic. One of the errors is related to the datasheet view. I started doing some research and this blog has everything you need…

Add a Document Icon to the CBQ

When you want to change the look of the results in a Content By Query web part you modify the ItemStyle.xsl file in the Style Library of your site. You can find more information here.

I created a custom style to display links to documents. If you are pulling documents directly from a document library, you can make the modifications to the XSL that are documented in this posting.

My custom style is pulling links and titles from a custom list so I needed to get the file extension to generate the icon. Luckily there’s a function in the ddwrt namespace for doing this. It’s documented here.

So now you just need to build the link to the image and link it to the document URL. My variable with the document URL is @DocURL. You should substitute your own doc URL variable. Just add this to your style where you want the icon to appear.
<A TABINDEX=-1 href={@DocURL} target=_blank>
<img border=0 src=/_layouts/images/ic{ddwrt:GetFileExtension(@DocURL)}.gif alt={@DocIcon} style=vertical-align: middle;margin-right:4px />

Using Silverlight in SharePoint

Hopefully more on this soon, with examples. Check out this site with sample web parts. The site includes all of the code and walk throughs.