1-May
June 9, 2008, 5:55pm
1
I have an excel file with 5 worksheets. I have a few custom command buttons (next, prev etc.). On clicking the buttons I need to change the activeSheetIndex. With my code below, the page_load gets executed before the customCommand. How can I call the pageLoad after the custom command is executed?
static int activePage = 1;
protected void Page_Load(object sender, EventArgs e) {
GridWeb1.WebWorksheets.ActiveSheetIndex = activePage;
}
protected void GridWeb1_CustomCommand(object sender, string command) {
if (command.Equals("Start")) {
activePage = 1;
}
else if (command.Equals("Prev")) {
activePage--;
}
else if (command.Equals("Next") ) {
activePage++;
}
}
Thanks.
Hi,
I think you may add a line related different custom command buttons in your code.
E.g,
protected void GridWeb1_CustomCommand(object sender, string command) {
if (command.Equals("Start")) {
activePage = 1;
GridWeb1.WebWorksheets.ActiveSheetIndex = activePage;
}
else if (command.Equals("Prev")) {
activePage--;
GridWeb1.WebWorksheets.ActiveSheetIndex = activePage;
}
else if (command.Equals("Next") ) {
activePage++;
GridWeb1.WebWorksheets.ActiveSheetIndex = activePage;
}
}
Thank you.
1-May
June 10, 2008, 11:33am
3
I tried the exact same code before . Didn't work. For some other reason I changed the XHTML property to false and now it works. Thanks.