how to get values from radgrid and pass as parameters?

[Darren]

Hi there, straight to it!

I have this

    protected void RadGrid1_ItemInserted(object source, Telerik.Web.UI.GridInsertedEventArgs e)
    {
        cknetispservicesDataContext db = new cknetispservicesDataContext();
        var insertData = db.spInsertData(param1, param2, param3);
    }

param1, param2, and param3 should be values that come from my radgrid.
It is RadGrid1_ItemInserted event so i've clicked Insert. When this insert event is fired i want to execute the stored procedure. The stored procedure needs to be passed the parameters from the radgrid, which i want to specify.
Hope i'm clear enough with my problem.

[Shinu]

Hi Darren,

You can access the newly inserted values in the ItemInserted event as shown below.

CS:

 protected void RadGrid1_ItemInserted(object source, Telerik.Web.UI.GridInsertedEventArgs e)
    {
        if ((e.Item is GridEditFormInsertItem) && (e.Item.OwnerTableView.IsItemInserted))
        {
            GridEditFormInsertItem editformItem = (GridEditFormInsertItem)e.Item;
            TextBox txtbx = (TextBox)editformItem["ProductName"].Controls[0];
            string strtxt = txtbx.Text;

        }
    }

Shinu

[peter]

that worked.
but now i've got a foreign key in my database and in my radGrid i have a combobox to select the options. This is giving me problems and i can't pass the parameter?

Keeps telling me that it can't bind the control bound by that name.

            GridEditFormInsertItem editformItem = (GridEditFormInsertItem)e.Item;
            TextBox txtbxClientId = (TextBox)editformItem["ClientId"].Controls[0];
            string ClientId = txtbxClientId.Text;

This is what my column looks like:

            <telerik:GridTemplateColumn HeaderText="Client"
                DataType="System.Int64" >
                    <EditItemTemplate>
                        <telerik:RadComboBox ID="RadComboBoxClientName" Runat="server"
                            DataSourceID="LinqDataSourceClient" DataTextField="ClientName"
                            DataValueField="ClientId" SelectedValue='<%# Bind("ClientId") %>'
                            Skin="Vista" Width="140px">
                            <CollapseAnimation Duration="200" Type="OutQuint" />
                        </telerik:RadComboBox>
                    </EditItemTemplate>

                    <ItemTemplate>
                        <%#Eval("tblClient.ClientName")%>
                    </ItemTemplate>
                </telerik:GridTemplateColumn>

Thank you for your time and help.

[Darren]

that worked.
but now i've got a foreign key in my database and in my radGrid i have a combobox to select the options. This is giving me problems and i can't pass the parameter?

Keeps telling me that it can't bind the control bound by that name.

            GridEditFormInsertItem editformItem = (GridEditFormInsertItem)e.Item;
            TextBox txtbxClientId = (TextBox)editformItem["ClientId"].Controls[0];
            string ClientId = txtbxClientId.Text;

This is what my column looks like:

            <telerik:GridTemplateColumn HeaderText="Client"
                DataType="System.Int64" >
                    <EditItemTemplate>
                        <telerik:RadComboBox ID="RadComboBoxClientName" Runat="server"
                            DataSourceID="LinqDataSourceClient" DataTextField="ClientName"
                            DataValueField="ClientId" SelectedValue='<%# Bind("ClientId") %>'
                            Skin="Vista" Width="140px">
                            <CollapseAnimation Duration="200" Type="OutQuint" />
                        </telerik:RadComboBox>
                    </EditItemTemplate>

                    <ItemTemplate>
                        <%#Eval("tblClient.ClientName")%>
                    </ItemTemplate>
                </telerik:GridTemplateColumn>

Thank you for your time and help.

(sorry bout the previous post my boss was still logged in and i didn't realise)