DataFormWebPart Часть 1: Отображаем данные из БД
DataFormWebPart – ????????????? ??????? ?????????? SharePoint ??????????????? ??? ??????????? ????????? ??????. DataFormWebPart ????? ???????? ? ??????? ??????????? ??????, ?????? ???:
· SharePoint Lists
· SharePoint Libraries
· Tables, Views ? stored proc (?????? ?? ?????? ?? Microsoft SQL Server)
· XML ??????
· Web services
DataFormWebPart ???????????? paging, ???????????, ??????????, ??????????, ????? ?????????????? ? ????????. ? ??? ??? ??? ??????-???? ????????? ???????????? ????. ??????, ? ?????????, ?? ????????? paging, ?????????? ? ??????????? ???????? ? ?????????? ???? ??????, ? ?? ?????? ??????????? ??? ??????.
?????????? DataFormWebPart ??? ??????????? ??????? ?? Microsoft SQL Server.
? ???? ??????? ?? ????????? ???????? ?? ???????? SharePoint ? ??????????, ????????????, ??????????? ? ???????????? ?????????????? ? ????????.
???? ??????:
1) ????????? SharePoint Designer.
2) ? ???? File-> OpenSite ????????? ??? ????
3) ??????? . aspx ???????? (???? ? ???? File->New..) ?????????? ??????????:
<%@ Page Language="C#" MasterPageFile="~masterurl/default.master" inherits="Microsoft.SharePoint.WebPartPages.WebPartPage, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" meta:progid="SharePoint.WebPartPage.Document" meta:webpartpageexpansion="full" %>
<%@ Register tagprefix="WebPartPages" namespace="Microsoft.SharePoint.WebPartPages" assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Register tagprefix="SharePoint" namespace="Microsoft.SharePoint.WebControls" assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<asp:Content ContentPlaceHolderID="PlaceHolderMain" runat=server>
<h1>Test WebPart!</h1>
<p> </p>
</asp:Content>
4) ????????? Data Source Library. ???? ??? ???????, ?? ? ??????? ???? SharePoint Designer ???????? Task Panes->Data Source Library
????? ???? ????? ?????? ????????? ?????? Data Source Library
5) ???????? ?? Connect to a DataBase. ? ??????????? ?????????? ???? ?????? ??? ??????? ???? ?????? ? ?????\?????? ??? ???????????.
????? ???????? ???????, ?? ??????? ?? ????? ????? ??????. ? ???????? Finish. ????? ?????? ????? ?? ?????? ?? ??????, ?? ? ?? stored procedures (???????? ?????? radio button)
6) ? ?????? DatabaseConnections ????????? ???? ??????????.
???? ??? ???? ??????? ????????? ?????? ? ???????? ?????????, ?? ???? ??????? ??? Linked Source, ????? ?? CreatenewLinkedSource.
? ??????????? ???? ?????? ?????????? ???????? Show Data.
????????? ???????? Data Source Details. ???????? ????????? Ctrl ??????????? ??? ??? ?????? ? ??????? ??????? ? ????????????? ? ?? ????? ????????, ??? ?? ????? ?? ????????.
???????? ???? ???????? ? ???????? ??? ? ?????? ??????? ?????????. ?????????? ???? Common Data View Tasks. ? ?????? ????? ???????? ????????, ??????????, ??????????? ? ?????????????? ? ?????????.
??? ?? ????? ??????? ???????, ??????? ????? ??????????, ???? ? ???? ?????? ?????? ?? ???????.
???????? ?? Paging. ? ??????????? ?????????? ???? ???? ?? ?????? ???????? ? ?????? ?????? ??? ???????.
? ??????? ??????? ??? ????? ???????. ??? ????????? ???? Html views – ??? ???? ??? ?????????? ?????????
????? ???????, ????? ?? ?? ???????????? ???????????? ????? ? ???? ??, ?? ?? ??????? ??????? ?? ???????? ??? ?????????? ????????. ?? ????? ?????????? ?? 10.
???????? OK. ??????????? ? ????????? ???? ???????? ? ????????.
???????? ????? ??? ???????? ? ??? ?????? ???? ??????????
??? ??? DataFormWebPart: