Multiple Selection of radcombobox

[Edd]

Good day,
please am using a radcombobox that allows for multiple selection.
My problem is how can i insert the selected items into a database one by one.
Can someone please help me
thank you

[Shinu]

Hi Edd,

Please have a look into the code snippet to insert the Selected Item of RadComboBox into DataBase on RadButton OnClick event.

ASPX:

<telerik:RadComboBox ID="RadComboBox1" runat="server" CheckBoxes="true">
    <Items>
        <telerik:RadComboBoxItem Text="Australia" runat="server" />
        <telerik:RadComboBoxItem Text="Austria" runat="server" />
        <telerik:RadComboBoxItem Text="Bahrain" runat="server" />
        <telerik:RadComboBoxItem Text="Bangladesh" runat="server" />
        <telerik:RadComboBoxItem Text="Belgium" runat="server" />
        <telerik:RadComboBoxItem Text="Bhutan" runat="server" />
    </Items>
</telerik:RadComboBox>
<telerik:RadButton ID="RadButton1" runat="server" Text="Get Selected Item" OnClick="RadButton1_Click">
</telerik:RadButton>

C#:

protected void RadButton1_Click(object sender, EventArgs e)
{
    foreach (RadComboBoxItem item in RadComboBox1.Items)
    {
        if (item.Checked == true)
        {
            String connstring = WebConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;
            SqlConnection conn = new SqlConnection(connstring);
            conn.Open();
            SqlCommand cmd = new SqlCommand("insert into CountryTable (CountryName) values('" + item.Text + "')", conn);
            cmd.ExecuteNonQuery();
            conn.Close();
        }
    }
    Response.Write("<script>alert('Inserted')</script>");
}

Thanks,
Shinu.

[Luis]

And how can I get the items from a column in a SQL Server table? 

Luis

[Doncho]

Hi Luis,

You can check out the different DataSources that can be used for binding data to the RadComboBox in the Data Binding Overview | RadComboBox article.

Note that the RadComboBox uses a DataSource and has no direct relation to the SQL database itself.

Here is a sample of binding a single column DataTable to the RadComboBox

VB code:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not IsPostBack Then
        Dim connstring As String = WebConfigurationManager.ConnectionStrings("NorthwindConnectionString").ConnectionString
        Dim conn As SqlConnection = New SqlConnection(connstring)
        Dim myCommand As SqlDataAdapter = New SqlDataAdapter("SELECT DISTINCT [Country] FROM [Customers]", conn)
        
        Dim dt As DataTable = New DataTable()
        myCommand.Fill(dt)

        RadComboBox1.DataSource = dt
        RadComboBox1.DataTextField = "Country"
        RadComboBox1.DataValueField = "Country"
        RadComboBox1.DataBind()
    End If

I hope this will prove helpful!

Kind regards,
Doncho
Progress Telerik