Rank: Newbie
Groups: Member
Joined: 7/26/2011
Posts: 1
|
Hi,
I,m using your package EO, in special your grid control in trial mode.
We have a very special need here in a new ASP.NET project. We a grid the mimics the behavior of a excel grid.
Your grid have a lot of resources to do it, but we have some questions to can do it work aas we need.
We start from your sample excel style.
a.) it´s possible to cancel the row wrap last row/first row automatic when in keyboard navigation ?
b.) It´s possible to use the key down in last row to start a new row data input, and the ESC key to cancel this new entry in a automatic way (javascript for example) ?
c.) If I need to input data in a cell of some row ( row 3 for example ), how can I set the value of another cell in same row doing a database select without doing a post back to the server ?
d.) After input all the rows of data to my grid, how can I recover a datatble with only the changed rows in the grid to issue a update command to persist the chabges in the server database ?
I hope that we can do your grid mimics the excel behavior. This would solve a lot of needs of my development team.
Thanks in advance,
Best regards,
|
Rank: Administration
Groups: Administration
Joined: 5/27/2007
Posts: 24,194
|
Hi,
Thanks for posting in the forum. As to your question:
a. No. Unfortunately there is no way to disable that;
b. This in a way is already built-in, but it does not work exactly the way you described. You can set the Grid's AllowNewItem to true, in that case the Grid will automatically display an extra row after the last row (no matter which row you are currently at). You can then use arrow key to move your focus to that row. Inside that row you can use esc to cancel the edit (thus no new row will be actually appended). Once you submit a cell in that row, a new blank row is automatically added so that you can keep adding new rows. There is no code needed for this;
c. You can call our client side JavaScript interface to change the value of any cell in the Grid any time. However the Grid does not provide you an additional AJAX channel for you to pull your data. You can use other AJAX mechanism available to pull the data and then call the Grid's client side JavaScript interface to update the cell with the new data. For example, you can use our CallbackPanel to pull the data;
d. Yes. You can check the Grid's AddedItems, ChangedItems and DeletedItems for that. You can also handle the Grid's ItemAdded, ItemDeleted and ItemChanged event to populate the changes back to your db. Note you usually do not need to do both because the events are fired once for each affected row. For example, ItemChanged are fired once for each changed row;
Hope this helps. Please feel free to let us know if you have any more questions.
Thanks!
|