Gridview Paging and row count

Question

hi all,
In page load i bound a gridview from this
private void bindTransaction(string code)
{
var transinfo = from transaction in manager.BenTransactions select transaction;
transactiongrid.DataSource = transinfo;
transactiongrid.DataBind();
}
then i want to retrive all griddata.i set the pagesize as 10 and allow paging to true.when i try to get all records it give only 10(current page records)
protected void generatebtn_Click(object sender, EventArgs e)
{
generate(transactiongrid);
}
can anyone tell me how solve this issue. i'm using linq.

Answer 1

Hi Manish,


Please refer the below links

http://strictlysql.blogspot.in/2010/11/lock-escalation-sql-server-2008.html

http://msdn.microsoft.com/en-us/library/ms184286%28v=sql.105%29.aspx

http://aboutsqlserver.com/2012/01/11/locking-in-microsoft-sql-server-part-12-lock-escalation/



Thanks