The page code is as follows:
<Asp: listview runat = "server" id = "_ simpletablelistview">
<Layouttemplate>
<Table>
<Thead>
<Tr>
<TH id = "Th1" runat = "server">
ID </Th>
<TH id = "Th1" runat = "server">
Studentid </Th>
<TH id = "th3" runat = "server">
Name </Th>
<TH id = "th4" runat = "server">
Math </Th>
<TH id = "th5" runat = "server">
English </Th>
<TH id = "th6" runat = "server">
Chinese </Th>
</Tr>
</Thead>
<Tbody>
<Asp: placeholder runat = "server" id = "itemplaceholder"/>
</Tbody>
</Table>
</Layouttemplate>
<Itemtemplate>
<Tr>
<TD>
<Asp: Label id = "idlabel" runat = "server" text = '<% # eval ("ID") %>'/>
</TD>
<TD>
<Asp: Label id = "studentidlabel" runat = "server" text = '<% # eval ("studentid") %>'/>
</TD>
<TD>
<Asp: Label id = "namelabel" runat = "server" text = '<% # eval ("name") %>'/>
</TD>
<TD>
<Asp: Label id = "mathlabel" runat = "server" text = '<% # eval ("math") %>'/>
</TD>
<TD>
<Asp: Label id = "englishlabel" runat = "server" text = '<% # eval ("English") %>'/>
</TD>
<TD>
<Asp: Label id = "chineselabel" runat = "server" text = '<% # eval ("Chinese") %>'/>
</TD>
</Tr>
</Itemtemplate>
</ASP: listview>
<Asp: datapager id = "datapager2" runat = "server"
Pagedcontrolid = "_ simpletablelistview" pagesize = "2"
Onprerender = "datapager2_prerender">
<Fields>
<Asp: nextpreviouspagerfield buttontype = "button" showfirstpagebutton = "true"
Showlastpagebutton = "true"/>
</Fields>
</ASP: datapager>
Background code:
Protected void datapager2_prerender (Object sender, eventargs E)
{
Binddata ();
}
Private void binddata ()
{
Using (oledbconnection conn = new oledbconnection (oledbhelper. connectionstring ))
{
String SQL = "select * From studentscore ";
Oledbdataadapter dp = new oledbdataadapter (SQL, Conn );
Datatable dt = new datatable ();
DP. Fill (DT );
_ Simpletablelistview. datasource = DT;
_ Simpletablelistview. databind ();
}
}
Note: to use this method, you do not need to bind data to the listview control in the page_load event of the page,
Otherwise, there will be problems with paging.
2nd methods:
Protected void page_load (Object sender, eventargs E)
{
If (! Ispostback)
{
Binddata ();
}
}
Protected void _ simpletablelistview_pagepropertieschanging (Object sender, pagepropertieschangingeventargs E)
{
Datapager2.setpageproperties (E. startrowindex, E. maximumrows, false );
Binddata ();
}