Intersoft Community - edit

Example for editable simple grid wanted

Eric — Tue, 20 Sep 2011 06:17:40 GMT

Hello

We have a simple WebGrid (currently using version 6) that displays some rows from the database (unbound) where the user can edit one column and add/remove additional rows with a button. The changed data does not go into the database until the user confirms he wants to save everything together or maybe cancels out.

The WebGrid is defined with AllowAutoDataCaching="false", because caching does not work with our web farm setup.

The WebGrid has a DataKeyField defined and some columns, all read-only, except one for the Weight with AggregateFunction="Sum", DataFormatString="#0.00", DataType="System.Double", EditType="TextBox".

The grid_InitializeDataSource function dynamically creates the rows based on a class variable and assigns the created DataTable to e.DataSource. The content of the class variable is filled in Page_Load.

Because WebGrid fails to update the Sum on hitting Enter, we have a ClientSideEvent OnExitEditMode defined. There we calculate the current total and update it with grid.RootTable.GetElement(WG40.COLFOOTER,WG40.HTMLTABLE).rows[1].cells[...].innerText=...

(Adding/Deleting rows works by the user clicking a button and in the event adding a row to grid.DataSource and calling grid.RebindDataSource. Not relevant to the problem.)

Now the problem is that after every value edit and selection change afterwards, the InitializeDataSource event gets called again, overwriting the edited user values and the total calculation also gets wrong (the screen still shows the user values though). I think this happened after our move to the web farm and disabling the caching mentioned earlier.

What is the proposed way to do this without caching data within the grid?

Eric

wgGetNextEditableCell() issue

qq397472251 — Mon, 11 Oct 2010 23:20:03 GMT

I want to get next cell from one edit cell by the way "wgGetNextEditableCell() ",but it does not work!

var grid = ISGetObject("WebGrid1");
var curCell = grid.GetActiveEditCell().cellIndex;
var Tcell = grid.GetSelectedObject().ToRowObject().GetCell(curCell - 1).GetElement(WG40.BODY, WG40.HTMLCELL);
 var NextcellElement = wgGetNextEditableCell(Tcell);
 var cellObj = wgGetCellByElement(NextcellElement);
alert(NextcellElement)
alert(Tcell.innerText)

unbound Webgrid problem

20100520 — Thu, 20 May 2010 03:44:10 GMT

hello,

I use webgrid in usercontrol. I set a datatable as webgrid's datasource.

then load it in a page dynamicly. This page contains a WebPaneManager.Then I run it. when I sort a column,it occur a error.some times it doesn't occur,but it will refresh page twice.

I really need your help.

Thanks