ansaurus

Question

Sharepoint DataFormWebPart

Answer 1

A:

The only way I found of manipulating parameters at run time was from C# code behind.

Here are the steps required:

Dump your DataFormWebPart code into an ascx control. (or a custom webpart if you wish).
In the code behind of the control, reference your DataFormWebPart via it's ID just like you would to any other user control such as a text box.
Use the DataFormWebPart object to fiddle with its Data Source (if required) and its queries. You can get a handle on all of its parameters.

Zeb 2010-03-03 17:03:14

Answer 2

+1 A:

You can do this using a QueryString parameter on the DataForm. I'm assuming you're only able to export the webpart. So, export the webpart and save the .webpart to your desktop. Open it and modify it like so:

In your DataSourcesString remove the where clause entirely:

<property name="DataSourcesString" type="string">&lt;%@ Register TagPrefix="sharepoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %&gt;&lt;sharepoint:SPDataSource runat="server" DataSourceMode="List" SelectCommand="&amp;lt;View&amp;gt;&amp;lt;Query&amp;gt;&amp;lt;OrderBy&amp;gt;&amp;lt;FieldRef Name=&amp;quot;ID&amp;quot;/&amp;gt;&amp;lt;/OrderBy&amp;gt;&amp;lt;/Query&amp;gt;&amp;lt;/View&amp;gt;" UseInternalName="True" IncludeHidden="True" ID="datasource1"&gt;

In the <property name="ParameterBindings" type="string"> node, add:

&lt;ParameterBinding Name="MyVariable" Location="QueryString(MyVar)"/&gt;

In the XSL for the webpart itself, find <xsl:param name="dvt_partguid" /> and just below it add:

&lt;xsl:param name="MyVar" /&gt;

Finally, find select="/dsQueryResponse/Rows/Row and modify it to be:

select="/dsQueryResponse/Rows/Row[@Primary='$MyVar']

Save the webpart, upload it back, and you should now be able to filter it by adding MyVar=Whatever to your querystring

zincorp 2010-03-04 17:24:31

Thanks, can you tell me where exactly can I edit the querystring for the web part?

nav 2010-03-09 17:59:44

I figured out I had the make the connection to the querystring on the web part. But can't figure out what to enter in the parameters editor for MyVar. I tried this but didnt get the right result ... ParameterBinding Name="MyVariable" Location="QueryString(lt;Where><Eq><FieldRef Name="Primary"/><Value Type="Text">Dispute Resolution</Value></Eq></Where>)"/>

nav 2010-03-09 18:12:29

It should look exactly as I pasted it: <ParameterBinding Name="MyVariable" Location="QueryString(MyVar)"/> - This tells it to grab the QueryString parameter named "MyVar"

zincorp 2010-03-09 21:51:15

thanks, but what i was trying to ask was where in the web part's configuration should the querystring be edited?

nav 2010-03-10 11:54:36

ansaurus

tags:

views:

answers:

Sharepoint DataFormWebPart

related questions