Column XML

This property is used to identify the columns to retrieve from the data source(s) to either display or reference in the Grid Display Adapter. Column that you want to use for grouping, filtering, etc. but do not want to display can be defined with Display set to false.

If the AutoGenerateColumns element in the Grid Setup XML property is set to false (so the grid will not create a grid column for every column in the data source), the Column XML property must be populated.

When working with actions, the following columns are required:

•      Select

•      SPItemID

•      SPListID

•      ObjSiteURL

The elements that can be used to identify the columns and define if and how they are displayed include:

•      ColumnType – The supported values are Bound and ClientSelect.

•      Unique Name

•      HeaderStyleWidth

•      HeaderStyleHorizontalAlign

•      HeaderStyleVerticalAlign

•      ItemStyleWidth

•      ItemStyleCssClass

•      DataField

•      HeaderText

•      SortExpression

•      Display – Set this to False if you want to reference the column for filtering, grouping, etc., but do not want it to be displayed in the grid.

•      Aggregate

Example:

<Columns>           

<Column>                             

<ColumnType>ClientSelect</ColumnType>                  

<UniqueName>Select</UniqueName>                          

<HeaderStyleWidth>5%</HeaderStyleWidth>

<HeaderStyleHorizontalAlign>Center</HeaderStyleHorizontalAlign>

<HeaderStyleVerticalAlign>Center</HeaderStyleVerticalAlign>

<ItemStyleWidth>5%</ItemStyleWidth>

<ItemStyleCssClass>EditBoxCenter</ItemStyleCssClass>

</Column>           

<Column>                             

<ColumnType>Bound</ColumnType>                            

<DataField>SPItemID</DataField>                   

<HeaderText>SPItemID</HeaderText>                          

<SortExpression>SPItemID</SortExpression>                               

<UniqueName>SPItemID</UniqueName>                     

<Display>False</Display>                  

<Aggregate>None</Aggregate>

</Column>           

<Column>                             

<ColumnType>Bound</ColumnType>                            

<DataField>SPListID</DataField>                     

<HeaderText>SPListID</HeaderText>                            

<SortExpression>SPListID</SortExpression>                 

<UniqueName>SPListID</UniqueName>                       

<Display>False</Display>                  

<Aggregate>None</Aggregate>

                </Column>           

<Column>                             

<ColumnType>Bound</ColumnType>                            

<DataField>ObjSiteURL</DataField>                               

<HeaderText>ObjSiteURL</HeaderText>                      

<SortExpression>ObjSiteURL</SortExpression>                           

<UniqueName>ObjSiteURL</UniqueName>                 

<Display>False</Display>                  

<Aggregate>None</Aggregate>      

</Column>

                <Column>                             

<ColumnType>Bound</ColumnType>                            

<DataField>Title</DataField>                           

<HeaderText>Title</HeaderText>                  

<SortExpression>Title</SortExpression>                       

<UniqueName>Title</UniqueName>                              

<HeaderStyleWidth>40%</HeaderStyleWidth>                          

<ItemStyleWidth>40%</ItemStyleWidth>                     

<Aggregate>None</Aggregate>                      

<AllowFiltering>false</AllowFiltering>

</Column>           

<Column>                             

<ColumnType>Bound</ColumnType>                            

<DataField>Status</DataField>                        

<HeaderText>Status</HeaderText>               

<SortExpression>Status</SortExpression>                    

<UniqueName>Status</UniqueName>                           

<HeaderStyleWidth>30%</HeaderStyleWidth>                          

<ItemStyleWidth>30%</ItemStyleWidth>                     

<Aggregate>None</Aggregate>                      

<AllowFiltering>false</AllowFiltering>

</Column>           

<Column>                             

<ColumnType>Bound</ColumnType>                            

<DataField>DueDate</DataField>                   

<HeaderText>Due Date</HeaderText>                         

<SortExpression>DueDate</SortExpression>                               

<UniqueName>DueDate</UniqueName>                      

<HeaderStyleWidth>20%</HeaderStyleWidth>                          

<ItemStyleWidth>20%</ItemStyleWidth>                     

<Aggregate>None</Aggregate>                      

<AllowFiltering>false</AllowFiltering>

</Column>

</Columns>

Back to Top