Intersoft Community - WebGrid Enterprise - selectedRow.Update() Exception

selectedRow.Update() Exception

Peter — Wed, 10 Feb 2010 15:44:49 GMT

Thanks, it worked

selectedRow.Update() Exception

andi@intersoftpt.com — Tue, 09 Feb 2010 22:40:14 GMT

Hi Peter,

Yes, the code that you have provided is almost correct. But to set the auto value of column, we will need to use SetText instead of SetValue. And also, we do not need to get the selected object and so on, because on OnBeforeAdd event, it will pass the rowObject, so we can just use that particular object. Here is the snippet to do so:

  function WebGrid1_OnBeforeAdd(controlId, tblName, rowObject)
        {
            var WebGrid1 = ISGetObject(controlId);
            var cells = rowObject.GetCells();
            var getCell = cells.GetNamedItem("Description");
            getCell.SetText("This is an auto fill", true)
                     
            return true;
        }

I hope it helps and please, do not hesitate to ask if you have any other questions. Thank you.

Best Regards,

Andi Santoso

selectedRow.Update() Exception

Peter — Tue, 09 Feb 2010 05:48:56 GMT

I am attempting to set some default values on the client side when a new row is added to a bound WebGrid. However, when I update the row I get an error message. The cell and DB column behind, that I am writing to, is a string. If I type in the very same string, rather than setting it in the script, it works. The exception occurs during selectedRow.Update().

Hope you can help:

Client script:
function OnBeforeAdd(controlId, tblName, rowIndex, rowEl) {

var WebGrid1 = ISGetObject(controlId);
var selectedRow = WebGrid1.GetSelectedObject().ToRowObject();
var cells = selectedRow.GetCells();
cells.GetNamedItem("Description").SetValue("jubii");
selectedRow.Update();

return true;
}

Error message: (see also attached screendump)

Server Error '/' Application

Input String was not in a correct format

Peter