Brand new to this.

I think I have checked every example and searched the forum -- can't seem to find this simple answer.

Looking for precise instructions using vb and whatever Javascript is req'd.

Is the only/cleanest way to have a non-visible button and in one of the events do a button1.click()?

Or what exactly do I put in the ClientSideEndEdit -- lots of posts out there about validation, but all I want to do is commit it to the dbase. I've got my grid bound to a SQL datasource with Select, Update, Insert and Delete statements all activiated.

Thanks.

Thanks, I can follow that, but in the meantime I decided to replicate as closely as possible the Excel-style demo using the CallbackPanel1 with the trigger to Button1.

I'm getting my grid. The data is there. I can change it. But when I postback (or callback) -- tried both, the edited data isn't changed.

My grid is bound to a SQLdatasource that has the Insert, Delete, Update, Select commands.

I specify the SqlDataSource1 in DataSourceID.

I only have two columns, the first is the primary key field. No errors but the edit doesn't commit -- next time I call up the grid it's the same as the original.

Reading some other posts, it looks as if I can't used the SqlDataSource to write back to the DB? I have to write my own Update statement using the grid.ChangedItems property?

Is that right?

In what event do I place the Update statement? Grid1_ItemsChanged?

Everything looks good, I just don't know how to write my edited data back to the DB.

That helps. I'm sure I can figure it out the update, but any sample VB code for this?

(I am spoiled because I am used to the SqlDataSource handling everything for me in the ASP Listview, though the EO Grid is 1000x better -- looks like this one thing I have to handle myself and seems like it would be a common request on the forum (?)

Another question related to your comment about postback.

What I did to follow your Grid Excel-style sample is:
1. insert an EO Callbackpanel.
2. Add an EO.Web.CallbackTrigger
3. In the ControlID I put Button1
4. I added a Button1 to the form. but there is not code behind it, right?

When the button is pressed, it should cause a callback and the Grid1_ItemsChanged to fire and there I can use the sample code to examine the Grid1.ChangedItems.Cells collection for item.key and cell.column.datafield and cell.value properties to construct a SqlDataSource update statement.

I can do it for the whole row, the whole grid or just cell-by-cell depending on what I want to do.

Do I have it right?

I've invested a lot of time trying to follow your guidance, still need your help.

I've figured out that most of the instructions/examples you've given me refer to FullRowMode=True.

I am trying to edit a cell with FullRowMode=False and as soon as I leave the cell, I want raise an event that I can handle in my VB code to update it back to the SqlDataSource without the user having to press a button.

I like the idea of doing this with a callback instead of a postback but I want the callback to happen when the user edits or completes editing a cell.

There are plenty of examples in the demo project having to do with selecting, inserting and deleting, but none involving Excel-style editing unless you postback with a button press. (I can see how that works, that's not the nature of this question.)

I understand now that any of the methods/properties/events that refer to items, I can't use with FullRowMode=False. I need to concentrate on those that have to do with cells.

I can use the Grid.ClientSideOnCellSelected property to specify a javascript function passing the grid. There I can raise the event Grid1_ItemCommand, BUT then it won't let me edit the cell. It just postsback and leaves me in select mode.

I tried raising an event from the ClientSideEndEdit -- but you can only pass cell (not grid) to that handler, so it is not able to execute a grid.RaiseItemCommantEvent.

Looking back at the four methods you gave me above, of posting or calling back without the user having to press a button, I think all seem to relate to CommandNames and/or FullRowMode=True.

Here's my Javascript code so far. I hope you can get me on track. Love your product, have carefully gone over every example provided, looked up every function and property I can think of,
searched through all the posts -- still stuck.

THIS ONE RAISES EVENT WITH CLIENTSIDEONSELECTED, BUT WON'T LET ME EDIT THE CELL.
function OnItemEdited(grid) {
var cell = grid.getSelectedCell();

setTimeout(function() {
grid.raiseItemCommandEvent(cell.getItemIndex(), "edit");
}, 10);
}

THIS ONE INVOKED FROM CLIENTSIDEENDEDIT, BUT OF COURSE, CAN'T RAISE AN EVENT HERE WITH THIS METHOD BECAUSE YOU'RE NOT PASSING A GRID
function on_endedit(cell, newValue)
{
setTimeout(function() {
grid.raiseItemCommandEvent(cell.getItemIndex(), "edit");
}, 10);


}