asp.net点击 查看更多 实现无刷新加载的实现代码

<br><script type="text/javascript"> <br>$(function () { <br>function init(count, start) { <br>$.ajax({ <br>type: "GET", <br>dataType: "json", <br>url: "Handler/Handler.ashx", <br>data: { action: "GetMoreNews", count: count, start: start }, <br>beforeSend: function () { $("#divload").show(); $("#more2").hide(); }, <br>complete: function () { $("#divload").hide(); $("#more2").show(); }, <br>success: function (json) { <br>var str = ""; <br>$.each(json, function (index, array) { <br>var str = "<div class='single_item'>" <br>+ "<div class='element_head'>" <br>+ "<div class='author'>" + array['Title'] +"</div>" <br>+ "<div class='date'>" + array['Date'] + "</div>" <br>+ "</div>" <br>+ "<div class='content'>" + array['Contents'] + "</div>" <br>+ "</div>"; <br>$("#more").append(str); <br>}); <br>if (json == "") { <br>$("#more2").html("没有更多内容加载了……"); <br>} <br>} <br>}); <br>} <br>var count = 5; <br>var start = 0; <br>init(count, start); <br>$(".get_more").click(function () { <br>start += 5; <br>init(count, start); <br>}); <br>}); <br></script> <br> <br>解释上面js的大体意思：定义一个init方法，此方法带有两个参数count和start，count意思是每次加载显示评论数，start意思是，每次从数据库中读取的位置，比如0，5,10。 <br>Handler.ashx处理页面的代码如下 <br><span><u></u></span> 代码如下:<pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><br>页面页面的js代码如下， <br><b> <script type="text/javascript"> <br>$(function () { <br>function init(count, start) { <br>$.ajax({ <br>type: "GET", <br>dataType: "json", <br>url: "Handler/Handler.ashx", <br>data: { action: "GetMoreNews", count: count, start: start }, <br>beforeSend: function () { $("#divload").show(); $("#more2").hide(); }, <br>complete: function () { $("#divload").hide(); $("#more2").show(); }, <br>success: function (json) { <br>var str = ""; <br>$.each(json, function (index, array) { <br>var str = "<div class='single_item'>" <br>+ "<div class='element_head'>" <br>+ "<div class='author'>" + array['Title'] +"</div>" <br>+ "<div class='date'>" + array['Date'] + "</div>" <br>+ "</div>" <br>+ "<div class='content'>" + array['Contents'] + "</div>" <br>+ "</div>"; <br>$("#more").append(str); <br>}); <br>if (json == "") { <br>$("#more2").html("没有更多内容加载了……"); <br>} <br>} <br>}); <br>} <br>var count = 5; <br>var start = 0; <br>init(count, start); <br>$(".get_more").click(function () { <br>start += 5; <br>init(count, start); <br>}); <br>}); <br></script></b> <br>解释上面js的大体意思：定义一个init方法，此方法带有两个参数count和start，count意思是每次加载显示评论数，start意思是，每次从数据库中读取的位置，比如0，5,10。 <br>Handler.ashx处理页面的代码如下 <br>[code] <br>case "GetMoreNews": <br>int count = int.Parse(context.Request.QueryString["count"].ToString()); <br>int start = int.Parse(context.Request.QueryString["start"].ToString()); <br>IList<WineNews> morenews = WineNewsManager.WineNewsQueryFromMToN(count,start); <br>Content = JavaScriptConvert.SerializeObject(morenews); <br>break; <br> <br>WineNewsQueryFromMToN代码如下 <br><span><u></u></span> 代码如下:<pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><br>public static IList<WineNews> WineNewsQueryFromMToN(int count,int start) <br>{ <br>using (SqlConnection cn = new SqlConnection(SQLHelp.Conn)) <br>{ <br>cn.Open(); <br>string sql = "SELECT TOP " + count + " f.* FROM tb_WineNews f WHERE Id NOT IN (SELECT TOP " + start + " Id FROM tb_WineNews ORDER BY Id desc) ORDER BY Id desc"; <br>SqlCommand cmd = new SqlCommand(sql, cn); <br>SqlDataReader dr = cmd.ExecuteReader(); <br>IList<WineNews> list = new List<WineNews>(); <br>while (dr.Read()) <br>{ <br>WineNews wineNews = new WineNews(); <br>if (dr["ID"] != DBNull.Value) <br>{ <br>wineNews.ID = (int)dr["ID"]; <br>} <br>if (dr["Title"] != DBNull.Value) <br>{ <br>wineNews.Title = (string)dr["Title"]; <br>} <br>if (dr["Contents"] != DBNull.Value) <br>{ <br>wineNews.Contents = (string)dr["Contents"]; <br>} <br>if (dr["Picture"] != DBNull.Value) <br>{ <br>wineNews.Picture = (string)dr["Picture"]; <br>} <br>if (dr["Date"] != DBNull.Value) <br>{ <br>wineNews.Date = ((DateTime)dr["Date"]).ToString("yyyy-MM-dd HH:mm:ss"); <br>} <br>list.Add(wineNews); <br>} <br>dr.Close(); <br>return list; <br>} <br>} <br> <br>运行效果如下 <br><img src="https://img.gxlcms.com//Uploads-s/new/2019-09-19-201919/20120629235211637.gif" border="0"><br>作者：陈赛</li><li>            </li><li>                                </li></ol></pre></li></ol></pre>