Listview datapager Asp.net is too powerful

 

Code

 
<asp:ListView ID="ListView1" runat="server" DataSourceID="SqlDataSource1">
<LayoutTemplate>
<table border="1">
<thead>
<tr>
<th>
                                SvrNum
</th>
<th>
                                Marks
</th>
<th>
                                Release Date
</th>
</tr>
</thead>
<tbody>
<asp:PlaceHolder runat="server" ID="itemPlaceholder"  />
</tbody>
</table>

<div>
<asp:DataPager ID="DataPager1" runat="server" PageSize="1" QueryStringField="page" >
<Fields>
<asp:NumericPagerField />
</Fields>
</asp:DataPager>
</div>

</LayoutTemplate>
<ItemTemplate>
<tr>
<td>
<%# Eval("SvrNum")%>
</td>
<td>
<%# Eval("Marks")%>
</td>
<td>
&nbsp;
</td>
</tr>
</ItemTemplate>            
</asp:ListView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConflictDetection="CompareAllValues" 
            ConnectionString="<%$ ConnectionStrings:testConnectionString %>" 
            DeleteCommand="DELETE FROM [Log_Member_Marks] WHERE [ID] = @original_ID AND [SvrNum] = @original_SvrNum AND [Marks] = @original_Marks" 
            InsertCommand="INSERT INTO [Log_Member_Marks] ([SvrNum], [Marks]) VALUES (@SvrNum, @Marks)" 
            OldValuesParameterFormatString="original_{0}" 
            SelectCommand="SELECT * FROM [Log_Member_Marks]" 
            UpdateCommand="UPDATE [Log_Member_Marks] SET [SvrNum] = @SvrNum, [Marks] = @Marks WHERE [ID] = @original_ID AND [SvrNum] = @original_SvrNum AND [Marks] = @original_Marks">
<DeleteParameters>
<asp:Parameter Name="original_ID" Type="Int64" />
<asp:Parameter Name="original_SvrNum" Type="Int64" />
<asp:Parameter Name="original_Marks" Type="Double" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="SvrNum" Type="Int64" />
<asp:Parameter Name="Marks" Type="Double" />
<asp:Parameter Name="original_ID" Type="Int64" />
<asp:Parameter Name="original_SvrNum" Type="Int64" />
<asp:Parameter Name="original_Marks" Type="Double" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="SvrNum" Type="Int64" />
<asp:Parameter Name="Marks" Type="Double" />
</InsertParameters>
</asp:SqlDataSource>

 

 

<Asp: listview id = "_ grouplistview" runat = "server"
Datakeynames = "movie_id" performanceid = "_ moviesdatasource"
Groupitemcount = "4">
<Grouptemplate>
<Tr>
<Asp: placeholder runat = "server" id = "itemplaceholder"/>
</Tr>
</Grouptemplate>
<Layouttemplate>
<Table>
<Asp: placeholder id = "groupplaceholder" runat = "server"/>
</Table>
</Layouttemplate>
<Itemtemplate>
<TD>
Movie_id:
<Asp: Label id = "_ movie_idlabel" runat = "server"
TEXT = '<% # eval ("movie_id") %>'/> <br/>
Title:
<Asp: Label id = "_ titlelabel" runat = "server"
TEXT = '<% # eval ("title") %>'/> <br/>
Release_date:
<Asp: Label id = "_ release_datelabel" runat = "server"
TEXT = '<% # eval ("release_date", "{0: d}") %>'/> <br/>
<Br/>
</TD>
</Itemtemplate>
</ASP: listview>