jQuery结合AJAX之在页面滚动时从服务器加载数据

2020-05-23 06:09:33易采站长站整理

        SqlDataAdapter adp = new SqlDataAdapter(command);
int retVal = adp.Fill(ds);
 
        string resp = string.Empty;
for (int i = 1; i <= ds.Tables[0].Rows.Count; i++)
        {
            string strComment = string.Empty;
if (ds.Tables != null)
            {
if (ds.Tables[0] != null)
                {
if (ds.Tables[0].Rows.Count > 0)
                    {
if (ds.Tables[0].Rows.Count >= i – 1)
                        {
if (ds.Tables[0].Rows[i – 1][0] != DBNull.Value)
                            {
                                strComment = ds.Tables[0].Rows[i – 1][0].ToString();
                            }
                        }
                    }
                }
            }
            resp += “<p><span>” + counter++ + “</span> ” + strComment + “</p>”;
        }
return resp;
    }
客户端方法:在客户端,我使用了document.ready方法,并且把div的scroll事件绑定到了该方法上。我使用了两个div元素,mainDiv和wrapperDiv,并且给mainDiv注册了scroll事件,把动态数据插入到wrapperDiv中。


$(document).ready(
function()
{
$contentLoadTriggered = false;
$("#mainDiv").scroll(
function()
{
if($("#mainDiv").scrollTop() >= ($("#wrapperDiv").height() -
$("#mainDiv").height()) &&
$contentLoadTriggered == false)
$contentLoadTriggered == false)
{
$contentLoadTriggered = true;