Hi John,

     After I read through your scenario, I believe we do not need to have the condition of when the user first starts to edit a record and when the users make a selection from dropdown list. We can simple use a client side of OnRowSelect and make a validation based on what is the value in the validation column.

     If it meets the validation, it will automatically set the edit to false. Here is the snippet on how to do so. In here, I make a validation if the Customer ID is "HANAR", the other two columns are not able to be edited.

  function WebGrid1_OnRowSelect(controlId, tblName, rowIndex, rowEl)
  {
    var grid = ISGetObject(controlId);
    if (grid.GetSelectedObject().ToRowObject().GetCells().GetNamedItem("CustomerID").Value == "HANAR")
    {
        grid.GetSelectedObject().ToRowObject().GetCells()[2].SetForceNoEdit(true);
        grid.GetSelectedObject().ToRowObject().GetCells()[3].SetForceNoEdit(true);
    }
  }

      However, please let me know if it does not meet your scenario. Thank you and have a nice day.

Best Regards,

Andi Santoso

Ok, this seems to work. Now I have another question.

What event is tied to when the user make a change to a cell (let's say they selected an option in a drop down list)? I also have to see that if they selected a specific option in the dropdown to not allow editing for certain columns....

I enclosed one simple sample of WebGrid based on your scenario.

The grid binds to ‘Products’ table of Northwind database using ISDataSource control. There are four columns inside the grid, “ProductID”, “CategoryID”, “ProductName”, and “SupplierID”. “CategoryID” column uses value list so that the ‘CategoryName’ will be showed instead of the id.

Within the page, WebCombo is added. Combo binds to ‘Categories’ table of Northwind database using ISDataSource control and used as “CategoryID” column (of WebGrid) edit type.

When user selects “Category” where the “CategoryID” value is odd (CategoryID = 1; or CategoryID = 3; and so on), then “ProductName” column will be disabled. When user selects “Category” where the “CategoryID” value is even (CategoryID = 2; or CategoryID = 4; and so on), then “SupplierID” column will be disabled.

For more detail information, please check the attached sample.

Sorry Yudi,

I am not using a WebCombo. I'm using a dropdown list object. ( EditType="DropdownList")

How can I do this with a dropdown?

This does it. Thank you very much....

Hi John,

    Glad to know it has solved your problem. Please do not hesitate to ask if you have any other questions. Thank you and have a nice day.

Best Regards,

Andi Santoso