頁面頁面的js代碼如下,
復(fù)制代碼 代碼如下:
script type="text/javascript">
$(function () {
function init(count, start) {
$.ajax({
type: "GET",
dataType: "json",
url: "Handler/Handler.ashx",
data: { action: "GetMoreNews", count: count, start: start },
beforeSend: function () { $("#divload").show(); $("#more2").hide(); },
complete: function () { $("#divload").hide(); $("#more2").show(); },
success: function (json) {
var str = "";
$.each(json, function (index, array) {
var str = "div class='single_item'>"
+ "div class='element_head'>"
+ "div class='author'>" + array['Title'] +"/div>"
+ "div class='date'>" + array['Date'] + "/div>"
+ "/div>"
+ "div class='content'>" + array['Contents'] + "/div>"
+ "/div>";
$("#more").append(str);
});
if (json == "") {
$("#more2").html("沒有更多內(nèi)容加載了……");
}
}
});
}
var count = 5;
var start = 0;
init(count, start);
$(".get_more").click(function () {
start += 5;
init(count, start);
});
});
/script>
解釋上面js的大體意思:定義一個(gè)init方法,此方法帶有兩個(gè)參數(shù)count和start,count意思是每次加載顯示評論數(shù),start意思是,每次從數(shù)據(jù)庫中讀取的位置,比如0,5,10。
Handler.ashx處理頁面的代碼如下
復(fù)制代碼 代碼如下:
頁面頁面的js代碼如下,
b> script type="text/javascript">
$(function () {
function init(count, start) {
$.ajax({
type: "GET",
dataType: "json",
url: "Handler/Handler.ashx",
data: { action: "GetMoreNews", count: count, start: start },
beforeSend: function () { $("#divload").show(); $("#more2").hide(); },
complete: function () { $("#divload").hide(); $("#more2").show(); },
success: function (json) {
var str = "";
$.each(json, function (index, array) {
var str = "div class='single_item'>"
+ "div class='element_head'>"
+ "div class='author'>" + array['Title'] +"/div>"
+ "div class='date'>" + array['Date'] + "/div>"
+ "/div>"
+ "div class='content'>" + array['Contents'] + "/div>"
+ "/div>";
$("#more").append(str);
});
if (json == "") {
$("#more2").html("沒有更多內(nèi)容加載了……");
}
}
});
}
var count = 5;
var start = 0;
init(count, start);
$(".get_more").click(function () {
start += 5;
init(count, start);
});
});
/script>/b>
解釋上面js的大體意思:定義一個(gè)init方法,此方法帶有兩個(gè)參數(shù)count和start,count意思是每次加載顯示評論數(shù),start意思是,每次從數(shù)據(jù)庫中讀取的位置,比如0,5,10。
Handler.ashx處理頁面的代碼如下
[code]
case "GetMoreNews":
int count = int.Parse(context.Request.QueryString["count"].ToString());
int start = int.Parse(context.Request.QueryString["start"].ToString());
IListWineNews> morenews = WineNewsManager.WineNewsQueryFromMToN(count,start);
Content = JavaScriptConvert.SerializeObject(morenews);
break;
WineNewsQueryFromMToN代碼如下
復(fù)制代碼 代碼如下:
public static IListWineNews> WineNewsQueryFromMToN(int count,int start)
{
using (SqlConnection cn = new SqlConnection(SQLHelp.Conn))
{
cn.Open();
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";
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader dr = cmd.ExecuteReader();
IListWineNews> list = new ListWineNews>();
while (dr.Read())
{
WineNews wineNews = new WineNews();
if (dr["ID"] != DBNull.Value)
{
wineNews.ID = (int)dr["ID"];
}
if (dr["Title"] != DBNull.Value)
{
wineNews.Title = (string)dr["Title"];
}
if (dr["Contents"] != DBNull.Value)
{
wineNews.Contents = (string)dr["Contents"];
}
if (dr["Picture"] != DBNull.Value)
{
wineNews.Picture = (string)dr["Picture"];
}
if (dr["Date"] != DBNull.Value)
{
wineNews.Date = ((DateTime)dr["Date"]).ToString("yyyy-MM-dd HH:mm:ss");
}
list.Add(wineNews);
}
dr.Close();
return list;
}
}
運(yùn)行效果如下
作者:陳賽
您可能感興趣的文章:- asp.net中MVC借助Iframe實(shí)現(xiàn)無刷新上傳文件實(shí)例
- asp.net使用AJAX實(shí)現(xiàn)無刷新分頁
- asp.net中Timer無刷新定時(shí)器的實(shí)現(xiàn)方法
- asp.net中利用Jquery+Ajax+Json實(shí)現(xiàn)無刷新分頁的實(shí)例代碼
- Asp.Net 無刷新文件上傳并顯示進(jìn)度條的實(shí)現(xiàn)方法及思路
- asp.net+jquery ajax無刷新登錄的實(shí)現(xiàn)方法
- Asp.net 2.0 無刷新圖片上傳 顯示縮略圖 具體實(shí)現(xiàn)
- asp.net jquery無刷新分頁插件(jquery.pagination.js)
- asp.net Ajax之無刷新評論介紹
- asp.net 簡便無刷新文件上傳系統(tǒng)
- asp.net ajax實(shí)現(xiàn)無刷新驗(yàn)證碼
- asp.net 30分鐘掌握無刷新 Repeater
- asp.net下使用jquery 的ajax+WebService+json 實(shí)現(xiàn)無刷新取后臺值的實(shí)現(xiàn)代碼
- Asp.net實(shí)現(xiàn)無刷新調(diào)用后臺實(shí)體類數(shù)據(jù)并以Json格式返回