Getting values on insert command

[Mark Ferkaluk]

Hi there,

I'm having trouble to get the insert values of my grid. My grid does on every postback a databind and it seems, that if that is done, the insert values are gone. If I don't databind on every postback, the grid doesn't show up (no columns, no rows).

My code to get the values is this:

Dim insertedItem As GridEditFormInsertItem = TryCast(e.Item, GridEditFormInsertItem)

Dim test As Object = TryCast(insertedItem.FormColumns(0).Controls(0).Controls(1).Controls(0), TextBox)

test.Text should contain the value, but it doesn't. Do you have any idea?

Thanks and regards,
Mark

[Jayesh Goyani]

Hello,

please use radgrid advanced data binding.

or
......solution for your existing code.

page_load()
{
if (!Page.IsPostBack)
{
 // bind your grid here
}
}

insert_command()
{
 // do your logic here
// bind your grid here
}

 NOTE : bind your grid when it needed not every time..

Thanks,
Jayesh Goyani

[Princy]

Hello Mark,

As Jayesh suggested you can try Advanced databinding to populate RadGrid. Also try the followimg code snippet to get the control in insert form while inserting.

ASPX:

<telerik:GridBoundColumn UniqueName="EmployeeID"  HeaderText="EmployeeID" DataField="EmployeeID">
</telerik:GridBoundColumn>

VB.NET:

Protected Sub RadGrid1_InsertCommand(sender As Object, e As GridCommandEventArgs)
    Dim item As GridEditFormInsertItem = DirectCast(e.Item, GridEditFormInsertItem)
    Dim txt As TextBox = DirectCast(item("EmployeeID").Controls(0), TextBox)
End Sub

Thanks,
Princy.

[Mark Ferkaluk]

Hi Jayesh,

thanks for your reply. The NeedDataSource Event does the trick.

But now I'm having trouble to get the second insertet data  control.

Dim customer As String = (TryCast(insertedItem("Customer").Controls(0), TextBox)).Text
Dim value As String = (TryCast(insertedItem("Value").Controls(0), TextBox)).Text
Dim units As String = (TryCast(insertedItem("Units").Controls(0), TextBox)).Text

The Customer value works, but on the "Value" value an error appears: Object reference not set to an instance of an object.

The Value field is a numeric column. Is that why it doesn't work?

Thanks,
Mark

[Jayesh Goyani]

hello,

Dim value As String = (TryCast(insertedItem("Value").Controls(0), TextBox)).Text

if your value field is numericColumn then...

TryCast(insertedItem("Value").Controls(0), RadNumericTextBox))

let me know if any concern.


Thanks,
Jayesh Goyani

[Mark Ferkaluk]

Hi there,

unfortunately this doesn't work. Either with .Value and .Text. There is no data in it?

Regards,
Mark

[Jayesh Goyani]

Hello,

Are you checked in edit mode or insert mode?

let me know what type of functionality you want.

Thanks,
Jayesh Goyani

[Mark Ferkaluk]

Hi,

I'm currently in insert mode. I have three fields (customer, value and units). Customer is text and value and units are numeric. Getting the customer value works, but both other values not. When I'm debugging there is no data in those RadNumeriTextBoxes.

Regards,
Mark

[Princy]

Hello Mark,

If you are using GridNumericColumn, it is rendered as RadNumericTextBox in insert and edit mode. Here is the sample code that I tried which worked as expected.
VB:

Protected Sub RadGrid1_InsertCommand(sender As Object, e As GridCommandEventArgs)
    Dim item As GridEditFormInsertItem = DirectCast(e.Item, GridEditFormInsertItem)
    Dim txt1 As RadNumericTextBox = DirectCast(item("Value").Controls(0), RadNumericTextBox)
    Dim val As String = txt1.Text
End Sub

Thanks,
Princy.

[Mark Ferkaluk]

Hello Princy,

I tried it that way, but like I said. It seems, that there is no value in it. Here my code again:

Dim insertedItem As GridEditFormInsertItem = TryCast(e.Item, GridEditFormInsertItem)

Dim customer As String = (TryCast(insertedItem("Customer").Controls(0), TextBox)).Text
Dim value As Double = (TryCast(insertedItem("Value").Controls(0), RadNumericTextBox)).Value
Dim units As Integer = (TryCast(insertedItem("Units").Controls(0), RadNumericTextBox)).Value

Strange thing is, I can get the customer value.

Regards,
Mark

[Jayesh Goyani]

Hello,

Are you able to get ALL columns(customer,value,Units)'s value or not ?

if no then please check below scenario and if you find this then remove(that binding Datasource code) from your code.
after click on "Insert" Button your grid was binding datasource again before coming in the insertcomand event.

Thanks,
Jayesh Goyani

[Mark Ferkaluk]

Hello Jayesh,

I'm only able to get the column Customer. When I try to get the values of the others, it is not possible, because there are no values (no .Text and no .Value). But I can access the RadNumericTextBox controls, there is just no value.

After I clicked insert, there is no databind. I use the Event NeedDataSource and it is not called after I click insert.

When I change the RadNumericTextBoxes into normal Bound Textboxes, everything works fine.

Regards.

[Jayesh Goyani]

Hello,

Please send your RadGrid's code so i can check it from my side.

Thanks,
Jayesh Goyani

[Mark Ferkaluk]

Hi,

here is all my code.

ASCX Markup

<telerik:RadGrid ID="RadGrid_customers" runat="server" AutoGenerateColumns="False" AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True" CellSpacing="0"
                                GridLines="Horizontal" Skin="Telerik" Width="450px" Culture="de-DE">
                                <MasterTableView CommandItemDisplay="Top"
                                    CommandItemSettings-AddNewRecordText="Add new customer">
                                    <commanditemsettings addnewrecordtext="Add new customer"
                                        exporttopdftext="Export to PDF" />
                                    <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">
                                        <HeaderStyle Width="20px" />
                                    </RowIndicatorColumn>
                                    <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">
                                        <HeaderStyle Width="20px" />
                                    </ExpandCollapseColumn>
                                    <Columns>
                                        <telerik:GridBoundColumn DataField="customer"
                                            FilterControlAltText="Filter Customer column" HeaderText="Customer"
                                            UniqueName="Customer">
                                        </telerik:GridBoundColumn>
                                        <telerik:GridNumericColumn DataField="value" DataType="System.Decimal"
                                            DecimalDigits="2" FilterControlAltText="Filter Value column"
                                            HeaderText="Value 2010" UniqueName="Value">
                                            <HeaderStyle HorizontalAlign="Right" />
                                            <ItemStyle HorizontalAlign="Right" />
                                        </telerik:GridNumericColumn>
                                        <telerik:GridNumericColumn DataField="units" DataType="System.Int64"
                                            DecimalDigits="0" FilterControlAltText="Filter Units column"
                                            HeaderText="Units 2010" UniqueName="Units">
                                            <HeaderStyle HorizontalAlign="Right" />
                                            <ItemStyle HorizontalAlign="Right" />
                                        </telerik:GridNumericColumn>
                                        <telerik:GridNumericColumn DataField="id" DataType="System.Int64"
                                            DecimalDigits="0" FilterControlAltText="Filter ID column" HeaderText="ID"
                                            ReadOnly="True" UniqueName="ID" Visible="False">
                                        </telerik:GridNumericColumn>
                                    </Columns>
                                    <EditFormSettings>
                                        <EditColumn FilterControlAltText="Filter EditCommandColumn column">
                                        </EditColumn>
                                    </EditFormSettings>
                                </MasterTableView>
                                <FilterMenu EnableImageSprites="False">
                                </FilterMenu>
                                <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default">
                                </HeaderContextMenu>
                            </telerik:RadGrid>

InsertCommand Event

Protected Sub RadGrid_customers_InsertCommand(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles RadGrid_customers.InsertCommand
        Dim topicnav As RadPanelItem = DirectCast(topic_navigation_cc.SelectedItem, RadPanelItem)
        Dim insertedItem As GridEditFormInsertItem = TryCast(e.Item, GridEditFormInsertItem)

        Dim customer As String = (TryCast(insertedItem("Customer").Controls(0), TextBox)).Text
        Dim value As String = (TryCast(insertedItem("Value").Controls(0), RadNumericTextBox)).Text
        Dim units As String = (TryCast(insertedItem("Units").Controls(0), RadNumericTextBox)).Text
End Sub

NeedDataSource Event

Protected Sub RadGrid_customers_NeedDataSource(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles RadGrid_customers.NeedDataSource
       Dim table_customers_work As DataTable
       Dim table_version As DataTable = getSQLData("SELECT years_cc FROM versions WHERE version = 'test'")

       table_customers_work = getSQLData("SELECT customer, value, units, id FROM customer_work WHERE topic_id = 1 AND assigned_version = 'test' AND country = 'test'")

       RadGrid_customers.DataSource = table_customers_work

       RadGrid_customers.MasterTableView.Columns(1).HeaderText = "Value " & table_version.Rows(0)(0).ToString
       RadGrid_customers.MasterTableView.Columns(2).HeaderText = "Units " & table_version.Rows(0)(0).ToString
   End Sub

Regards,
Mark

[Jayesh Goyani]

Hello,

i am successfully get values of column in your code.

Please create one page and put my code in to page and check its working or not?

<telerik:RadGrid ID="RadGrid_customers" runat="server" AutoGenerateColumns="False" AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True" CellSpacing="0"
                              GridLines="Horizontal" Skin="Telerik" Width="450px" Culture="de-DE">
                              <MasterTableView CommandItemDisplay="Top"
                                  CommandItemSettings-AddNewRecordText="Add new customer">
                                  <commanditemsettings addnewrecordtext="Add new customer"
                                      exporttopdftext="Export to PDF" />
                                  <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">
                                      <HeaderStyle Width="20px" />
                                  </RowIndicatorColumn>
                                  <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">
                                      <HeaderStyle Width="20px" />
                                  </ExpandCollapseColumn>
                                  <Columns>
                                      <telerik:GridBoundColumn DataField="customer"
                                          FilterControlAltText="Filter Customer column" HeaderText="Customer"
                                          UniqueName="Customer">
                                      </telerik:GridBoundColumn>
                                      <telerik:GridNumericColumn DataField="value" DataType="System.Decimal"
                                          DecimalDigits="2" FilterControlAltText="Filter Value column"
                                          HeaderText="Value 2010" UniqueName="Value">
                                          <HeaderStyle HorizontalAlign="Right" />
                                          <ItemStyle HorizontalAlign="Right" />
                                      </telerik:GridNumericColumn>
                                      <telerik:GridNumericColumn DataField="units" DataType="System.Int64"
                                          DecimalDigits="0" FilterControlAltText="Filter Units column"
                                          HeaderText="Units 2010" UniqueName="Units">
                                          <HeaderStyle HorizontalAlign="Right" />
                                          <ItemStyle HorizontalAlign="Right" />
                                      </telerik:GridNumericColumn>
                                      <telerik:GridNumericColumn DataField="id" DataType="System.Int64"
                                          DecimalDigits="0" FilterControlAltText="Filter ID column" HeaderText="ID"
                                          ReadOnly="True" UniqueName="ID" Visible="False">
                                      </telerik:GridNumericColumn>
                                  </Columns>
                                  <EditFormSettings>
                                      <EditColumn FilterControlAltText="Filter EditCommandColumn column">
                                      </EditColumn>
                                  </EditFormSettings>
                              </MasterTableView>
                              <FilterMenu EnableImageSprites="False">
                              </FilterMenu>
                              <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default">
                              </HeaderContextMenu>
                          </telerik:RadGrid>

Imports System.Data
Imports Telerik.Web.UI



Partial Class Default5
    Inherits System.Web.UI.Page

    Protected Sub RadGrid_customers_NeedDataSource(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles RadGrid_customers.NeedDataSource

        RadGrid_customers.DataSource = New DataTable

        RadGrid_customers.MasterTableView.Columns(1).HeaderText = "Value " & "123"
        RadGrid_customers.MasterTableView.Columns(2).HeaderText = "Units " & "456"
    End Sub


    Protected Sub RadGrid_customers_InsertCommand(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles RadGrid_customers.InsertCommand

        Dim insertedItem As GridEditFormInsertItem = TryCast(e.Item, GridEditFormInsertItem)

        Dim customer As String = (TryCast(insertedItem("Customer").Controls(0), TextBox)).Text
        Dim value As String = (TryCast(insertedItem("Value").Controls(0), RadNumericTextBox)).Text
        Dim units As String = (TryCast(insertedItem("Units").Controls(0), RadNumericTextBox)).Text
    End Sub


End Class

Thanks,
Jayesh Goyani