{"id":179,"date":"2010-05-28T22:36:12","date_gmt":"2010-05-28T20:36:12","guid":{"rendered":"http:\/\/jsiegmund.wordpress.com\/2010\/05\/28\/sp2010-programmatically-creating-a-web-part-page-with-connected-webparts\/"},"modified":"2013-04-18T18:41:43","modified_gmt":"2013-04-18T17:41:43","slug":"sp2010-programmatically-creating-a-web-part-page-with-connected-webparts","status":"publish","type":"post","link":"http:\/\/blog.repsaj.nl\/index.php\/2010\/05\/sp2010-programmatically-creating-a-web-part-page-with-connected-webparts\/","title":{"rendered":"SP2010: Programmatically creating a web part page with connected webparts"},"content":{"rendered":"

In my quest of creating dynamic sites in code, I stumbled upon a problem. What to do with the content of sites you’re creating dynamically? You can create lists fairly easy, creating things like views is a little more complicated but still doable. But when it comes to things like pages, things get a little bit more tricky. As long as your content is static, you can create a feature to deploy an aspx page to either ghosted or unghosted stored (in the database or in the filesystem). But if you want to show list data, for instance, or even more advanced: what about BCS data from a LOB system, based upon the site the page is located in? Well I’ve got it all figured out now, so I guessed that would be something to share! <\/p>\n

First station: creating webpart pages dynamically. This is a\u00a0fairly easy thing to do. You need to copy one of the templates which are located in C:\\Program Files\\Common Files\\Microsoft Shared\\Web Server Extensions\\14\\TEMPLATE\\1033\\STS\\DOCTEMP\\SMARTPGS. These are the same templates you can choose from when creating a webpart page from within SharePoint or SharePoint Designer. You can copy these and use them to create your own templates from; actually something we’ll need to do\u00a0later on.<\/p>\n

Here’s the code you need to create the page:<\/p>\n

FileStream<\/span> stream = new<\/span>
\nFileStream<\/span>(Path<\/span>.Combine(hive, templateFilename), FileMode<\/span>.Open);
\n<\/span><\/p>\n

SPFolder<\/span> libraryFolder = web.GetFolder(foldername);
\n<\/span><\/p>\n

SPFileCollection<\/span> files = libraryFolder.Files;
\n<\/span><\/p>\n

SPFile<\/span> file = files.Add(pagename, stream);
\n<\/span><\/p>\n

One thing which might need explaining is the hive variable, not that hard but important:<\/p>\n

static<\/span>
\nstring<\/span> hive = SPUtility<\/span>.GetGenericSetupPath(“TEMPLATE\\\\1033\\\\STS\\\\DOCTEMP\\\\SMARTPGS\\\\”<\/span>);
\n<\/span><\/p>\n

Ok, so this should set you up with a nice and clean webpartpage, based upon one of the templates. Now for adding the webparts to it.<\/p>\n

The easiest thing to do is to setup the webparts on an existing page in SharePoint (you could use the one you just created, but anyone will do). You can use SharePoint or SharePoint designer, that doesn’t make a difference. Once you’ve got the webpart setup the way you want it to (don’t bother to make connections, that’ll be useless), export it. This can be done in SharePoint designer by selecting the webpart, choosing the “Web Part” ribbon menu and clicking “To file”<\/p>\n

\"\"<\/p>\n

Now once you’ve saved your webpart file, you can add it to your new webpartpage with the following code:<\/p>\n

SPLimitedWebPartManager<\/span> wpmngr = file.Web.GetLimitedWebPartManager(file.ServerRelativeUrl, scope);
\n<\/span><\/p>\n

string<\/span> error = string<\/span>.Empty;
\n<\/span><\/p>\n

FileStream<\/span> file = new<\/span>
\nFileStream<\/span>(webpartFileLocation, FileMode<\/span>.Open);
\n<\/span><\/p>\n

System.Web.UI.WebControls.WebParts.WebPart<\/span> webpart = wpmngr.ImportWebPart(XmlReader<\/span>.Create(file), out<\/span> error);
\n<\/span><\/p>\n

wpmngr.AddWebPart(webpart, zone, 0);
\n<\/span><\/p>\n

Couple of things to explain\u2026 You need to get the SPLimitedWebPartManager object to add the part to the page. You can feed the manager the XML from the webpart file which is loaded in a FileStream which is then fed into a XmlReader. The out parameter will contain any error messages, I’m not sure why that approach was chosen, I like exceptions more so you could just wrap the whole thing to throw an exception when something goes wrong:<\/p>\n

try<\/span>
\n<\/span><\/p>\n

{
\n<\/span><\/p>\n


\nFileStream<\/span> file = new<\/span>
\nFileStream<\/span>(webpartFileLocation, FileMode<\/span>.Open);
\n<\/span><\/p>\n

System.Web.UI.WebControls.WebParts.WebPart<\/span> webpart = wpmngr.ImportWebPart(XmlReader<\/span>.Create(file), out<\/span> error);
\n<\/span><\/p>\n

wpmngr.AddWebPart(webpart, zone, 0);
\n<\/span><\/p>\n


\nreturn<\/span> webpart;
\n<\/span><\/p>\n

}
\n<\/span><\/p>\n

catch<\/span> (Exception<\/span> ex)
\n<\/span><\/p>\n

{
\n<\/span><\/p>\n


\nif<\/span> (!String<\/span>.IsNullOrEmpty(error))
\n<\/span><\/p>\n


\nthrow<\/span>
\nnew<\/span>
\nException<\/span>(error);
\n<\/span><\/p>\n


\nelse<\/span>
\n<\/span><\/p>\n


\nthrow<\/span>;
\n<\/span><\/p>\n

}
\n<\/span><\/p>\n

If you now view your page, you webpart should be on there. A little tip: when you use a webpart which is styled with XSLT (like most BCS parts for instance), you can edit the XML of the webpart, strip the XSL code and use the XslLink property to link the webpart to an actual XSLT file. That way, if you deploy the page multiple times; all parts link to the same XSLT and updating the look-and-feel becomes real easy.<\/p>\n

Now for the last step: connecting the webparts. I’ll share the complete method which I use for this purpose:<\/p>\n

\/\/\/
\n<summary><\/span>
\n<\/span><\/span><\/p>\n

\/\/\/ Connects two webparts to each other<\/span>
\n<\/span><\/p>\n

\/\/\/
\n<\/summary><\/span>
\n<\/span><\/span><\/p>\n

\/\/\/
\n<param name=”consumerWebPart”>The webpart which will consume the data<\/param><\/span>
\n<\/span><\/span><\/span><\/span><\/p>\n

\/\/\/
\n<param name=”consumerInterfaceType”>The type of interface the consumer endpoint should have<\/param><\/span>
\n<\/span><\/span><\/span><\/span><\/p>\n

\/\/\/
\n<param name=”providerWebPart”>The webpart which will provide the data<\/param><\/span>
\n<\/span><\/span><\/span><\/span><\/p>\n

\/\/\/
\n<param name=”providerInterfaceType”>The type of interface the provider endpoint should have<\/param><\/span>
\n<\/span><\/span><\/span><\/span><\/p>\n

public<\/span>
\nvoid<\/span> ConnectBusinessDataWebParts(
\n<\/span><\/p>\n

System.Web.UI.WebControls.WebParts.WebPart<\/span> consumerWebPart,
\n<\/span><\/p>\n


\nstring<\/span> consumerConnectionPoint,
\n<\/span><\/p>\n

System.Web.UI.WebControls.WebParts.WebPart<\/span> providerWebPart,
\n<\/span><\/p>\n


\nstring<\/span> providerConnectionPoint,
\n<\/span><\/p>\n


\nWebPartTransformer<\/span> transformer)
\n<\/span><\/p>\n

{
\n<\/span><\/p>\n


\n\/\/ Get the connection point for the consumer.<\/span>
\n<\/span><\/p>\n

System.Web.UI.WebControls.WebParts.ConsumerConnectionPointCollection<\/span> consumerConnections =
\n<\/span><\/p>\n

wpmngr.GetConsumerConnectionPoints(consumerWebPart);
\n<\/span><\/p>\n


\nConsumerConnectionPoint<\/span> consumerConnection = null<\/span>;
\n<\/span><\/p>\n


\nforeach<\/span> (ConsumerConnectionPoint<\/span> cpoint in<\/span> consumerConnections)
\n<\/span><\/p>\n

{
\n<\/span><\/p>\n


\nif<\/span> (cpoint.ID == consumerConnectionPoint)
\n<\/span><\/p>\n

{
\n<\/span><\/p>\n

consumerConnection = cpoint;
\n<\/span><\/p>\n


\nbreak<\/span>;
\n<\/span><\/p>\n

}
\n<\/span><\/p>\n

}
\n<\/span><\/p>\n


\n\/\/ Get the connection point for the provider.<\/span>
\n<\/span><\/p>\n

System.Web.UI.WebControls.WebParts.ProviderConnectionPointCollection<\/span> providerConnections =
\n<\/span><\/p>\n

wpmngr.GetProviderConnectionPoints(providerWebPart);
\n<\/span><\/p>\n


\nProviderConnectionPoint<\/span> providerConnection = null<\/span>;
\n<\/span><\/p>\n


\nforeach<\/span> (ProviderConnectionPoint<\/span> ppoint in<\/span> providerConnections)
\n<\/span><\/p>\n

{
\n<\/span><\/p>\n


\nif<\/span> (ppoint.ID == providerConnectionPoint)
\n<\/span><\/p>\n

{
\n<\/span><\/p>\n

providerConnection = ppoint;
\n<\/span><\/p>\n


\nbreak<\/span>;
\n<\/span><\/p>\n

}
\n<\/span><\/p>\n

}
\n<\/span><\/p>\n


\n\/\/ when a transformer was used; create a new connection based on it; otherwise without one<\/span>
\n<\/span><\/p>\n


\nif<\/span> (transformer != null<\/span>)
\n<\/span><\/p>\n

{
\n<\/span><\/p>\n

Microsoft.SharePoint.WebPartPages.SPWebPartConnection<\/span> newConnection =
\n<\/span><\/p>\n

wpmngr.SPConnectWebParts(
\n<\/span><\/p>\n

providerWebPart, providerConnection,
\n<\/span><\/p>\n

consumerWebPart, consumerConnection, transformer);
\n<\/span><\/p>\n

wpmngr.SPWebPartConnections.Add(newConnection);
\n<\/span><\/p>\n

}
\n<\/span><\/p>\n


\nelse<\/span>
\n<\/span><\/p>\n

{
\n<\/span><\/p>\n

Microsoft.SharePoint.WebPartPages.SPWebPartConnection<\/span> newConnection =
\n<\/span><\/p>\n

wpmngr.SPConnectWebParts(
\n<\/span><\/p>\n

providerWebPart, providerConnection,
\n<\/span><\/p>\n

consumerWebPart, consumerConnection);
\n<\/span><\/p>\n

wpmngr.SPWebPartConnections.Add(newConnection);
\n<\/span><\/p>\n

}
\n<\/span><\/p>\n

}
\n<\/span><\/p>\n

Ok, lets go through the parameters: both webparts are passed in since we want to connect them. A webpart can have multiple connection points, so we need to specify which point we want to use. I do that by string, which you need to find out just by debugging. The naming differs from webpart to webpart, so don’t guess: debug! The last parameter is an optional WebPartTransformer. When both endpoints of the webparts have a different interface type, a transformer is needed to convert the value of one to match the type of the other. There are a couple of transformers:<\/p>\n

TransformableFilterValuesToEntityInstanceTransformer
\n<\/span><\/h2>\n

TransformableFilterValuesToFieldTransformer<\/span>
\n<\/span><\/p>\n

TransformableFilterValuesToFilterValuesTransformer<\/span>
\n<\/span><\/p>\n

TransformableFilterValuesToParametersTransformer
\n<\/span><\/p>\n

With some of them (TransformableFilterValuesToParametersTransformer<\/span> for instance) you need to specify the fieldnames of provider and\/or consumer. You’ll get an exception if you don’t sometimes<\/span>, but other times it just doesn’t work without an error; so keep an eye open for that.<\/p>\n

Ok, you now have all the building blocks to create a new webpartpage, add webparts to it and connect them with each other.<\/p>\n

One last tip: depending on the settings of your library, you may need to either Publish or Check-in your page. Both actions can be done on your SPFile object.<\/p>\n

Enjoy!<\/p>\n","protected":false},"excerpt":{"rendered":"

In my quest of creating dynamic sites in code, I stumbled upon a problem. What to do with the content of sites you’re creating dynamically? You can create lists fairly easy, creating things like views is a little more complicated but still doable. But when it comes to things like pages, things get a little<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[34],"tags":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p3KFR1-2T","_links":{"self":[{"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/posts\/179"}],"collection":[{"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/comments?post=179"}],"version-history":[{"count":0,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/posts\/179\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/media?parent=179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/categories?post=179"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/tags?post=179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}