I recently checked the writing materials and spent some time improving the sqlpager control. I have some experiences in using it. I will record it and share it with you...
Improved sqlpager:
When using two sqlpager controls for synchronous display, you need to write the pageindexchanged event of sqlpager. Private Void Sql1_pager ( Object Sender, sqlpager. pagechangedeventargs E)
{
Sqlpager2.currentpageindex=Sqlpager1.currentpageindex;
Sqlpager2.databind ();
}
Private Void Sql2_pager ( Object Sender, sqlpager. pagechangedeventargs E)
{
Sqlpager1.currentpageindex=Sqlpager2.currentpageindex;
Sqlpager1.databind ();
}
Also, pay attention to the correct use of the currentpageindex attribute and modify it as needed.
Background:
1. I feel that the original control interface is not in line with the usage habits. After modification, I feel that the convenience is greatly improved!
2. Write so many pagesProgram, I think this is the fastest and most stable! Good controls
Improved sqlpager. dll: http://files.cnblogs.com/hermes262/sqlpager.rar