I have the following grid on which I'm able to edit and save the field "QUANTYTY" with the MaskedEditColumn. I'm also populating the dropdownlist from the database.

The problem is that when I select an item in dropdowlist in the edit mode the value is not passed to the grid for later update. In addition the value dropdownlist of the next row I select changes to the previous dropdownlist selected value. I checked the example but I'm not able to find a solution.

I know I have to get the selected value from the dropdownlist and pass it to the grid but I'm not able to determine how to do it.


Please help me.

Thanks in advance.


THE GRID COLUMNS

<Columns>
<eo:StaticColumn Width="50" HeaderText="<%$ Resources:AppStrings, TC_Date %>" DataField="TRANSACTION_DATE"></eo:StaticColumn>
<eo:MaskedEditColumn Width="50" DataField="QUANTYTY" HeaderText="<%$ Resources:AppStrings, TC_Amount %>">
<MaskedEdit ID="MaskedEdit4" CssClass="body10" runat="server" TextBoxStyle-CssText="BORDER-RIGHT: #7f9db9 1px solid; PADDING-RIGHT: 2px; BORDER-TOP: #7f9db9 1px solid; PADDING-LEFT: 1px; FONT-SIZE: 9px; PADDING-BOTTOM: 1px; MARGIN: 0px; BORDER-LEFT: #7f9db9 1px solid; PADDING-TOP: 2px; BORDER-BOTTOM: #7f9db9 1px solid;">
<eo:MaskedEditSegment IsRequired="True" MinValue="0" MaxValue="1" SegmentType="Number"></eo:MaskedEditSegment>
<eo:MaskedEditSegment IsRequired="True" MinValue="0" MaxValue="9" SegmentType="Number"></eo:MaskedEditSegment>
<eo:MaskedEditSegment Text=":" IsRequired="True"></eo:MaskedEditSegment>
<eo:MaskedEditSegment IsRequired="True" MinValue="0" MaxValue="5" SegmentType="Number"></eo:MaskedEditSegment>
<eo:MaskedEditSegment IsRequired="True" MinValue="0" MaxValue="9" SegmentType="Number"></eo:MaskedEditSegment>
</MaskedEdit>
</eo:MaskedEditColumn>
<eo:StaticColumn Width="100" HeaderText="<%$ Resources:AppStrings, TC_BusinessUnit %>" DataField="BUSINESS_UNIT"></eo:StaticColumn>
<eo:CustomColumn Width="85" DataField="TRANS_CONCEPT" HeaderText="<%$ Resources:AppStrings, TC_Concept %>" ClientSideBeginEdit="on_begin_edit()" ClientSideEndEdit="on_end_edit()" ClientSideGetText="on_column_gettext()">
<EditorTemplate>
<asp:DropDownList id="ddlTime" runat="server" datasourceid="SqlDataTransactionConceptTime" datatextfield="DESCRIPTION" datavaluefield="DESCRIPTION" CssClass="body10" Width="84" >
</asp:DropDownList>
</EditorTemplate>
</eo:CustomColumn>
<eo:StaticColumn Width="100" HeaderText="" DataField="OLD_QUANTYTY" Visible="false"></eo:StaticColumn>
<eo:StaticColumn Width="100" HeaderText="" DataField="OLD_TRANS_CONCEPT" Visible="false"></eo:StaticColumn>
<eo:StaticColumn Width="100" HeaderText="" DataField="DIV1" Visible="false"></eo:StaticColumn>
<eo:StaticColumn Width="100" HeaderText="" DataField="DIV2" Visible="false"></eo:StaticColumn>
<eo:StaticColumn Width="100" HeaderText="" DataField="DIV3" Visible="false"></eo:StaticColumn>

</Columns>

The not working script (based in your example) is

<script type="text/javascript">

function on_column_gettext(column, item, cellValue) {

}

function on_begin_edit(cell) {
//Get the current cell value
var v = cell.getValue();

//Use index 0 if there is no value
if (v == null)
v = 0;

//Load the value into our drop down box
var dropDownBox = document.getElementById("ddlTime");
dropDownBox.selectedIndex = v;
}

function on_end_edit(cell) {
//Get the new value from the drop down box
var dropDownBox = document.getElementById("ddlTime");
var v = dropDownBox.selectedIndex;

//Use null value if user has not selected a
//value or selected "-Please Select-"
if (v == 0)
v = null;

//Return the new value to the grid
return v;
}

</script>

I got it to work if I use a non datasource based dropdownlist like the following list.

<select id="ddlTime">
<option>-Please Select-</option>
<option>Horrible</option>
<option>Poor</option>
<option>Fair</option>
<option>Good</option>
<option>Excellent</option>
</select>

But if I use the list with a data source I get an "Object Required" error. How should I populate the dropownlist to get it to work?

This is the data source based dropdownlist I've been using.

<asp:DropDownList id="ddlTime" runat="server" datasourceid="SqlDataTransactionConceptTime" datatextfield="DESCRIPTION" datavaluefield="DESCRIPTION" CssClass="body10" Width="84" >
</asp:DropDownList>