function UpdateGrid()
{
    var wgTest = ISGetObject("wgTest");
    var row = wgTest.RootTable.GetRow(2);
    var cells = row.GetCells();
    var interestCell = cells.GetNamedItem('Interest');

    interestCell.SetValue("1");
    row.Select();
    interestCell.ActivateEdit();
    
    row.SetDataChanged();
    row.Update();

    wgTest.MarkEdit();
}

function wgTest_OnEnterEditMode(controlId, tblName, editObject)
{
    var wgTest = ISGetObject(controlId);
    var selIndex = editObject.element.selectedIndex
    var selText = editObject.element.options[selIndex].text;

    editObject.ToCellObject().SetText(selText);
}

This doesn't work for me. Let's assume that I do not want to use the OnEnterEditMode because people can enter the edit mode if they want so it would be called in multiple instances.

Let's say in javascript I have the value for the dropdown. I obviously know the grid and column I'm working with.

How can I get to the list of values/text values for the dropdown?

I've tried grid.RootTable.Columns.GetNamedItem("site").ValueList but there is no data to be pulled. It's DataRetrieved attribute is false.

OK, I may have found somthing which works for me.

I have found that the values held for the drop down list are stored somewhere in the current page in a <select  where the id for the object is <gridname>_<tablename>_<columnname>. I can then acess this in jQuery and get the text value with the following.

// assume that the select object on the webpage is named grid1_table1_mycolumn

// assume that the value of the cell is held in the cellValue variable.

 var dropdownTextValue = $("#grid1_table1_mycolumn option[value='" + cellValue + "']").text();