[Solved] RadComboBox outside RadGrid

[Simone]

Hello ...
I have a combobox outside a RadGrid and I have to take the selected value and insert it in record.

I tried to use insertcommand but I don't know how to refer to the value.

With the normal asp.net controls it was quite easy ...

I wrote a code for Iteminserting event:

e.values("fieldName") = myValue ...

Now, I am disoriented ...


Thanks

[Princy]

Hi Simone,

Please try the sample code snippet.Let me know if any concern.

ASPX:

<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="false" OnInsertCommand="RadGrid1_InsertCommand">
    <MasterTableView CommandItemDisplay="Top">
      . . .
    </MasterTableView>
</telerik:RadGrid>

<telerik:RadComboBox ID="RadComboBox1" runat="server" DataSourceID="SqlDataSource2" DataTextField="ShipCountry" DataValueField="ShipCountry" >
</telerik:RadComboBox>
 <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:Northwind_newConnectionString3 %>"
 SelectCommand="SELECT distinct ShipCountry FROM [Orders]"></asp:SqlDataSource>

C#:

protected void RadGrid1_InsertCommand(object sender, GridCommandEventArgs e)
    {
     string value= RadComboBox1.SelectedValue; //Access the selected value of the RadComboBox
    }

Thanks,
Princy

[Simone]

Yes ... this is perfect to retrieve the value from ComboBox ...

but ... how to insert this value in record ??

"e.values" does not work ...

[Princy]

Hi Simone,

Please try the sample code snippet that shows how to insert a value from RadComboBox.

ASPX:

<telerik:RadGrid ID="RadGrid1" runat="server" OnNeedDataSource="RadGrid1_NeedDataSource" AllowPaging="true" OnInsertCommand="RadGrid1_InsertCommand">
   <MasterTableView DataKeyNames="OrderID" CommandItemDisplay="Top">
      <Columns>
         <telerik:GridBoundColumn HeaderText="OrderID" DataField="OrderID" ReadOnly="false" UniqueName="OrderID" />
         <telerik:GridBoundColumn HeaderText="EmployeeID" DataField="EmployeeID" UniqueName="EmployeeID">
      </Columns>
   </MasterTableView>
 </telerik:RadGrid>
<telerik:RadComboBox ID="RadComboBox1" runat="server" DataSourceID="SqlDataSource2" DataTextField="ShipCountry" DataValueField="ShipCountry" >
</telerik:RadComboBox>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:Northwind_newConnectionString3 %>"
SelectCommand="SELECT distinct ShipCountry FROM [Orders]"></asp:SqlDataSource>

C#:

public static string connection = WebConfigurationManager.ConnectionStrings["Northwind_newConnectionString3"].ConnectionString;
SqlConnection conn = new SqlConnection(connection);
protected void RadGrid1_InsertCommand(object sender, GridCommandEventArgs e)
    {
        if (e.Item is GridEditableItem )
        {
            string value = RadComboBox1.SelectedValue;
            GridEditableItem edit = (GridEditableItem)e.Item;
            TextBox tx=(TextBox)edit["OrderID"].Controls[0];
            TextBox txt = (TextBox)edit["EmployeeID"].Controls[0];
            conn.Open();
            string query = "INSERT into Orders (OrderID,EmployeeID,ShipCountry ) VALUES ('" + tx.Text + "','" + txt.Text + "','"+value+"')";
            SqlCommand cmd = new SqlCommand(query, conn);
            cmd.ExecuteNonQuery();
            conn.Close();
        }
    }

Thanks,
Princy

[Simone]

so I have to insert every field manually not limiting to the one provided by combobox ??

[Konstantin Dikov]

Hello Simone,


Since I am not able to fully understand your exact requirement, could you please provide more information.

Nevertheless, if you want to change the entered value from the insert form depending on the selected value from the RadComboBox, you could handle the "ItemCommand" server-side event of the grid, get reference of the editor control for a column and change the value. Here is how you could achieve this:

protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
    if (e.CommandName == "PerformInsert")
    {
        GridEditFormInsertItem editForm = (GridEditFormInsertItem)e.Item;

        //Get the insert control for specific column and change the value
        (editForm["CategoryName"].Controls[0] as TextBox).Text += RadComboBox1.SelectedValue;
    }
}

Hope that helps.


Regards,
Konstantin Dikov
Telerik

[Simone]

Many thanks for your answer ... I am evaluating your product and I am trying to substitute standard gridview with rad one.

Using classic  listview I used this code to insert a specific value into a field, when inserting a record.

I would like how to programmatically enter a value in DB like I did in this example:

Protected Sub myLV_ItemInserting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ListViewInsertEventArgs) Handles myLV.ItemInserting

 

 e.Values("myField") = myValue


[Simone]

any helps ??

[Konstantin Dikov]

Hi Simone,

For the RadListView you could use the following approach in order to manipulate the input data on insert:
VB:

Protected Sub RadListView1_ItemCommand(sender As Object, e As RadListViewCommandEventArgs)
    If e.CommandName = "PerformInsert" Then
        TryCast(e.ListViewItem.FindControl("TextBox1"), TextBox).Text = "new value"
    End If
End Sub

C#:

protected void RadListView1_ItemCommand(object sender, RadListViewCommandEventArgs e)
{
    if (e.CommandName == "PerformInsert")
    {
        (e.ListViewItem.FindControl("TextBox1") as TextBox).Text = "new value";
    }
}

Hope that helps.

 

Regards,
Konstantin Dikov
Telerik

[Simone]

Can I use this with GridView too ??

[Konstantin Dikov]

Hello Simone,

For your last question you could refer to this help article that demonstrates ways to access cells and rows in RadGrid. 

For general questions regarding our controls you could refer to our online help articles, where detail information is available for all RadControls.

Hope that helps.

 

Regards,
Konstantin Dikov
Telerik