求gridview结合ajax查询、翻页等例子

Question

如题，越详细、全面越好，谢谢！

Answer 1

页面上放个UpdatePanel把GridView放里面然后就查询,翻页吧,无刷新了,就这么简单

Answer 2

别忘了再放一个scriptmanager
否则UpdatePanel是起不到作用的。

Answer 3

https://msevents.microsoft.com/cui/r.aspx?t=3&c=zh-cn&r=1289718096
看看这个你就会了解了

Answer 4

既然用了ajax就不必再用gridview了.你可以把数据返回到客户端,然后放入table中,或者在cs中生成table返回到一个div里.
我的一点代码希望对你有点帮助:
  if (iPageIndex >= iPageCount)
                    iPageIndex = iPageCount;
                iPageIndex = iPageIndex - 1;
                sbRecord.Append("<Table width=\"100%\" border=0 cellpadding=\"5\" cellspacing=\"1\" bgcolor=\"#97A8C0\"><TR>");
                sbRecord.Append("<TD height=\"24\" bgcolor=\"#576E90\"><div align=\"center\" class=\"STYLE1\"><strong>编号</strong></div></TD>");
                sbRecord.Append("<TD bgcolor=\"#40587C\"><div align=\"center\" class=\"STYLE3\">用户名</div></TD>");
                sbRecord.Append("<TD bgcolor=\"#40587C\" class=\"STYLE3\">客人姓名</TD>");
                sbRecord.Append("<TD bgcolor=\"#40587C\"><div align=\"center\" class=\"STYLE3\">酒店名称</div></TD>");
                sbRecord.Append("<TD bgcolor=\"#40587C\"><div align=\"center\" class=\"STYLE3\">预订时间</div></TD>");
                sbRecord.Append("<TD bgcolor=\"#40587C\"><div align=\"center\" class=\"STYLE3\">入住时间</div></TD>");
                sbRecord.Append("<TD bgcolor=\"#40587C\"><div align=\"center\" class=\"STYLE3\">实际离店时间</div></TD>");
                sbRecord.Append("<TD bgcolor=\"#40587C\"><div align=\"center\" class=\"STYLE3\">入住状态</div></TD>");
                sbRecord.Append("<TD bgcolor=\"#40587C\"><div align=\"center\" class=\"STYLE3\">消费金额</div></TD>");
                sbRecord.Append("<TD bgcolor=\"#40587C\"><div align=\"center\" class=\"STYLE3\">确认码</div></TD>");
                sbRecord.Append("</TR>");
                sbRecord.Append("<TR bgcolor=\"#97A8C0\">");
                sbRecord.Append("<TD height=\"3\" colspan=\"9\"></TD>");
                sbRecord.Append("</TR>");
                if (iRecordCount > 0)
                {
                    _dataAccessLayer.addNewParameter("@tablename", "resvlog", 100);
                    _dataAccessLayer.addNewParameter("@fieldlist", "id,userid,guestfirstname,propertyname,convert(char(10),starttime,020),convert(char(10),deptime,020),convert(char(10),departure,020),totalrevenue,confnum,status,getstatus,guestlastname", 4000);
                    _dataAccessLayer.addNewParameter("@orderfield", "starttime", 100);
                    _dataAccessLayer.addNewParameter("@keyfield", "id", 100);
                    _dataAccessLayer.addNewParameter("@pageindex", iPageIndex);
                    _dataAccessLayer.addNewParameter("@pagesize", 10);
                    _dataAccessLayer.addNewParameter("@strwhere", sbSql.ToString(), 4000);
                    _dataAccessLayer.addNewParameter("@ordertype", 0);
                    DataSet dsTable = new DataSet();
                    dsTable = _dataAccessLayer.RunStoreDataSet("GetPagingRecord");                    string sNo = "";                    if (dsTable != null && dsTable.Tables[0].Rows.Count > 0)
                    {
                        for (int iRows = 0; iRows < dsTable.Tables[0].Rows.Count; iRows++)
                        {
                            if ((iPageIndex * 10 + iRows + 1) < 10)
                            {
                                sNo = "NO.0" + Convert.ToString(iRows + 1);
                            }
                            else
                            {
                                sNo = "NO." + Convert.ToString(iPageIndex * 10 + iRows + 1);
                            }
                            sbRecord.Append(" <TR bgcolor=\"#FFFFFF\">");
                            sbRecord.Append("<td>" + sNo.ToString() + "</td>");
                            sbRecord.Append("<td>" + _hashTable[dsTable.Tables[0].Rows[iRows][1].ToString()].ToString() + "</td>");
                            sbRecord.Append("<td>" + dsTable.Tables[0].Rows[iRows][2].ToString() +' '+dsTable.Tables[0].Rows[iRows][11].ToString()+"</td>");
                            sbRecord.Append("<td>" + dsTable.Tables[0].Rows[iRows][3].ToString() + "</td>");
                            sbRecord.Append("<td>" + dsTable.Tables[0].Rows[iRows][4].ToString() + "</td>");
                            sbRecord.Append("<td>" + dsTable.Tables[0].Rows[iRows][5].ToString() + "</td>");
                            sbRecord.Append("<td>" + dsTable.Tables[0].Rows[iRows][6].ToString() + "</td>");
                            sbRecord.Append("<td>" + getStates(Convert.ToInt32(dsTable.Tables[0].Rows[iRows][10].ToString())) + "</td>");
                            sbRecord.Append("<td>" + dsTable.Tables[0].Rows[iRows][7].ToString() + "</td>");
                            sbRecord.Append("<td><div align=\"center\"><a href='resvview.aspx?LogID=" + dsTable.Tables[0].Rows[iRows][0].ToString() + " 'target='_blank'>");
                            if (dsTable.Tables[0].Rows[iRows][9].ToString() == "New")
                            {
                                sbRecord.Append("<font color='#006600'/>");
                            }
                            else
                                if (dsTable.Tables[0].Rows[iRows][9].ToString() == "mod")
                                {
                                    sbRecord.Append("<font color='#FF6600'/>");
                                }
                                else
                                    if (dsTable.Tables[0].Rows[iRows][9].ToString() == "cxl")
                                    {
                                        sbRecord.Append("<font color='#999999'/>");
                                    }
                            sbRecord.Append(dsTable.Tables[0].Rows[iRows][8].ToString() + "</a></div></td>");
                            sbRecord.Append("</TR>");
                            //  iTotalrevenue += Convert.ToInt32(dsTable.Tables[0].Rows[iRows][7].ToString());
                        }
                        double dTotalrevenue = Convert.ToDouble(_dataAccessLayer.RunSqlGetID("select sum(totalrevenue) from resvlog  where " + sbSql.ToString()));
                        //  sbRecord.Append("<tr ><td bgcolor=\"#ffffff\" align=right colspan=9>消费金额总计:" + dTotalrevenue.ToString() + "<br>当前消费金额总计:" + iTotalrevenue.ToString() + "</td></tr>");                        sbRecord.Append("<tr><td colspan=9 align=right>");
                        sbRecord.Append("<table>");
                        sbRecord.Append("<tr  id='trid' align=right><td align='right' onclick='event.cancelBubble=true;'  colspan=10>共<input  type='text' style='width: 25px;' id='PageCount' value=" + iPageCount.ToString() + ">页<input type='text' style='width: 25px;' value='" + iRecordCount.ToString() + "'>条信息 转到第<input type='Text' onkeypress='return getNumber(event)' style='width: 25px;' id='PageIndex' value='" + Convert.ToString(iPageIndex + 1) + "'/>页<img  src=\"Images/serc1.jpg\" onclick=SearchLucre('search')>");
                        iPageIndex++;
                        if (iPageCount == 1)
                        {
                            sbRecord.Append("<a href='#'   style='cursor: text'  runat=server><font color='lightgrey'/>首页</a><a href='#'  style='cursor: text'  runat=server><font color='lightgrey'/>上一页</a>");                            sbRecord.Append("<a href='#' style='cursor: text'  runat=server><font color='lightgrey'/>下一页</a>&nbsp;&nbsp;<a href='#'  id='tdLast' style='cursor: text'  runat=server><font color='lightgrey'/>末页</a></td></tr>");
                        }
                        else
                        {
.......
 sbRecord.Append("</Table>");
                sbRecord.Append("|");
                sbRecord.Append(sbSql.ToString());大体如此.

Answer 5

用asp.net ajax
很容易就实现
GridView和平常一样用法，加上updatepanel就行
<form id="form1" runat="server">
        <asp:ScriptManager ID="ScriptManager1" runat="server" />
        <asp:UpdatePanel ID="UpdatePanel1" runat="server">
        <ContentTemplate>
            <asp:GridView ID="GridView1" runat="server" OnPageIndexChanged="GridView1_PageIndexChanged">
            </asp:GridView>
        </ContentTemplate>
        </asp:UpdatePanel>
        <div>
        </div>
    </form>

Answer 6

请问一下，我在代码视图中不能直接添加 asp:ScriptManager 和 asp:UpdatePanel ，请问是不是要添加什么引用或命名空间？

Answer 7

问一下，asp:ScriptManager 和asp:UpdatePanel 在哪里？是要下个什么安装吗

Answer 8

问一下，asp:ScriptManager 和asp:UpdatePanel 在哪里？是要下个什么安装吗
==============================================================================
同问！
有没有人告诉一下啊
LZ跑了吗?

Answer 9

去官网下载AjaxControlToolkit.Binary.NET35.zip ，再在vs2008添加引用即可