SharePoint datagrid

   Previous topic Next topic Print this topic Mail us feedback on this topic!

  Default  
  Web part control ID: Serves as an identifier for the web part. This ID must be unique within the context of each page template. The value of this property may only contain alphanumeric characters and the underscore character ( _ ).  
  Web part title: Title of the web part displayed on the Design tab of CMS Desk and in on-site editing mode. If empty, the value of the Web part control ID property is used for this purpose.  
   

  Visibility  
  Visible: Indicates if the web part should be displayed.  
  Hide on subpages: Indicates if the web part should be hidden on sub-pages. If checked, the web part will not be displayed on documents that inherit the web part from a parent document.  
  Show for document types: Contains a list of document types on which the web part should be displayed. If the currently selected document uses the page template containing this web part, but its type is not specified by this property, the web part will be hidden. The document types in the list must be specified by their code names and separated by semicolons (;). If empty, the web part will be displayed on all document types.  
  Display to roles: Contains a list of roles to which the web part should be displayed. This may be used to implement documents with specific functionality for different types of users. The roles in the list must be specified by their code names and separated by semicolons (;). If empty, the web part will be displayed to all users.  
   

  SharePoint  
  SharePoint site URL: Specifies the URL of the SharePoint site that should be used or the direct URL of the requested web service (Eg. Lists.asmx, Imaging.asmx). If only the site URL is entered, then the web service used for data retrieval is automatically determined according to the value of the Mode property.  
  Username: Sets the username for authentication against the web service. If empty, the credentials specified in Site Manager -> Settings -> Integration -> Microsoft SharePoint will be used.  
  Password: Sets the password used for authentication against the web service. If empty, the credentials specified in Site Manager -> Settings -> Integration -> Microsoft SharePoint will be used.  
  List name: Name of the SharePoint list(or picture library) from which the list items/pictures should be loaded. This field is case sensitive!  
  Mode: Determines what kind of data will be loaded by the web part. This also automatically sets the appropriate web service to be used. The selected mode may affect the behaviour of some of the web part's other properties.  
   

  Advanced  
  Row limit: Sets the maximum number of items (data rows) to be retrieved.  
  Query: Can be used to set a query to filter which rows should be loaded or change their order. It uses CAML syntax. A sample query could look like the following: <Query><Where><Eq><FieldRef Name="ID" /><Value Type="Counter">1</Value></Eq></Where></Query> More information can be found at http://msdn.microsoft.com/en-us/library/dd586530.aspx  
  View fields: Directly specifies the names of the SharePoint list fields that should be loaded. If empty all fields will be retrieved. Note: Certain fields will always be retrieved.  
   

  Debug  
  Show raw response: If enabled, the retrieved data will be displayed in raw CAML format. This can be useful for debugging purposes or when searching for the content of specific fields.  
   

  Design  
  Columns: Specifies which of the retrieved fields should be included as columns in the dataset used by the grid (column names must be separated by semicolons). If empty, all fields will be used.  
  Header columns names: Can be used to enter names for columns, which will be displayed in the grid's header. Names must be separated by semicolons.  
  Show header: Indicates if the grid header should be displayed.  
  Tool tip: Sets the tooltip displayed when a user hovers their mouse over the grid.  
  Skin ID: Sets the SkinID of the skin that should be applied to the web part. The skin must be defined in the Default.skin file located in the App_Themes directory under the folder of the stylesheet used by the page.  
   

  No data behaviour  
  Hide if no record found: Indicates if the web part should be hidden when no items to be displayed are retrieved.  
  No record found text: Text that should be displayed if no records are found. This text will not be visible if the Hide if no record found property of the web part is enabled.  
   

  Paging  
  Enable paging: Indicates if the displayed data should be paged.  
  Page size: Determines the maximum number of records displayed per page.  
  Pager style: Allows the selection of the method used for navigation between pages. The options are Previous/Next buttons and page number links.  
   

  Sorting  
  Enable sorting: Indicates if sorting according to individual columns should be allowed in the displayed grid.  
  Sort ascending: Indicates if the default sorting order should be ascending.  
  Default sort field: Sets the name of the field used to sort the records in the grid by default.  
  Set first page after change sorting: Indicates if the first page should be displayed instead of the current page after the sorting of the grid is changed.  
   

  System settings  
  Cache minutes: Sets the number of minutes for which the content of the web part should remain cached before its latest version is reloaded from the database. If left empty, the value entered into the Site Manager -> Settings -> System -> Performance -> Cache content (minutes) setting will be used instead. If set to 0, caching will be disabled for the web part.  
  Cache item name: Sets the name of the cache key used for the content of the web part. If not specified, this name is generated automatically based on the site, document path, Web part control ID and current user. A cache key can be shared between multiple web parts with the same content on different pages in order to avoid keeping redundant data in the memory.  
  Cache dependencies: Contains a list of cache keys on which the partial cache of the web part depends. When the specified cache items change, the partial cache of the web part is deleted. Each line may contain a single item only. If the 'Use default cache dependencies' box is checked, the default dependencies will be used, which include all possible object changes that could affect the specific web part.  
   

  Web part container  
  Web part container: Specifies the name of the container (box) to be displayed around the web part. Only containers defined in Site Manager -> Development -> Web part containers can be selected. The selected container can be edited directly by using the Edit button.  
  Container title: Sets a title for the container. This title is displayed only if the {%ContainerTitle%} macro is used in the code of the container.  
  Container CSS class: CSS class used for the container. Applied only if the {%ContainerCSSClass%} macro is used as the value of the Class attribute in the code of the container.  
  Container custom content: Custom content to be used in the container. Applied only if the {%ContainerCustomContent%} macro is used in the code of the container.  
  Hide container on subpages: Indicates if the web part container should be hidden on sub-pages.  
   

  HTML Envelope  
  Content before: HTML content placed before the web part. Can be used to display a header or add some encapsulating code, such as <div> or <table> elements to achieve the required layout.  
  Content after: HTML content placed after the web part. Can be used to display a footer or close the tags contained in the ContentBefore value, such as </div> or </table> elements.  
   

  AJAX  
  Use update panel: Indicates if an AJAX UpdatePanel container should be used for this web part.  
   

  Time zones  
  Time zone: Specifies the type of time zone used for the content of the web part.  
  Custom time zone: May be used to assign a custom time zone specifically for the content of this web part. If selected, the time zone will be used regardless of current user or website time zone settings.  
   

  Performance  
  Disable view state: Indicates if view state should be disabled for this web part.  
  Disable macros: If checked, macros contained in the values of the web part's properties will no longer be resolved.  
  Partial cache minutes: Sets the number of minutes for which the output HTML code of the web part should remain cached. This process is similar to full-page caching, but only for the code of the web part specifically. If left empty or set to 0, partial caching will be not be used for the web part.  
  Partial cache dependencies: Contains a list of cache keys on which the partial cache of the web part depends. When the specified cache items change, the partial cache of the web part is deleted. Each line may contain a single item only. If the 'Use default cache dependencies' box is checked, the default dependencies will be used, which include all possible object changes that could affect the specific web part.  
   

  Output filter  
  Filter output HTML of web part: If checked, the output code of this web part is processed by the output filters  
  Resolve URLs: If checked, the filter removes the "~" character in relative URLs and replace it with the root URL of the website.  
  Fix attributes: If checked, the filter ensures that all HTML tag attributes are in valid XHTML format.  
  Fix Javascript: If checked, the filter ensures that the type and language attributes are included in all <script> tags.  
  Fix lower case: If checked, the filter ensures that all HTML tags and attributes are generated in lower case.  
  Fix self closing tags: If checked, the filter ensures that HTML tags without end tags are properly closed.  
  Fix tags: If checked, the filter replaces tags that are not XHTML valid with appropriate equivalents (<strong> instead of <b>, <em> instead of <i>).  
  Fix HTML5: If checked, the filter replaces attributes that are obsolete in HTML5 with CSS classes named in format <attribute name>_<attribute value>. The affected attributes are: cellpadding, cellspacing, width, height, border, align, valign  
  Convert TABLE tags to DIV tags: If enabled, the TABLE tags in the output are automatically converted to DIV tags with CSS class corresponding to the tag name (table, tr, td, etc.) Blocks of HTML code can be optionally marked with class="_divs" or class="_nodivs" to allow or disable conversion for that particular block of code.  
   

Help URL: http://devnet.kentico.com/docs/webparts/index.html?SharePointDatagrid_properties.htm