I want to restrict the user to edit any Gridweb’s cell only when he double clicks on a particular cell.
But currently, When we select any cell and start editing it is accepting.
Please let me know which property I should set to disable this feature.
Please let me know how to identify only the updated cells when the save button event is fired?
Thanks for the reply and I’m using OnCellUpdated event to find out the updated cells and it worked well.
Currently I have a requirement “to set selected columns to readonly in GridWeb”. Please suggest me some idea on this.
Please see the code below how to make selected cells readonly.
//Accessing the reference of the worksheet that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
//Setting all cells of the worksheet to Editable first
//Finally, Setting selected cells of the worksheet to Readonly
sheet.SetReadonlyRange(3, 2, 4, 1);
Please see the following document for your reference:
Thanks for the quick reply.
I have restricted the selected cells to ready only.
I need to implement an SQL paging to the ASPOSE Webgrid and I am unable to find any demo on this in your site. Please let me know if you have demo or article on this?
Hi Aspose Team,
Thanks for the link. But, I don’t want to use the default paging provided by Aspose as I have already stated I need to implement SQL Paging.
Our current aspose web grid needs to fetch millions of records from DB. So If I go for default paging millions of records are fetched at a time from DB,cached and paging will be provided which will have impact on the performance.
Hence, to increase the performance our idea is to implement SQL paging, In which only specified set of records will be fetched and loaded in to the grid and when the next page is clicked then next set of records will be fetched from DB and displayed.
But the problem is, the default paging dropdown provided by aspose web grid will not be displayed when there are no records fetched required for more than one page.
Please provide me some idea on this.
When we fetch only limited records in the initial load of the grid, Please let me know how to calculate and set the paging dropdown for all the records which we will be fetching from the DB. So that when the next page is selected and I can fecth next set of records.
As suggested I have used the custom buttons to implement SQL paging in WebGrid.
But, When I move to the 2nd or 3rd page, I am getting below error message. Any idea on this?
"Item has already been added. Key in dictionary: ‘43008’ Key being added: ‘43008’
Hi Amjad Sahi,
Our GridWeb is loading around 550 columns and 20 rows per page. But When I try to select any cell it is taking approximately 5 seconds to select the cell.
After selecting the cell, If I click on the cell to make it editable again this will take approximately 5 seconds to display the cursor on the cell.
Is this normal behavior when loaded so many column to the gridweb?
If not, Please let me know how to increase this performance or am I missing some settings.