Intersoft Community - WebGrid Enterprise - Readonly column(EditType = EditType.DropdownList) should show datatext field

Readonly column(EditType = EditType.DropdownList) should show datatext field

yudi — Tue, 11 Oct 2016 08:05:54 GMT

Thank you for the sent sample. I can reproduce the reported problem using the sample.

I’m currently still investigating this issue and need more time to provide you with solution, suggestion, or sample.

I’ll get back to you as soon as possible.

Readonly column(EditType = EditType.DropdownList) should show datatext field

sjain — Wed, 28 Sep 2016 08:56:12 GMT

Hi,

Coule please give us solution ASAP, Please?

Regards

Sachin Jain

Readonly column(EditType = EditType.DropdownList) should show datatext field

sjain — Tue, 20 Sep 2016 15:02:58 GMT

Hi,

Thanks for the reply

I used client side to make column readonly with following code given by you:

function ToggleColumnEdit() {
    // retrieves WebGrid's object
    var grid = ISGetObject("WebGrid1");

    // access WebGrid's RootTable
    var rootTable = grid.RootTable;

    var columnSupplierID = rootTable.GetColumn("SupplierID");
    var columnCategoryID = rootTable.GetColumn("CategoryID");

    columnSupplierID.EditType = "NoEdit";
    columnCategoryID.EditType = "NoEdit";

    return true;
}

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Issue 1: Filter is not working based on datatext field of column which is made as readonly.

issue 2: when clear the filter it is bound with datavalue field.

Please see my 5 images attached as test case.

I attached the code with sample database.

Please reply ASAP.

Thanks

Sachin Jain

Readonly column(EditType = EditType.DropdownList) should show datatext field

yudi — Fri, 16 Sep 2016 03:41:24 GMT

I started my investigation by modifying BindWebValueListtoISDataSource.aspx sample file of WebGrid. The live version of this sample is in here.

The SupplierID and CategoryID column of the sample are having column edit type as DropdownList. I tested the reported problem by using following approach:

Set column's EditType to NoEdit using OnInitializeColumn server-side event.

OnInitializeColumn server-side event is invoked when WebGridColumn needs to be initialized during data binding. Following snippet code is used to set the column as read-only.

protected void WebGrid1_InitializeColumn(object sender, ColumnEventArgs e)
{
    if (e.Column.Name == "SupplierID" || e.Column.Name=="CategoryID")
    {
        e.Column.EditType = EditType.NoEdit;
    }
}

Result: column shows datatext field of dropdownlist.

Set cell's ForceNoEdit to true using OnInitializeRow server-side event.

OnInitializeRow server-side event is invoked when a WebGridRow need to initialized during data binding. Following snippet code is used to set the cell as read-only.

protected void WebGrid1_InitializeRow(object sender, ISNet.WebUI.WebGrid.RowEventArgs e)
{
    if (e.Row.Type==RowType.Record)
    {
        if (e.Row.KeyValue.ToString() == "1")
        {
            e.Row.Cells.GetNamedItem("SupplierID").ForceNoEdit = true;
            e.Row.Cells.GetNamedItem("CategoryID").ForceNoEdit = true;
        }
    }
}

Result: column shows datatext field of dropdownlist.

Set columns's EditType to NoEdit using JavaScript function.

Following snippet code is used to set the column's EditType to NoEdit.

function ToggleColumnEdit() {
    // retrieves WebGrid's object
    var grid = ISGetObject("WebGrid1");

    // access WebGrid's RootTable
    var rootTable = grid.RootTable;

    var columnSupplierID = rootTable.GetColumn("SupplierID");
    var columnCategoryID = rootTable.GetColumn("CategoryID");

    columnSupplierID.EditType = "NoEdit";
    columnCategoryID.EditType = "NoEdit";

    return true;
}

Result: column shows datatext field of dropdownlist.

Invoke SetForceNoEdit(true) of the cell using JavaScript function.

Following snippet code is used to set the cell to read-only.

function ToggleNewRowEdit() {
    // retrieves WebGrid's object
    var grid = ISGetObject("WebGrid1");

    // retrieves first row object
    var firstRow = grid.RootTable.GetRow(0);

    firstRow.GetCell("SupplierID").SetForceNoEdit(true);
    firstRow.GetCell("CategoryID").SetForceNoEdit(true);

    return true;
}

Result: column shows datatext field of dropdownlist.

I was unable to reproduce the reported problem using these techniques.

When we mark column(having column edit type as dropdownlist EditType = EditType.DropdownList;) as readonly, then datavalue field is shown.

I would need you to elaborate on your specific scenario and possibly give me a running simple sample of WebGrid and step-by-step guide that I can use to observe the problem.

Readonly column(EditType = EditType.DropdownList) should show datatext field

sjain — Thu, 15 Sep 2016 14:02:35 GMT

Hi,

When we mark column(having column edit type as dropdownlist EditType = EditType.DropdownList;) as

readonly, then datavalue field is shown.

how to make when column makred as readonly then datatext field show of doropdownlist not datavalue field?

Please reply ASAP.

Regards

Sachin Jain