SPGridView with SPDataSource in SharePoint 2010 Wiki pages
Just a quick post about an annoying issue we had to tackle recently.We needed to build a simple web part to show some data from a list with filtering and paging. As this was a SharePoint 2010 project only, we chose to use the new Visual Web Part (which is basically a user control loaded inside a web part, we used to do that in 2007 as well, just did not call it a visual web part, but who cares?)Visual web parts allow you to move much of the logic into the markup of the ASCX file, which means you can use drag and drop techniques for placing controls and other cool features we are all familiar with from the world of web site design.
In this case all we needed were a SPDataSource control, which provides us with the data from a SharePoint list, and SPGridView, which renders the data on a page, complete with SharePoint native CSS classes and general look and feel. All in all, a quick 5 minute job, no thrills. The problems started when we tried to enable filtering: it just would not work, the context menu would be stuck in "Loading" and nothing. After hitting the head against the wall, trying all kinds of workarounds, converting the whole thing into a regular web part, replacing the SPDataSource with ObjectDataSource, there was no progress! The whole thing took more than a day and still nothing.
Finally, a bright idea - put the web part on another page, the first time it was a rich text control on a Wiki page, but now a regular web part page with regular web part zones. And, voila! Everything working straight away, no coding required! The wiki page (or the rich text control specifically) probably has some included JS that interferes with the SPGridView and breaks the whole filtering AJAX infrastructure. It's a shame that Microsoft did not find out about it in their QA tests, but it happens to the best of us.
So, if for some reason, you run into this issue, now you have a clue what is going on.
San Francisco SharePoint Conference impressions
The SF SPTechCon 2011 just ended today. We were an exhibitor there, set up a booth and showed off our product demos. This was a very good experience for us, we had quite a few nice chats with potential clients and business partners. The people we talked to were generally very excited to see what our products can do and how useful they can be for them to implement various business processes using just their browser. We mainly focused on the Ultimate Forms bundle, showing the Vehicle Reservation form demo, a full-featured business process we built in some hour and a half. The new Smart Alert Pro alert management add-on also got some really enthusiastic responses. It was very interesting to hear what people thought about our products and what additional features they would want to see in them in the future,
A big thank you to all of you who visited us at the booth, hope to see you again at the next conference!