Intersoft Community - WebGrid Enterprise - How do I find the value for ListDataTextField value given the ListDataValueField for a dropdown

How do I find the value for ListDataTextField value given the ListDataValueField for a dropdown

JohnnyBravo — Thu, 10 Jun 2010 15:01:08 GMT

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();

How do I find the value for ListDataTextField value given the ListDataValueField for a dropdown

JohnnyBravo — Thu, 10 Jun 2010 10:49:01 GMT

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.

How do I find the value for ListDataTextField value given the ListDataValueField for a dropdown

Glayaar — Wed, 09 Jun 2010 22:57:37 GMT

In order to retrieve the text, assuming you are using BatchUpdate WebGrid, you will need to set the value of the cell with the value and invoke ActivateEdit function. Afterward during the OnEnterEditMode client side event handler you will need to retrieve the text from the editobject, in this case a HTML select element. Here is the snippet, assuming we are trying to set the Interest column second row of WebGrid with the value of 2:

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);
}

Another suggestion is, depending on the search functionality, you could try retrieving both the cell WebValueList value and cell WebValueList name during the search function.

How do I find the value for ListDataTextField value given the ListDataValueField for a dropdown

JohnnyBravo — Wed, 09 Jun 2010 10:43:46 GMT

I have a WebGrid and I'm using a dropdown for a column (location). The column is part of a record representing a phone in an office (location, phone number extension).

The source of the dropdown is a stored procedure.

There are multiple ways of editing here, but one of the options is when the clicks a button, a 'search' window appears allowing the user to select a different office phone. When this is done, I get the location code of the new phone.

I can get the location code (which is the ListDataValueField for the dropdown) but how can I get the ListDataText field value?

In other words, I only have the Value for the cell. How can I get the Text value from the dropdown when given the Value of the cell?