ComponentOne DataGrid™ for SharePoint

Easy, Interactive and Full-Featured Grid for SharePoint

Show and edit data from any source without any special setup. Support hierarchical data, filtering, sorting, grouping, and editing without code. Customize columns with formats, display images and hyperlinks. Scroll quickly through large data sets without page refreshes or post-backs. Allow users to personalize their views and see exactly what they want, the way they want. Do all this in minutes, without writing a single line of code.

How DataGrid for SharePoint Will Help You

Show All

Easiest Way to Display Data in SharePoint

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.
Instantly Connect to Virtually Any Data Source

Use the On-Board Designer to point to SharePoint lists (even on other sites), SQL Server, Oracle, and Excel (you don't need MOSS) and select the data you want to display. You don't need SharePoint's BDC, there is no code required, and you don't have to use Excel as a data viewer. You just need the Web Part and permission to access your data.
Allow End-Users to Edit and Update Data

Give your users the ability to edit data, regardless of where it comes from (lists, SQL Server, Oracle, Excel). 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.
Enjoy Complete Control Over the Data View

Set presentation properties (e.g., column widths, data types, headings), toggle visibility, set default groups and filters, and even configure master-detail relationships with just a few clicks. And you can allow your users to customize the grid as well!
Instant Master-Detail Relationships

Navigating related database tables and lists is easy with the ComponentOne DataGrid for SharePoint. Use the On-Board Designer to select tables and related columns, then for any data row you can quickly drill down into the details.
Connect Web Parts for Rich Interaction

Connect ComponentOne WebParts to one another or SharePoint Web Parts to your ComponentOne Web Parts. This level of interactivity will ensure that you are always showing meaningful data.
Coding Optional

The On-Board Designers make creating and configuring ComponentOne Web Parts a simple matter of pointing-and-clicking. But, if you need to go beyond the designer options, feel free to use code to customize the Web Parts even further. Ease of use and extensibility go very well together.
Real ROI

In just a few minutes, insert the DataGrid Web Part on your page, connect to your data, and configure your view. Changing the view is just as easy. You get a grid view that would take developers weeks to code. The DataGrid will pay for itself the first time you use it on a typical project.

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 display data. You can enter data in a SharePoint list, code a view in SharePoint designer, use Excel as a data viewer, or set up connections through the Business Data Catalog (BDC). These methods are labor intensive and feature limited. The ComponentOne DataGrid for SharePoint provides a non-technical way to connect to data sources and 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.
Connect directly to any data source (lists, SQL Server, Oracle, Excel).	Need to set up connections through Excel, SharePoint Designer, or BDC.
Allow users to add, update, and delete data (lists, SQL Server, Oracle, Excel) by setting a property.	Only lists can be edited.
Ad-hoc, drag-and-drop grouping.	Can only filter by selecting a data value or connecting an additional Web Part.
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.