Dataview webpart in SharePoint 2010

This SharePoint tutorial explains, Dataview webpart in SharePoint 2010 and also various out of box web parts in SharePoint 2010.

Dataview webpart in SharePoint 2010

A Data View web part is a great way to display data with filtering, grouping, and user desired formatting. It was the most useful webpart in SharePoint 2007 and now has been improved to a great extend in SharePoint 2010. In SharePoint 2010 you now have a XSLT Listview webpart and a Dataview webpart (Old one).

XSLT Listview webpart – XSLT Listview webpart is a ListView whose XSLT can be modified in SharePoint designer. With this you now have some advanced formatting options and can also use all the filters, sorting grouping, etc features that a Dataview web part had in SharePoint 2007.

DataView Webpart – Even after all the great features that the XSLT Listview webpart has offered, I would still prefer to work with the old Dataview web part’s XSLT if I have to. The OLD data view webpart is still available and can be used in the same manner as we used in SharePoint 2007.

To add a Dataview webpart onto a page follow the steps below.

  • Open your SharePoint Page and in Site Actions select -> Edit in SharePoint Designer.
  • Now select a zone on teh Page where you want to add your Dataview weboart.
  • Next, click on Insert tab -> click on Data View.
  • In the drop-down of Data view menu click on “Empty Data view”. This will now insert an Empty Data view in your selected zone.
  • Next click on “click here to select datasource” to select the datasource or list.
  • Select the list\library you want to display the data from.
  • Next drag and drop the columns in the dataview webpart from the right hand column list (for the list\library you selected). You now have the Dataview webpart on your page. You can now use the formatting options available on your ribbon or can modify the XSLT either in SharePoint Designer or on the page itself by editing the webpart properties in the Browser.

Create data view web part using SharePoint 2010 designer

In this SharePoint designer tutorial, we will discuss how to create a data view web part to a SharePoint page using SharePoint designer 2010.

Follow below steps to create data view web part using SharePoint designer:

1. Open your site in SharePoint designer.

2. Click on Edit homepage or you can choose your own location where you want to add the web part.

3. Now from the ribbon, expand the data view web part and choose empty data view web part.

create data view web part sharepoint 2013
create data view web part sharepoint 2013

4. Now select data view web part and click on “click here to add data source” as shown in the fig below.

create data view web part sharepoint 2010
create data view web part sharepoint 2010

5. From the dialog box choose the list/library from where you want to retrieve the data.

6. Now your list with columns will appear at right side.

7. Now choose the columns you want to add at a time and expand the above label and choose as “multiple view”. You can hold the Ctrl key to select / deselect columns.

8. Now your selected columns will be added into the data view web part.

9. Also if you want to do some filter or sorting then you can click on the data source and you can set the filter in the “Data Source Properties” dialog box.

data view web part sharepoint 2010
data view web part sharepoint 2010

10. Click on save, now you will able to see your web part on the server.

SharePoint 2010 Out of Box Web Parts

SharePoint Server 2010 out-of-the-box Web parts, organized by categories. Not all of these Web parts are available to every site. Also note that lists or libraries created on the site will add new options to the “Lists and Libraries” category (hence the name).

List and Libraries:

  • Announcements: Use this list to track upcoming events, status updates or other team news.
  • Calendar: Use the Calendar list to keep informed of upcoming meetings, deadlines, and other important events.
  • Links: Use the Links list for links to Web pages that your team members will find interesting or useful.
  • Shared Documents: Share a document with the team by adding it to this document library.
  • Site Assets: Use this library to store files which are included on pages within this site, such as images on Wiki pages.
  • Site Pages: Use this library to create and store pages on this site.
  • Tasks: Use the Tasks list to keep track of work that you or your team needs to complete.
  • Team Discussions: Use the Team Discussion list to hold newsgroup-style discussions on topics relevant to your team.

Business Data:

  • Business Data Actions: Displays a list of actions from Business Data Connectivity.
  • Business Data Connectivity Filter: Filters the contents of Web Parts using a list of values from the Business Data Connectivity.
  • Business Data Item: Displays one item from a data source in Business Data Connectivity.
  • Business Data Item Builder: Creates a Business Data item from parameters in the query string and provides it to other Web Parts.
  • Business Data List: Displays a list of items from a data source in Business Data Connectivity.
  • Business Data Related List: Displays a list of items related to one or more parent items from a data source in Business Data Connectivity.
  • Chart Web Part: Helps you to visualize your data on SharePoint sites and portals.
  • Excel Web Access: Use the Excel Web Access Web Part to interact with an Excel workbook as a Web page.
  • Indicator Details: Displays the details of a single Status Indicator. Status Indicators display an important measure for an organization and may be obtained from other data sources including SharePoint lists, Excel workbooks, and SQL Server 2005 Analysis Services KPIs.
  • Status Lists: Shows a list of Status Indicators. Status Indicators display important measures for your organization, and show how your organization is performing with respect to your goals.
  • Visio Web Access: Enables viewing and refreshing of Visio Web Drawings.

Content Rollup:

  • Categories: Displays categories from the Site Directory.
  • Content Query: Displays a dynamic view of content from your site. Relevant Documents: Displays documents that are relevant to the current user.
  • RSS Viewer: Displays an RSS feed.
  • Site Aggregator: Displays sites of your choice.
  • Sites In Category: Displays sites from the Site Directory within a specific category.
  • Summary Links: Allows authors to create links that can be grouped and styled.
  • Table Of Contents: Displays the navigation hierarchy of your site.
  • Web Analytics web Part: Displays the most viewed content, most frequent search queries from a site, or most frequent search queries from a search center.
  • WSRP Viewer: Displays portlets from web sites using WSRP 1.1.
  • XML Viewer: Transforms XML data using XSL and shows the results.

Document Sets:

  • Document Set Contents: Displays the contents of the Document Set.
  • Document Set Properties: Displays the properties of the Document Set.
  • Filters Choice Filter: Filters the contents of Web Parts using a list of values entered by the page author.
  • Current User Filter: Filters the contents of Web Parts by using properties of the current user.
  • Date Filter: Filter the contents of Web Parts by allowing users to enter or pick a date.
  • Filter Actions: Use the Filter Actions Web Part when you have two or more filter Web Parts on one Web Part Page, and you want to synchronize the display of the filter results.
  • Page Field Filter: Filters the contents of Web Parts using information about the current page.
  • Query String (URL) Filter: Filters the contents of Web Parts using values passed via the query string.
  • SharePoint List Filter: Filters the contents of Web Parts by using a list of values.
  • SQL Server Analysis Services Filter: Filters the contents of Web Parts using a list of values from SQL Server Analysis Services cubes.
  • Text Filter: Filters the contents of Web Parts by allowing users to enter a text value. Forms
  • HTML Form Web Part: Connects simple form controls to other Web Parts.
  • InfoPath Form Web Part: Use this Web Part to display an InfoPath browser-enabled form.
  • Media and Content Content Editor: Allows authors to enter rich text content.
  • Image Viewer: Displays a specified image.
  • Media Web Part: Use to embed media clips (video and audio) in a web page.
  • Page Viewer: Displays another Web page on this Web page. The other Web page is presented in an IFrame.
  • Picture Library Slideshow Web Part: Use to display a slideshow of images and photos from a picture library.
  • Silverlight Web part: A web part to display a Silverlight application.

Outlook Web App

  • My Calendar: Displays your calendar using Outlook Web Access for Microsoft Exchange Server 2003 or later.
  • My Contacts: Displays your contacts using Outlook Web Access for Microsoft Exchange Server 2003 or later.
  • My Inbox: Displays your inbox using Outlook Web Access for Microsoft Exchange Server 2003 or later.
  • My Mail Folder: Displays your mail folder using Outlook Web Access for Microsoft Exchange Server 2000.
  • My Tasks: Displays your tasks using Outlook Web Access for Microsoft Exchange Server 2003 or later.
  • PerformancePoint PerformancePoint Filter: This web part displays PerformancePoint filters. Filters may be linked to other web parts to provide an interactive dashboard experience. Filter types include lists and trees based on a variety of data sources.
  • PerformancePoint Report: This web part displays PerformancePoint reports. Reports may be linked to other web parts to create an interactive dashboard experience. Report types include: Analytic charts & grids, Strategy Maps, Excel Services, Reporting Services, Predictive Trend charts, and web pages.
  • PerformancePoint Scorecard: This web part displays a PerformancePoint scorecard. Scorecards may be linked to other web parts, such as filters and reports, to create an interactive dashboard experience.
  • PerformancePoint Stack Selector: This web part displays a PerformancePoint Stack Selector. All PerformancePoint web parts, such as filters and reports, contained in the same zone will be automatically stacked and selectable using this web part.
  • Search Advanced Search Box: Displays parameterized search options based on properties and combinations of words.
  • Dual Chinese Search: Used to search Dual Chinese document and items at the same time.
  • Federated Results: Displays search results from a configured location.
  • People Refinement Panel: This webpart helps the users to refine people search results.
  • People Search Box: Presents a search box that allows users to search for people.
  • People Search Core Results: Displays the people search results and the properties associated with them.
  • Refinement Panel: This webpart helps the users to refine search results.
  • Related Queries: This webpart displays related queries to a user query.
  • Search Action Link: Displays the search action links on the search results page.
  • Search Best Bet: Displays high-confidence results on a search results page.
  • Search Box: Displays a search box that allows users to search for information.
  • Search Core Results: Displays the search results and the properties associated with them.
  • Search Paging: Display links for navigating pages containing search results.
  • Search Statistics: Displays the search statistics such as the number of results shown on the current page, total number of results and time taken to perform the search.
  • Search Summary: Displays suggestions for current search query. Search Visual Best Bet: Displays Visual Best Bet.
  • Top Federated Results: Displays the Top Federated result from the configured location.
  • Social Collaboration Contact Details: Displays details about a contact for this page or site.
  • Note Board: Enable users to leave short, publicly-viewable notes about this page.
  • Organization Browser: This Web Part displays each person in the reporting chain in an interactive view optimized for browsing organization charts.
  • Site Users: Use the Site Users Web Part to see a list of the site users and their online status.
  • Tag Cloud: Displays the most popular subjects being tagged inside your organization.
  • User Tasks: Displays tasks that are assigned to the current user.
  • What’s New: This Web part shows new information from specified lists and libraries.
  • Whereabouts: Use to display Whereabouts information.

You may like following SharePoint web part tutorials:

This SharePoint tutorial, we learned various out of box web parts in SharePoint 2010, also we learned Dataview webpart in SharePoint 2010.

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

Get update on Webinars, video tutorials, training courses etc.

>