Hello,

I'm using your Grid and I am trying to get the selectedvalue of a dropdownlist within the grid.
I'm trying to use the following code that is not finding the EditorTemplate.FindControl method. I've confirmed I'm using your latest Dll build 5.0.44.2 How do I get the selectedValue of a DDL ?


Code behind

Dim CustCol As EO.Web.CustomColumn = DirectCast(Grid1.Columns(7), EO.Web.CustomColumn)

Select Case CustCol.EditorTemplate.FindControl("ddlPaymentType")

Case "Cashiers Check"
objPayment.PaymentTypeID = 1
Case "Personal Check"
objPayment.PaymentTypeID = 2
Case "Cash"
objPayment.PaymentTypeID = 3
Case "Credit Card"
objPayment.PaymentTypeID = 4
Case "Paypal"
objPayment.PaymentTypeID = 6
Case "Wire Transfer"
objPayment.PaymentTypeID = 7
End Select



ASPX CODE:

<eo:CustomColumn datafield="PaymentTypeID"
ClientSideBeginEdit="on_begin_edit"
ClientSideEndEdit ="on_end_edit">
<EditorTemplate >


<select datatextfield="PaymentTypeName" id="DDLPaymentType" >
<option>--Please Select-- </option>
<option>Cashiers check</option>
<option>Paypal</option>
<option>Personal Check</option>
<option>Credit Card</option>
<option>Cash</option>
<option>Wire Transfer</option>

</select>

</EditorTemplate>
</eo:CustomColumn>


Java Script


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("DDLPaymentType");
dropDownBox.selectedIndex = v;
}

function on_end_edit(cell)
{
//Get the new value from the drop down box
var dropDownBox = document.getElementById("DDLPaymentType");
var v = dropDownBox.selectedIndex;
var PaymentTypeID = 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 understand that I need to check the changeditem property. I'm doing that in the code below. I'm having problems trying to find the correct syntax to access the selectedvalue from a dropdownlist within the grid. Do you have an example of that ?

For Each item In Grid1.ChangedItems

Dim objPayment As New Payments(item.Key)
objPayment.ReservationID = Session("SesReservationID")
objPayment.PaymentAmt = item.Cells("PaymentAmt").Value
objPayment.PaymentDate = item.Cells("PaymentDate").Value
objPayment.PaymentDesc = item.Cells("PaymentDesc").Value
objPayment.PaymentRefNo = item.Cells("PaymentRefNo").Value
objPayment.PaymentTypeID = item.Cells("PaymentTypeID").Value

BELOW IS NOT WORKING

'Dim CustCol As EO.Web.CustomColumn = DirectCast(Grid1.Columns(7), EO.Web.CustomColumn)
' Select Case CustCol.ClientSideEndEdit.EditorTemplate.FindControl("ddlPaymentType")
Select Case item.Cells("ddlpaymentType").Value
Case "Cashiers Check"

Again, all I am trying to do is determine what the user selected from the DDL within the GRID
and then save it to a Database by looping through the Grid1.ChangedItems

PLEASE HELP, I've wasted too much time already.

I understand that the code I provided is not correct. I've tried to follow your examples, but do not know what you mean by "rely on Cell.value on the server side". I need specific examples ?
QUESTIONS:
1) What is the Specific syntax for Javascript on_end_edit function to fetch the value of your custom item and to "transfer it to Cell.Value "???; What is the specific syntax to "transfer it to a Cell.value" .

2) HOW DO I reference the Custom column cell value (i.e. what was selected) OF A DROPDOWNLIST WITHIN A GRID ON THE SERVER SIDE in the code-behind?

if the only thing I change is the selected value of the dropdownlist on the grid and then loop through it with the following code -- It detects the the dropdownlist Cell was modifed, but the cell.value is null.
For Each item In Grid1.ChangedItems

Dim objPayment As New Payments(item.Key)
objPayment.ReservationID = Session("SesReservationID")
objPayment.PaymentAmt = item.Cells("PaymentAmt").Value
objPayment.PaymentDate = item.Cells("PaymentDate").Value
objPayment.PaymentDesc = item.Cells("PaymentDesc").Value
objPayment.PaymentRefNo = item.Cells("PaymentRefNo").Value
' objPayment.PaymentRefNo = item.Cells("PaymentTypeid").Value

Dim cell As GridCell
For Each cell In item.Cells
If cell.Modified Then
Dim ttt As String = String.Format("Cell Changed: Key = {0}, Field = {1}, New Value = {2}", item.Key, cell.Column.DataField, cell.Value)

s += "<br />"
s += ttt
End If
Next cell