title: Unable to get each cell Value in Telerik RadGrid BatchEdit mode
body: <p>I have Telerik RadGrid with BatchEditMode, </p>
  
  <p>my requirement is on button click get all the values of the cells (entered during batch edit mode), but i am unable to get those values.
  My Main Target is to pass whole RadGrid as a Datatable to Database Procedure.
  Here is my Telerik RadGrid Code.</p>
  
  <pre><code>enter code here
       &lt;telerik:RadGrid RenderMode="Lightweight" ID="RadGrid1" runat="server" 
              CellSpacing="0" GridLines="Both"
              OnItemDataBound="RadGrid1_ItemDataBound" AllowPaging="false"
              AutoGenerateColumns="false" 
              onneeddatasource="RadGrid1_NeedDataSource"
              &gt;
              &lt;ClientSettings AllowKeyboardNavigation="true"&gt;
                  &lt;Selecting AllowRowSelect="True" CellSelectionMode="MultiColumn" /&gt;
                  &lt;Scrolling AllowScroll="True" UseStaticHeaders="True" /&gt;
                  &lt;Resizing AllowColumnResize="true" AllowResizeToFit="true" /&gt;
  
                  &lt;ClientEvents OnBatchEditGetCellValue="BatchEditGetCellValue"   OnCellSelected="cellSelected"  OnRowCreated="RowCreated" 
                      OnBatchEditOpening="BatchEditOpening"
                       /&gt;
              &lt;/ClientSettings&gt;
  
              &lt;MasterTableView CommandItemDisplay="Bottom" Width="100%" HeaderStyle-HorizontalAlign="Center"
                  FilterItemStyle-HorizontalAlign="Center" DataKeyNames="COLUMN1"
                  HorizontalAlign="Justify" EditMode="Batch" AutoGenerateColumns="false"&gt;
  
                  &lt;BatchEditingSettings EditType="Cell" SaveAllHierarchyLevels="true"  /&gt;
  
              &lt;/SortExpressions&gt;--%&gt;
  
                  &lt;Columns&gt;
  
  
  
  
                      &lt;telerik:GridBoundColumn DataField="CFIT_ID" HeaderText="Cashflow" SortExpression="ProductName"
                          UniqueName="CFIT_ID" Display="false"&gt;
                          &lt;ColumnValidationSettings EnableRequiredFieldValidation="true"&gt;
                              &lt;RequiredFieldValidator ForeColor="Red" Text="*This field is required" Display="Dynamic"&gt;
                              &lt;/RequiredFieldValidator&gt;
                          &lt;/ColumnValidationSettings&gt;
                      &lt;/telerik:GridBoundColumn&gt;
  
  
  
                       &lt;telerik:GridNumericColumn DataField="COLUMN1" HeaderStyle-Width="83px" HeaderText="COLUMN1" 
                          SortExpression="COLUMN1" UniqueName="COLUMN1"&gt;
                      &lt;/telerik:GridNumericColumn&gt;
  
  
  
  
  
  
                  &lt;/Columns&gt;
  
              &lt;/MasterTableView&gt;
  
          &lt;/telerik:RadGrid&gt;
          &lt;asp:Button ID="btnSubmit" runat="server" OnClick="btnSubmit_Click"  Text="Submit"/&gt;
  
      ////////////////////////////////////////////////////////////////
  </code></pre>
  
  <p>Trying to Get Value of each Numeric Cell Value using this code.</p>
  
  <p>foreach (GridEditableItem item in RadGrid1.Items)
              {
                  dr = dt.NewRow();</p>
  
  <pre><code>            RadNumericTextBox DNumericTextBox = (RadGrid1.MasterTableView.GetBatchColumnEditor("COLUMN1") as GridNumericColumnEditor).NumericTextBox;
              dr["COLUMN1"] = item["COLUMN1"].Text.ToString();
              dt.Rows.Add(dr);
          }
  </code></pre>