BuyLog In
Ticket T1154415
Visible to All Users

GridView for MVC - The SetCellValue method does not work for the first cell in a row

created 2 years ago (modified 2 years ago)

Hi,

We are using devexpress gridview in our MVC application. We want to assign a default value to the "Key" field from "BatchEditStartEditing" event when the new button is pressed. We have written the below code for that. We are able to see the value coming in the key field when debugging from the browser(Attaching the screen shot). But after the page loads completely the cell value is becoming blank. Please check the below code and let us know if we are missing anything

Razor
@model System.Data.DataTable
@Html.DevExpress().GridView(settings => {
settings.Name = "GridView";
settings.CallbackRouteValues = new {Action="GridViewPartial",Controller="Home"};
settings.KeyFieldName = Model.Columns\[0\].ColumnName; 
settings.ClientSideEvents.BatchEditStartEditing = "OnStartEdit";
foreach (System.Data.DataColumn column in Model.Columns) {
settings.Columns.Add(column.ColumnName);
}
settings.CommandColumn.Visible = true;
settings.CommandColumn.ShowNewButton = true;
settings.CommandColumn.ShowDeleteButton = true;

settings.SettingsEditing.Mode = GridViewEditingMode.Batch;
settings.SettingsEditing.BatchUpdateRouteValues = new { Action="BatchUpdateAction", Controller = "Home"};
}).Bind(Model).GetHtml()
JavaScript
<script type="text/javascript">
 var text = "";
 function OnStartEdit(s, e) {
 if (e.visibleIndex < 0) {
 s.batchEditApi.SetCellValue(e.visibleIndex, "Key", (999998 - e.visibleIndex), null, true);
 }
 } 
</script>
Sign in to comment on this post

Answers approved by DevExpress Support

created 2 years ago

Hello,
As far as I understand, the "Key" column is the first column in your grid. So, it is in edit mode (the editor is visible) when you add a new row. Please note that in this case, the SetCellValue method is not in effect. See ASPxClientGridViewBatchEditApi.SetCellValue remarks. Use the rowValues property to specify this cell value. We demonstrated this approach in the following example: GridView for MVC - How to implement clone functionality in batch edit mode. Refer to the ProcessCells function - in this function, we identify whether a cell in edit mode:

JavaScript
var isCellEditMode = selectedIndex == 0;

If so, we use rowValues to specify this cell value:

JavaScript
e.rowValues[column.index].value = cellValue;

Let me know if this information helps.

    Show previous comments (1)
    DevExpress Support Team 2 years ago

      The rowValues property allows you to specify a value of editable cells. If a cell is not visible, you can't specify its value. If you want to specify a value of a row key, you can do this in the BatchUpdateRouteValues action before inserting new rows in your data source.

      H H
      HK 2 years ago

        Dear Nataly
        We checked the BatchUpdateRouteValues and tried using the below example given in the link https://docs.devexpress.com/AspNetMvc/16147/components/grid-view/data-editing-and-validation/batch-edit. We can see that the values are accessed using the model class as shown below

        [HttpPost,
        ValidateInput(false)]
        public
        ActionResult BatchEditingUpdateModel(MVCxGridViewBatchUpdateValues<Customer,object> updateValues)
        but we cannot use this method as we are not using any model class and we are generating the columns dynamically from the stored procedure.

        Can you please suggest a way to use generate the value for the key field for the columns which are created dynamically without using the model class.

        Regards
        Hemant

        DevExpress Support Team 2 years ago

          Please accept my apologies for the delayed response.
          When you bind GridView to a dynamic object, it is not possible to identify its key field in the controller's action. If you want to modify this field value in the controller action, it is up to you to save your model structure and identify the key field name. Then, you can use the GridViewExtension.GetBatchInsertValues method to obtain new row values and save them to your data source.

          Sign in to comment on this post

          Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

          Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.