Friday, July 3, 2009

Paging in Detail View

 <asp:DetailsView ID="DetailsView1" runat="server"
AutoGenerateRows="False"

DataKeyNames="EmployeeID"
DataSourceID="SqlDataSource1" Height="50px"

Width="125px" AllowPaging="true">

<Fields>
<asp:BoundField DataField="EmployeeID"
HeaderText="EmployeeID"

InsertVisible="False" ReadOnly="True"
SortExpression="EmployeeID" />

<asp:BoundField DataField="LastName"
HeaderText="LastName"

SortExpression="LastName" />
<asp:BoundField DataField="FirstName"
HeaderText="FirstName"

SortExpression="FirstName" />
<asp:BoundField DataField="Title" HeaderText="Title"
SortExpression="Title"
/>

<asp:BoundField DataField="TitleOfCourtesy"
HeaderText="TitleOfCourtesy"

SortExpression="TitleOfCourtesy" />
<asp:BoundField DataField="BirthDate"
HeaderText="BirthDate"

SortExpression="BirthDate" />
</Fields>
<PagerSettings Mode="NextPreviousFirstLast"
FirstPageText="[First Page]"
LastPageText="[LastPage]"
PreviousPageText="[PreviousPage]"
NextPageText="[NextPage]" />
</asp:DetailsView>
<br />
<br />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<
%$ ConnectionStrings:NorthwindConnectionString %>"

SelectCommand="SELECT [EmployeeID],
[LastName], [FirstName], [Title],
[TitleOfCourtesy], [BirthDate] FROM [Employees]">

</asp:SqlDataSource>

0 comments:

Post a Comment

plzz give the comment