How to set the value of a control after Update

[Ida]

Hi,
I have a header control in my RadGrid set out as:

<

 

 

telerik:GridBoundColumn DataField="RaisingFactor" HeaderText="Raising Factor" UniqueName="RaisingFactor" ReadOnly="true" Visible="true" DataFormatString="{0:N2}"></telerik:GridBoundColumn>

 

I wish to re-set the value of the text of this control after the Update has been made on the row that it belongs to.

Its a field that is calculated based on the values of 3 other fields. I wish the new value of this header to display straight after Update.

Any advice?

Thank you.

[Princy]

Hi Ida,

I'm not clear about your requirement, I guess you want to change the value of a column to the sum of the three column of a row after update.
Try the following code snippet. If this doesn't help, please elaborate on your requirements.

C#:

bool isUpdate = false;

int value;

  

protected void RadGrid_Master_UpdateCommand(object sender, GridCommandEventArgs e)

{

    isUpdate = true;

    GridEditableItem edit = (GridEditableItem)e.Item;

    value = Convert.ToInt32(edit.GetDataKeyValue("ID"));

   //Code to Update

}

protected void RadGrid_Master_ItemDataBound(object sender, GridItemEventArgs e)

{

    if (e.Item is GridDataItem && isUpdate)

    {

        GridDataItem item = (GridDataItem)e.Item;

        int id = Convert.ToInt32(item.GetDataKeyValue("ID")); // Accessing the row using Datakeyvalue

        if (value == id) // Checking if its the Updated Row

        {

            int column1 = Convert.ToInt32(item["ColumnUniqueName1"].Text); //Accessing the 1st Column's value

            int column2 = Convert.ToInt32(item["ColumnUniqueName2"].Text); //Accessing the 2nd Column's value

            int column3 = Convert.ToInt32(item["ColumnUniqueName3"].Text); //Accessing the 3rd Column's value

            int totalValue = column1 + column2 + column3;

            item["RaisingFactor"].Text = totalValue.ToString(); // Set the total


        }

    }

}

Thanks,
Princy

[Ida]

Hi Princy,
Hopefully my VB UpdateCommand code below will explain better what I am trying to do.

I click the Edit button. Make changes to 2 textboxes of numerical values. Then I click the Update button. 

The header control called RaisingFactor is not updated to the new calculated value it should be AFTER the Update button is clicked. It eventually updates to new value if I click the Edit button again.

When I debug through the code the value for editorRaisingFactor.Text   is correct, though I want to know how to get the new updated value to display on the screen in the control after Update.

Private Sub RDCatchTypes_UpdateCommand(source As Object, e As Telerik.Web.UI.GridCommandEventArgs) Handles RDCatchTypes.UpdateCommand
           ' Clear any error messages off the screen
           system_error.Visible = False
           Try
               If TypeOf e.Item Is GridEditableItem AndAlso e.Item.IsInEditMode Then
                   Dim edit As GridEditableItem = DirectCast(e.Item, GridEditableItem)
                   ' List of parameter values that need to be passed into the UPDATE SQL query
                   TripCode = RTrim(CStr(ddlTripCode.SelectedItem.Value))
                   Dim VesselCode As String = RTrim(TryCast(edit("VesselCode").Controls(0), TextBox).Text)
                   Dim HaulNumber As Integer = CInt(TryCast(edit("HaulNumber").Controls(0), TextBox).Text)
                   Dim RigNumber As Integer = CInt(TryCast(edit("RigNumber").Controls(0), TextBox).Text)
                   Dim CatchTypeCode As Integer = CInt(TryCast(edit("CatchTypeCode").Controls(0), TextBox).Text)
                   Dim BasketsCaughtTotal As Decimal = CDec(TryCast(edit("BasketsCaughtTotal").Controls(0), TextBox).Text)
                   Dim BasketsSampledTotal As Decimal = CDec(TryCast(edit("BasketsSampledTotal").Controls(0), TextBox).Text)
                   Dim ProportionSubSampled As Decimal = CDec(TryCast(edit("ProportionSubSampled").Controls(0), TextBox).Text)
                   ' Update the Catch Type details, using the control values as parameters
                   Dim daUpdateCatchType As New DSRaisingFactorsTableAdapters.DisGetCatchTypeDataByTripcodeTableAdapter
                   daUpdateCatchType.DisUpdateCatchTypeDetails(TripCode, VesselCode, HaulNumber, RigNumber, CatchTypeCode, BasketsCaughtTotal, BasketsSampledTotal, ProportionSubSampled)
                   ' Update the Raising Factor shown in the grid header
                   Dim editItemRaisingFactor As GridEditableItem = DirectCast(e.Item, GridEditableItem)
                   Dim editManagerRaisingFactor As GridEditManager = editItemRaisingFactor.EditManager
                   Dim editorRaisingFactor As GridTextBoxColumnEditor = DirectCast(editItemRaisingFactor.EditManager.GetColumnEditor("RaisingFactor"), GridTextBoxColumnEditor)
                   Dim dsRaisingFactor As New DSRaisingFactorsTableAdapters.DisGetCatchTypeDataByTripcodeTableAdapter
                   editorRaisingFactor.Text = daUpdateCatchType.DisGetRaisingFactorByTripHaulRigCatch(TripCode, VesselCode, HaulNumber, RigNumber, CatchTypeCode)
               End If
           Catch ex As Exception
               e.Canceled = True
               errorRaised = True
               errorMessage = ex.Message
               errorMessage = "There was a problem updating the raising factor(s). Please contact the administrator of the system to report the problem: " & ex.Message
               If errorRaised = True Then
                   system_error.Visible = True
                   lblError.Text = errorMessage
               End If
           End Try
       End Sub

[Princy]

Hi Ida,

I suppose you are setting the RaisingFactor column as ReadOnly="true". When a column is readonly, it's not visible in edit mode. Hence you can't set its Text in UpdateCommand as it doesn't affect it in view-mode. Since you are not updating the value of RaisingFactor to DB, its changes cannot be reflected in view-mode when doing calculations in the UpdateCommand. Hence if you want to set the Text of the column in view-mode its advisable to code in the ItemDataBound event of the RadGrid.
Hope this helps, let me know if any concern.


Thanks,
Princy

[Ida]

Hi Princy

Thank you for the advice.

I understand what you mean about the fact that my RaisingFactor column is not editable.

The ItemDataBound did not seem to work for me. So I tried an alternative way of updating this column by using a GridCalculatedColumn. But, the RaisingFactor still does not show the newly calculated value until I click the Edit button again. Any advice please?

<telerik:RadGrid ID="RDCatchTypes" Width="530" runat="server" AutoGenerateEditColumn="True" GridLines="Horizontal" AutoGenerateColumns="False" AlternatingItemStyle-BackColor="#ecf3f4" BorderColor="#28899A" EditItemStyle-BackColor="#009999" EditItemStyle-Font-Bold="true" OnNeedDataSource="RDCatchTypes_NeedDataSource">
          <AlternatingItemStyle BackColor="#ECF3F4"></AlternatingItemStyle>
          <HeaderStyle BorderColor="#28899A" Font-Bold="True" Font-Size="12px" Font-Names="Verdana" />
             <MasterTableView EnableViewState="false">
                   <Columns>
                      <telerik:GridBoundColumn DataField="TripCode" FilterControlAltText="Filter TripCode column" HeaderText="Trip Code" SortExpression="TripCode" UniqueName="TripCode" ReadOnly="true"></telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="VesselCode" HeaderText="Vessel" UniqueName="VesselCode" Visible="false" ReadOnly="true"></telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="HaulNumber" HeaderText="Haul" UniqueName="HaulNumber" ReadOnly="true"></telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="RigNumber" HeaderText="Rig"  UniqueName="RigNumber" ReadOnly="true"></telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="CatchTypeName" HeaderText="Catch Type" UniqueName="CatchTypeName" ReadOnly="true"></telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="CatchTypeCode" HeaderText="Catch Type Code" Visible="false" UniqueName="CatchTypeCode" ReadOnly="true"></telerik:GridBoundColumn>



                      <telerik:GridCalculatedColumn HeaderText="Raising Factor" UniqueName="RaisingFactor" DataType="System.Decimal" DataFormatString="{0:N2}" DataFields="BasketsCaughtTotal, BasketsSampledTotal, ProportionSubsampled" Expression="{0}/{1}/{2}" />



                      <telerik:GridBoundColumn DataField="BasketsCaughtTotal" HeaderText="Baskets Caught Total" UniqueName="BasketsCaughtTotal" ColumnEditorID="BasketsCaughtTotal" Visible="false" DataType="System.Decimal" DataFormatString="{0:N5}">
                           <ColumnValidationSettings EnableRequiredFieldValidation="True">
                                <RequiredFieldValidator ID="RFTotalBasketsCaught" Font-Bold="True"> Enter baskets caught</RequiredFieldValidator>
                            </ColumnValidationSettings>
                      </telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="BasketsSampledTotal" HeaderText="Baskets Sampled Total" UniqueName="BasketsSampledTotal" ColumnEditorID="BasketsSampledTotal" Visible="false" DataType="System.Decimal" DataFormatString="{0:N5}">
                           <ColumnValidationSettings EnableRequiredFieldValidation="True">
                                <RequiredFieldValidator ID="RFTotalBasketsSampled" Font-Bold="True"> Enter baskets sampled</RequiredFieldValidator>
                            </ColumnValidationSettings>
                      </telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="ProportionSubsampled" HeaderText="Proportion Sub-Sampled" UniqueName="ProportionSubSampled" ReadOnly="true" Visible="false"></telerik:GridBoundColumn>
                    </Columns>
                  </MasterTableView>
              </telerik:RadGrid>

[Princy]

Hi Ida,

I see that you have set the columns ReadOnly property to true, doing that the columns will not be editable. Then you have set the Visible="false", in such case these controls will not be accessible in the code behind. Make sure that all columns needed for Update have Visibility as True and are not ReadOnly. Please set EnableViewState="true" and see if it helps. Below is the code that i tried and works fine at my end.

ASPX:

<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateEditColumn="True"
    AutoGenerateColumns="false" DataSourceID="SqlDataSource1" OnUpdateCommand="RadGrid1_UpdateCommand">
    <MasterTableView EnableViewState="true" DataKeyNames="OrderID">
        <Columns>
            <telerik:GridBoundColumn DataField="OrderID" HeaderText="OrderID" UniqueName="OrderID">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="EmployeeID" HeaderText="EmployeeID" UniqueName="EmployeeID">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="ShipVia" HeaderText="ShipVia" UniqueName="ShipVia">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="Freight" HeaderText="Freight" UniqueName="Freight">
            </telerik:GridBoundColumn>
            <telerik:GridCalculatedColumn HeaderText="Raising Factor" UniqueName="RaisingFactor"
                DataType="System.Decimal" DataFormatString="{0:N2}" DataFields="EmployeeID, ShipVia, Freight"
                Expression="{0}/{1}/{2}" />
        </Columns>
    </MasterTableView>
</telerik:RadGrid>

VB:

Protected Sub RadGrid1_UpdateCommand(sender As Object, e As GridCommandEventArgs)
    Dim edit As GridEditableItem = DirectCast(e.Item, GridEditableItem)
    Dim OrderID As String = edit.GetDataKeyValue("OrderID").ToString()
    Try
        Dim id As String = TryCast(edit("EmployeeID").Controls(0), TextBox).Text
        Dim shipvia As String = TryCast(edit("ShipVia").Controls(0), TextBox).Text
        Dim freightnum As String = TryCast(edit("Freight").Controls(0), TextBox).Text

        'Code to Update

    Catch ex As Exception
    End Try
End Sub

Thanks,
Princy

[Ida]

Hi Princy, thank you for the advice.

Unfortunately when I set EnableViewState="true", none of my data displayed. No data was extracted. So I seemed to be unable to have that setting?

The 3 values that I need for calculating the update of my RaisingFactor control, I set Visibility as True and are not ReadOnly . This did not make a difference I'm afraid.

The RaisingFactor column did not display the correct new value once I clicked Update. The correct new value only appeared after I clicked the Edit link again. The RaisingFactor column only seems to refresh its value after a second click of the Edit link.

I'm totally baffled as to why this is happening as the grid does not need to make another call to the database.

Any advice?

Thank you, Ida

[Princy]

Hi Ida,

Unfortunately I couldn't replicate the issue. When you are using AdvancedDataBinding, the grid will automatically refresh after insert/update operation. Make sure that you have not set AllowAutomaticUpdates as true.

Thanks,
Princy

[Ida]

Hi Princy,

Hmmm...will just have to keep trying different things. I have AllowAutomaticUpdates set to False, though unfortunately the column I need re-calculated does not automatically update.

Thank you for your help!

Ida

[Kostadin]

Hello Ida,

Could you please provide your code declaration and the related code behind in order to investigate the issue further? I assume there is a binding issue which prevents the updating of the column values. I am looking forward to your reply.

Regards,
Kostadin
Telerik

[Ida]

Hi Kostadin,
Here is my grid:

<telerik:RadGrid ID="RDCatchTypes" Width="530" runat="server" AutoGenerateEditColumn="True" AllowAutomaticUpdates="false" GridLines="Horizontal" AutoGenerateColumns="false" AlternatingItemStyle-BackColor="#ecf3f4" BorderColor="#28899A" EditItemStyle-BackColor="#009999" EditItemStyle-Font-Bold="true" OnNeedDataSource="RDCatchTypes_NeedDataSource" ClientSettings-EnablePostBackOnRowClick="true">
          <AlternatingItemStyle BackColor="#ECF3F4"></AlternatingItemStyle>
          <ClientSettings AllowKeyboardNavigation="true" EnablePostBackOnRowClick="true">
            <Selecting AllowRowSelect="true"></Selecting>
          </ClientSettings>

          <HeaderStyle BorderColor="#28899A" Font-Bold="True" Font-Size="12px" Font-Names="Verdana" />
             <MasterTableView EnableViewState="false">
                   <Columns>
                      <telerik:GridBoundColumn DataField="TripCode" FilterControlAltText="Filter TripCode column" HeaderText="Trip Code" SortExpression="TripCode" UniqueName="TripCode" ReadOnly="true"></telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="VesselCode" HeaderText="Vessel" UniqueName="VesselCode" Visible="false" ReadOnly="true"></telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="HaulNumber" HeaderText="Haul" UniqueName="HaulNumber" ReadOnly="true"></telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="RigNumber" HeaderText="Rig"  UniqueName="RigNumber" ReadOnly="true"></telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="CatchTypeName" HeaderText="Catch Type" UniqueName="CatchTypeName" ReadOnly="true"></telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="CatchTypeCode" HeaderText="Catch Type Code" Visible="false" UniqueName="CatchTypeCode" ReadOnly="true"></telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="RaisingFactor" HeaderText="Raising Factor" UniqueName="RaisingFactor" ReadOnly="true" Visible="true" DataFormatString="{0:N2}"></telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="BasketsCaughtTotal" HeaderText="Baskets Caught Total" UniqueName="BasketsCaughtTotal" ColumnEditorID="BasketsCaughtTotal" Visible="false" DataType="System.Decimal" DataFormatString="{0:N5}">
                           <ColumnValidationSettings EnableRequiredFieldValidation="True">
                                <RequiredFieldValidator ID="RFTotalBasketsCaught" Font-Bold="True"> Enter baskets caught</RequiredFieldValidator>
                            </ColumnValidationSettings>
                      </telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="BasketsSampledTotal" HeaderText="Baskets Sampled Total" UniqueName="BasketsSampledTotal" ColumnEditorID="BasketsSampledTotal" Visible="false" DataType="System.Decimal" DataFormatString="{0:N5}">
                           <ColumnValidationSettings EnableRequiredFieldValidation="True">
                                <RequiredFieldValidator ID="RFTotalBasketsSampled" Font-Bold="True"> Enter baskets sampled</RequiredFieldValidator>
                            </ColumnValidationSettings>
                      </telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="ProportionSubsampled" HeaderText="Proportion Sub-Sampled" UniqueName="ProportionSubSampled" ColumnEditorID="ProportionSubSampled" ReadOnly="true" Visible="false"></telerik:GridBoundColumn>
                    </Columns>
                  </MasterTableView>
              </telerik:RadGrid>

And I have set a re-bind on the RaisingFactor column once an Update is made and that seems to have fixed the problem:

Private Sub RDCatchTypes_UpdateCommand(source As Object, e As Telerik.Web.UI.GridCommandEventArgs) Handles RDCatchTypes.UpdateCommand
               If TypeOf e.Item Is GridEditableItem AndAlso e.Item.IsInEditMode Then
                   Dim edit As GridEditableItem = DirectCast(e.Item, GridEditableItem)
                   ' List of parameter values that need to be passed into the UPDATE SQL query
                   TripCode = RTrim(CStr(ddlTripCode.SelectedItem.Value))
                   Dim VesselCode As String = RTrim(TryCast(edit("VesselCode").Controls(0), TextBox).Text)
                   Dim HaulNumber As Integer = CInt(TryCast(edit("HaulNumber").Controls(0), TextBox).Text)
                   Dim RigNumber As Integer = CInt(TryCast(edit("RigNumber").Controls(0), TextBox).Text)
                   Dim CatchTypeCode As Integer = CInt(TryCast(edit("CatchTypeCode").Controls(0), TextBox).Text)
                   Dim BasketsCaughtTotal As Decimal = CDec(TryCast(edit("BasketsCaughtTotal").Controls(0), TextBox).Text)
                   Dim BasketsSampledTotal As Decimal = CDec(TryCast(edit("BasketsSampledTotal").Controls(0), TextBox).Text)
                   Dim ProportionSubSampled As Decimal = CDec(TryCast(edit("ProportionSubSampled").Controls(0), TextBox).Text)
                   Dim RaisingFactor As Decimal = CDec(TryCast(edit("RaisingFactor").Controls(0), TextBox).Text)
                   ' Update the Catch Type details, using the control values as parameters
                   Dim daUpdateCatchType As New DSRaisingFactorsTableAdapters.DisGetCatchTypeDataByTripcodeTableAdapter
                   daUpdateCatchType.DisUpdateCatchTypeDetails(TripCode, VesselCode, HaulNumber, RigNumber, CatchTypeCode, BasketsCaughtTotal, BasketsSampledTotal, ProportionSubSampled, RaisingFactor)
                   ' Re-bind the grid so that the Raising Factor is updated
                   Dim ds As New DSRaisingFactorsTableAdapters.DisGetCatchTypeDataByTripcodeTableAdapter
                   ' Bind the grid to the catch type details
                   RDCatchTypes.DataSource = ds.GetCatchTypeDataByTripcode(TripCode)
       End Sub

[Kostadin]

Hello Ida,

I noticed that you have setting the datasource at the bottom of the page which is not supported scenario when using an advanced data binding. I would recommend you to examine the following code library which demonstrates how to implement update, insert, delete operation in grid. Additionally I would suggest you to use a GridCalculatedColumn which will automatically display the calculated value after updating a record.

Regards,
Kostadin
Telerik