Asp.net网格视图在后台填充大块数据 [英] Asp.net Grid view Fill Bulk Data in background

问题描述

<大> <大> <大> <大> <大> <大> <大> <大> <大> <小> <小> <小> <小> <小> <小> <小> W e具有将大数据绑定到网格并将数据源(如Datatable)存储在缓存中的功能.我希望当我单击按钮时，它仅填充网格中的前100条记录，而重置"则填充在背景中.
实际上，当我一次填满整个记录时，它会挂在屏幕上并显示白色背景.我不想根据客户端在网格视图中使用分页.
因此，可以通过任何方式在背景中填充网格视图，以便在第一次填充100个Recod时自动在背景填充记录中

We Have a Bulk Data bind To Grid and The Datasource Like Datatable Store in Cache. I Want that When i Click The Button It Fill only Top 100 Record in Grid and Reset are Fill in Background.
Actaully when i Fill Whole Record in one time then it hange the screen and display white Background. i am not want to use paging in grid view according to client.
So it thier any way for fill grid view in Background So that in first time it fill 100 recods an in backgroud fill record automatically

推荐答案

您无法执行此操作，因为您正在使用ASP.NET GridView，并且除非绑定了所有数据，否则gridview不会生成要发送给客户端的HTML来显示.

您可以使用默认的分页支持
http://www.dotnetspider.com/resources/1249-grid-view-paging- sorting.aspx [ ^ ]

谢谢，
Hemant

you Cannot do that because you are working with ASP.NET GridView and until unless all data is binded the gridview won''t generate its HTML to be sent to client to show.

you can use the default paging support
http://www.dotnetspider.com/resources/1249-grid-view-paging-sorting.aspx[^]

Thanks,
Hemant

我们可以按照以下方式进行操作
公共无效的bindgrid()
{
SqlDataAdapter da =新的SqlDataAdapter(&从emp1选择* *"，cn);
DataTable dt = new DataTable();
da.Fill(dt);

GridView2.DataSource = dt;
GridView2.DataBind();
Session ["dtEmp"] = dt;
}

受保护的无效btnNxt_Click(对象发送者，EventArgs ev)
{
DataTable dtEmp =(DataTable)Session [& quot; dtEmp& quot;]];

DataView dvEmp =新的DataView(dtEmp);
int currentPage = Convert.ToInt32(ViewState [& quot; currentPage& quot;]])+ 99;
dvEmp.RowFilter =& quot; empNo& gt; & quot; + currentPage;

GridView2.DataSource = dvEmp;
GridView2.DataBind();

ViewState ["currentPage"] = currentPage +1;


}
在页面加载中放置
ViewState ["currentPage"] = 1;

ya we can do following way
public void bindgrid()
{
SqlDataAdapter da = new SqlDataAdapter(&quot;select * from emp1&quot;, cn);
DataTable dt = new DataTable();
da.Fill(dt);

GridView2.DataSource = dt;
GridView2.DataBind();
Session["dtEmp"] = dt;
}

protected void btnNxt_Click(object sender, EventArgs ev)
{
DataTable dtEmp = (DataTable)Session[&quot;dtEmp&quot;];

DataView dvEmp = new DataView(dtEmp);
int currentPage = Convert.ToInt32(ViewState[&quot;currentPage&quot;]) + 99;
dvEmp.RowFilter = &quot;empNo &gt; &quot; + currentPage;

GridView2.DataSource = dvEmp;
GridView2.DataBind();

ViewState["currentPage"] = currentPage + 1;


}
in page load put
ViewState["currentPage"] = 1;

这篇关于Asp.net网格视图在后台填充大块数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！