The Repeater and the DataList control can be quickly displayed on the .aspx page, but they have no paging feature; although the DataGrid control has paging features, but it is too poor board, the flexibility is too bad. Many articles are discussing the problem of Repeater, DataList's paging feature. Here we use PageDataSource Class in Repeater Page: PageDataSource is a class package in DataGrid, and DataGrid is used to implement paging function; we can also use This class is paging in DataList, Repeater, and everyone can solve it as long as you look at the example problem below.
<% @ Import namespace = "system.data"%> <% @ import namespace = "system.data.sqlclient"%>
default </ title> <meta http-equiv = "Content -Type "content =" text / html; charset = gb2312 "> <script language =" C # "runat =" server "> public void Page_Load (Object src, EventArgs e) {SqlConnection cnn = new SqlConnection (" server = zzl; UID = SA; PWD = 970480; data = zzl "); // Connect the database SqlDataAdapter myCommand = new SqldataAdapter (" Select * from start1 ", cn); // data operation, and table start1 and its data you have DataSet in SQL Serrable DS = new dataset (); mycommand.fill (ds); // instance DataSet object is DS, and populates data to DS</p>
<p>PagedDataSource PP = New PagedDataSource (); // Take the class instance of the paging function PP.DataSource = DS.TABLES [0] .defaultView; // Give the data PPPP.AllowPaging = true; // Allow P page PP.PageSize = 6; // Set the number of INT CPAGEs per page; // This integer is used to analyze the number of IF (Request.QueryString ["]! = Null) // This judgment statement is to CPAGE ELSECPAGE = 1; pp.currentpageIndex = CPAGE-1; // PP object, because the reference value starts from 0, CPAGE From 1, it is necessary to minimize 1IF (! Pp.isfirstpage) // Request.currentexecutionFilePath for the file name of the current program, can also write directly to pre.navigateURL = Request.currentexecutionFilePath "Page =" Convert.TOString (CPAGE- 1);</p></div><div class="text-center mt-3 text-grey">
转载请注明原文地址:https://www.9cbs.com/read-22935.html</div><div class="plugin d-flex justify-content-center mt-3"></div><hr><div class="row"><div class="col-lg-12 text-muted mt-2"><i class="icon-tags mr-2"></i><span class="badge border border-secondary mr-2"><h2 class="h6 mb-0 small"><a class="text-secondary" href="tag-2.html">9cbs</a></h2></span></div></div></div></div><div class="card card-postlist border-white shadow"><div class="card-body"><div class="card-title"><div class="d-flex justify-content-between"><div><b>New Post</b>(<span class="posts">0</span>)
</div><div></div></div></div><ul class="postlist list-unstyled">
</ul></div></div><div class="d-none threadlist"><input type="checkbox" name="modtid" value="22935" checked /></div></div></div></div></div><footer class="text-muted small bg-dark py-4 mt-3" id="footer"><div class="container"><div class="row"><div class="col">CopyRight © 2020 All Rights Reserved
</div><div class="col text-right">Processed:
<b>0.045</b>, SQL:
<b>9</b></div></div></div></footer><script src="./lang/en-us/lang.js?2.2.0"></script><script src="view/js/jquery.min.js?2.2.0"></script><script src="view/js/popper.min.js?2.2.0"></script><script src="view/js/bootstrap.min.js?2.2.0"></script><script src="view/js/xiuno.js?2.2.0"></script><script src="view/js/bootstrap-plugin.js?2.2.0"></script><script src="view/js/async.min.js?2.2.0"></script><script src="view/js/form.js?2.2.0"></script><script>
var debug = DEBUG = 0;
var url_rewrite_on = 1;
var url_path = './';
var forumarr = {"1":"Tech"};
var fid = 1;
var uid = 0;
var gid = 0;
xn.options.water_image_url = 'view/img/water-small.png';
</script><script src="view/js/wellcms.js?2.2.0"></script><a class="scroll-to-top rounded" href="javascript:void(0);"><i class="icon-angle-up"></i></a><a class="scroll-to-bottom rounded" href="javascript:void(0);" style="display: inline;"><i class="icon-angle-down"></i></a></body></html><script>
var forum_url = 'list-1.html';
var safe_token = '8WCEKR1lkqM2NY92W7MFRbzyf6AL32DUiQI9KZVp5zbTSZWtD5t3qaMVF3nBAdY5ttja3mswn5xsGspSRN8vtQ_3D_3D';
var body = $('body');
body.on('submit', '#form', function() {
var jthis = $(this);
var jsubmit = jthis.find('#submit');
jthis.reset();
jsubmit.button('loading');
var postdata = jthis.serializeObject();
$.xpost(jthis.attr('action'), postdata, function(code, message) {
if(code == 0) {
location.reload();
} else {
$.alert(message);
jsubmit.button('reset');
}
});
return false;
});
function resize_image() {
var jmessagelist = $('div.message');
var first_width = jmessagelist.width();
jmessagelist.each(function() {
var jdiv = $(this);
var maxwidth = jdiv.attr('isfirst') ? first_width : jdiv.width();
var jmessage_width = Math.min(jdiv.width(), maxwidth);
jdiv.find('img, embed, iframe, video').each(function() {
var jimg = $(this);
var img_width = this.org_width;
var img_height = this.org_height;
if(!img_width) {
var img_width = jimg.attr('width');
var img_height = jimg.attr('height');
this.org_width = img_width;
this.org_height = img_height;
}
if(img_width > jmessage_width) {
if(this.tagName == 'IMG') {
jimg.width(jmessage_width);
jimg.css('height', 'auto');
jimg.css('cursor', 'pointer');
jimg.on('click', function() {
});
} else {
jimg.width(jmessage_width);
var height = (img_height / img_width) * jimg.width();
jimg.height(height);
}
}
});
});
}
function resize_table() {
$('div.message').each(function() {
var jdiv = $(this);
jdiv.find('table').addClass('table').wrap('<div class="table-responsive"></div>');
});
}
$(function() {
resize_image();
resize_table();
$(window).on('resize', resize_image);
});
var jmessage = $('#message');
jmessage.on('focus', function() {if(jmessage.t) { clearTimeout(jmessage.t); jmessage.t = null; } jmessage.css('height', '6rem'); });
jmessage.on('blur', function() {jmessage.t = setTimeout(function() { jmessage.css('height', '2.5rem');}, 1000); });
$('#nav li[data-active="fid-1"]').addClass('active');
</script>
