This is a migrated thread and some comments may be shown as answers.

unable to get new values from rad grid on update

3 Answers 143 Views
Telerik Trainer
This is a migrated thread and some comments may be shown as answers.
Mubasshar
Top achievements
Rank 1
Mubasshar asked on 04 Jul 2011, 07:50 AM
Dear Team

i tried almost all the ways which i could find on internet but still unable to get the updated values from bound grid column.

plz check out my code lines.


aspx coding

<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="frmViewUnitMaster.aspx.vb" Inherits="iTourism.WebForm1" %>
 
<%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server" >
    <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
    </telerik:RadScriptManager>
    <div>
     
        <table style="width:100%;">
            <tr>
                <td>
                     </td>
                <td>
                    <asp:Button ID="btnAdd" runat="server" Text="Add" Width="69px" />
                    <asp:Label ID="lblMessage" runat="server" Text="Label"></asp:Label>
                </td>
                <td>
                     </td>
            </tr>
            <tr>
                <td>
                     </td>
                <td>
 
                    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
                        <AjaxSettings>
                            <telerik:AjaxSetting AjaxControlID="UMGrid">
                                <UpdatedControls>
                                    <telerik:AjaxUpdatedControl ControlID="UMGrid" />
                                </UpdatedControls>
                            </telerik:AjaxSetting>
                        </AjaxSettings>
 
 
 
                    </telerik:RadAjaxManager>
    <telerik:RadGrid ID="UMGrid" runat="server" AutoGenerateColumns="False" GridLines="None"
                        AllowFilteringByColumn="True" AllowSorting="True" AutoGenerateEditColumn="True"
                        AllowPaging="True" Width="60%" ViewStateMode="Enabled" CellPadding="10"
                        CellSpacing="10" onupdatecommand="UMGrid_UpdateCommand" >
 
 
 
        <ClientSettings>
            <Selecting AllowRowSelect="True" />
            <Scrolling AllowScroll="True"  />
            <Selecting AllowRowSelect="True"></Selecting>
             
        </ClientSettings>
 
 
 
<MasterTableView EditMode="EditForms" DataKeyNames="UnitCode">
 
    <Columns>
     
        <telerik:GridBoundColumn DefaultInsertValue="" UniqueName="UnitCode"
            HeaderText="UnitCode" DataField="UnitCode" ReadOnly="True">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DefaultInsertValue="" UniqueName="UnitDesc"
            HeaderText ="Unit Description" DataField="Description" >
        </telerik:GridBoundColumn>
 
         
         
    </Columns>
 
    <EditFormSettings  EditFormType="AutoGenerated"  >
 
             
         
    </EditFormSettings>
 
 
</MasterTableView>
 
 
 
    </telerik:RadGrid>
                </td>
                <td>
                     </td>
            </tr>
            
        </table>
     
    </div>
    </form>
</body>
</html>



vb Code


Imports System
Imports System.Data
Imports Telerik.Web.UI
Imports System.Data.SqlClient
 
 
Public Class WebForm1
    Inherits System.Web.UI.Page
 
    Dim objclsUnitMaster As New clsUnitMaster
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
 
        UMGrid.AutoGenerateDeleteColumn = True
        UMGrid.AutoGenerateEditColumn = True
        UMGrid.DataSource = (objclsUnitMaster.GetUnitCodeList).Tables("UnitMaster")
        UMGrid.DataBind()
    End Sub
 
    Protected Sub btnAdd_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnAdd.Click
        Response.Redirect("frmUnitMaster.aspx")
    End Sub
 

 
    Private Sub UMGrid_ItemCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles UMGrid.ItemCommand
         
 
        If (e.CommandName = RadGrid.UpdateCommandName) Then
           
            Dim editedItem As GridEditableItem = CType(e.Item, GridEditableItem)
             
            Dim newValues As New Hashtable
            e.Item.OwnerTableView.ExtractValuesFromItem(newValues, editedItem)
   'not getting the updated value         
            lblMessage.Text = newValues("Description").ToString
        End If
  
 
        
    End Sub
 
     
 
    Private Sub UMGrid_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles UMGrid.NeedDataSource
        UMGrid.DataSource = (objclsUnitMaster.GetUnitCodeList).Tables("UnitMaster")
        UMGrid.DataBind()
    End Sub
 
 
    Public Sub UMGrid_UpdateCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles UMGrid.UpdateCommand
 
        ' Dim editedItem As GridEditableItem = CType(e.Item, GridEditableItem)
        'Dim MyUserControl As UserControl = CType(e.Item.FindControl(GridEditFormItem.EditFormUserControlID), UserControl)
 
 
        Dim _UnitCode As Integer = 0
        Dim _Description As String = ""
        Dim _Result As Long = 0
 
        Dim _item As GridEditableItem
        _item = e.Item
 
        Try

             _UnitCode = Convert.ToInt32(DirectCast(_item("UnitCode").Controls(0), TextBox).Text)
 'Unable to Get Updated Value using this also
            _Description = DirectCast(_item("Description").Controls(0), TextBox).Text
 
 
            _Result = objclsUnitMaster.UpdateUnitByCode(_UnitCode, _Description)
 
            If _Result = 0 Then
                lblMessage.Text = "Record Saved Successfully"
            Else
                lblMessage.Text = "Error While Saving Record" & " - " & _Result
            End If
 
            'UMGrid.Rebind()
        Catch ex As Exception
 
            lblMessage.Text = ex.Message
 
        End Try
 
 
 
 
    End Sub
End Class


if any body can help me regarding this .

3 Answers, 1 is accepted

Sort by
0
Pavlina
Telerik team
answered on 07 Jul 2011, 02:48 PM
Hi Mubasshar,

I am sending you a simple working project, which demonstrates how you can get the original value and the updated value. Give it a try and let me know if it works for you.

All the best,
Pavlina
the Telerik team

Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!

0
Kenneth Ng
Top achievements
Rank 1
answered on 01 Aug 2017, 10:53 AM

hi i have tried this method ...it still can't get the newvalue ... 

 

0
Eyup
Telerik team
answered on 02 Aug 2017, 06:16 AM
Hello Kenneth,

I've already responded to your query in your formal support ticket. I suggest that we continue our technical conversation on the mentioned thread.

In addition, I will also post the reply here so other developers with similar issues can see it as well:

Please make sure you are not using DataBind() method to bind the grid. Performing complex grid operations such as Inserting, Deleting, Updating, Hierarchy relations, Grouping, Exporting, Paging, Sorting, Filtering, etc. require accommodating appropriate database operations.  Therefore, we suggest you to avoid Simple Databinding and strongly recommend the use of more advanced databinding methods, which automatically handle the aforementioned functions:

Declarative DataSource (DataSourceID property)
Programmatic Data Binding (NeedDataSource event, + DetailTableDataBind for hierarchy). You should set the DataSource property ONLY within these event handlers.


As for outside button, you can use:
http://www.telerik.com/forums/how-to-fire-the-updateedited-method-from-an-outside-button#5Af7aU0fFEa0UKS5HOhyjA

Regards,
Eyup
Progress Telerik
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
Telerik Trainer
Asked by
Mubasshar
Top achievements
Rank 1
Answers by
Pavlina
Telerik team
Kenneth Ng
Top achievements
Rank 1
Eyup
Telerik team
Share this question
or