Used to add a column to the data collected from the external XML sources. This is useful if you want to set a default value for a column if the initial column is null, like a currency field.
Go to http://msdn2.microsoft.com/en-us/library/system.data.datacolumn.expression(VS.71).aspx for more information.
Example:
<AddColumn>
<Column>
<ColumnName>ZeroOfGroup1</ColumnName>
<ColumnType>System.Int32</ColumnType>
<Expression>IsNull(1*[Group Value0], 0)</Expression>
</Column>
</AddColumn>
The name of the column you want to add.
The type of column you want to add. See Convert XML/ColumnType for available options.
The expression used to store data within the column.
Use this property convert fields collected from the external XML from a String to a different type.
Example:
<Convert>
<Column>
<ColumnName>Start Date</ColumnName>
<ColumnType>System.DateTime</ColumnType>
</Column>
<Column> </Column>
</Convert>
The name of the column you want to convert.
The System Type you would like to convert the column to.
Options:
System.Boolean
System.Byte
System.Char
System.DateTime
System.Decimal
System.Double
System.Int16
System.Int32
System.Int64
System.SByte
System.Single
System.String
System.TimeSpan
System.UInt16
System.UInt32
System.UInt64
TableName (Optional) String
The name of the table which contains the column to convert. The TableName comes from the Table node used in the XML. For instance if your xml looks like <Data><Title>Hello</Title></Data><Data><Title>World</Title></Data> the name of your table is Data.
When enabled, forces any information to be passed into the page as a post request versus a get request. This disables the ability to add ?Parameter=Value to the page.
When enabled, content collected and rendered will not be collected again during view changes. If enabled, no new content is collected, which could cause items to not be visible for dates outside the range of the default view.
Used to specify the XSL to be used to format the content collected before it is displayed within the web part. For instance, if you wish to display an item as a link, you would use XSL to create a link to an item from the data collected.
This property also supports the Common Use Variables stated at the beginning of this help topic.
Options:
"[file]="
o Use this option to specify a URL to an XSL Stylesheet Template
o Example: [file]=<%SiteURL%>/Connections/TasksXSL.xml
<xsl:stylesheet> </xsl:stylesheet>
o Use this option to specify the XSL Stylesheet XML directly within the property
o Example:
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<Data>
<xsl:for-each select="NewDataSet/Table1">
<Item>
<Title><xsl:value-of select="Title" /></Title>
</Item>
</xsl:for-each>
</Data>
</xsl:template>
</xsl:stylesheet>
Controls the maximum future date that items are created for recurring items. Only used if Output As XML is turned on.
Specify the XML to display if no items are returned.
Example:
<NewDataSet/>
Tells the web part to output its contents as XML instead of a calendar display. Useful for displaying recurring events.
Output XML schema when outputting XML data.
Identify the OXMLWPName that must be called if you want this web part to run. If ?/&OXMLWPName=THISPROPERTY is not found in the URL or post to this page, the web part will not run. Use this in combination with the property Output as XML property.
Default: %Auto%
Example: MyWebPart
Page Call: default.aspx?OXMLWPName=MyWebPart
Use this property to pass page parameters onto the page specified in the URL To XML property. This supports the Common Use Variables stated at the beginning of this help topic. You must encode the < and > symbol when using the parameters (e.g., < < and > >).
Example:
<PassThrough>
<Pass>
<PTType>get</PTType>
<PTRequest>SearchString</PTRequest>
<PTName>SearchString</PTName>
<PTDefault>[Me]</PTDefault>
</Pass>
</PassThrough>
The default text that will be sent to the page that you are requesting data from, if the parameter is not passed into this page.
The name of the parameter to be passed onto the page that you are requesting data from.
The name of the parameter being received by the page.
Controls the type of pass through. Use "post" to store the parameters in the header of your request, or "get" to store them in the URL.
Options:
post
get
When enabled, displays the data being collected by this web part, presented within a custom grid. However, if you attempt to collect too much data, you could inadvertently crash your browser because too much data is trying to be rendered.
The URL to the data source that the calendar will reference for data to display. This property also supports the Common Use Variables stated at the beginning of this help topic.
Default: empty
Example:
http://domain.com/GridDataSources/Tasks
<%SiteURL%>/GridDataSources/Tasks