DataGrid for SharePoint

Allow users of any technical level to display and interact with SharePoint List or BCS data sources. Navigate through any SharePoint site, select a source, and work with your data. Scroll, group, sort, and create hierarchical views smoothly without waiting for page refreshes. Also, add, update, and delete data.

How DataGrid for SharePoint Will Help You

Below is a list of features and highlights specific to DataGrid for SharePoint. Visit Studio for SharePoint's Features and Highlights page to learn about more features shared by all ComponentOne Web parts.

  • Display SharePoint Lists, Views, External Lists and More

    Just open the On-Board Designer, point to a data source, select your data, configure the view, and you are finished. Convenient property lists let you set data types, default grouping, column sizes, and more. Gone is the need for SharePoint Designer and difficult code. You don't even need to use the page's edit mode.

  • Print Reports

    Set up your data view, right-click, and print the entire grid, not just what is in view. This makes the DataGrid a great ad-hoc reporting tool.

  • Allow End-Users to Edit and Update Data

    Give your users the ability to edit data, regardless of where it comes from. Adding, removing, and editing records is easy and fluid. There are no post-backs or lengthy page refreshes.

  • View, Sort, Group, and Filter without a Single Refresh

    When viewing a typical SharePoint page, you have to wait for a refresh each time you change the data view. Want to sort a column? Wait for the page to refresh. Want to apply a filter? Wait for the page to refresh. The ComponentOne DataGrid for SharePoint performs these functions instantly without reloading the page. Also, scroll the entire table. Gone is the need to page through large data sets.

  • Create Master-Detail Relationships

    Navigating related database tables and lists is easy with the ComponentOne DataGrid for SharePoint. Use the On-Board Designer to select parent and child tables and related columns, then quickly drill down into the details for any data row.

  • Freeze Columns and Rows

    Make the browsing of large data sets easy by freezing rows and columns. You can set default frozen rows and columns in the On-Board Designer or allow end-users to define their own.

How We Compare

When viewing data with SharePoint's out-of-the box features, you have a few choices in the way that you can configure the display. SharePoint list views are very sterile and inflexible and customization requires code. ComponentOne DataGrid for SharePoint provides a non-technical way to configure views while delivering a more useful feature set.

ComponentOne Web Parts SharePoint
Point-and-click configuration, connection, and design through the On-Board Designer. Connection and configuration can require code, complicated tools, and time consuming processes.
Ad-hoc, drag-and-drop grouping. Can only filter by selecting a data value or connecting an additional Web Part.
Print full grid view (ad-hoc reports). No convenient way to print a data set.
Ad-hoc, drag-and-drop grid layout. Set up grouped views through SharePoint Designer or in a list view.
Smooth, fluid operation: no page refreshes or post backs when you filter, sort, group, or edit the data. Jerky operation: pages must reload whenever you filter, sort, group, or edit the data.
Allow frozen columns and rows. Not available.
Point-and-click master detail views. Creating nested tables would require coding.