求gridview结合ajax查询、翻页等例子
如题，越详细、全面越好，谢谢！
[解决办法]
页面上放个UpdatePanel把GridView放里面
然后就查询,翻页吧,无刷新了,就这么简单
[解决办法]
别忘了再放一个scriptmanager
否则UpdatePanel是起不到作用的。
[解决办法]
顶！
[解决办法]
https://msevents.microsoft.com/cui/r.aspx?t=3&c=zh-cn&r=1289718096
看看这个你就会了解了
[解决办法]
up
[解决办法]
既然用了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> <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());
大体如此.
[解决办法]
看了别人的提示，自己动手试一下，这样印象会深一些。
不一定要别人的代码。说不定，在别人的提示下，你一试就试出来了。
这样你不更有成就感嘛
^_^
[解决办法]
一楼正解
[解决办法]
用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>
[解决办法]
楼上正解，up
[解决办法]
ajaxtoolkit工具包吧
[解决办法]
一楼正解........
