[Solved] multi-item radcombobox does not work

[noyan]

I got a radcombobox and I use autocomplete features it works for single item well but when I set Autocompleteseperator property it didnt work. radcombobox and the server code which I used for autocomplete features given below all help will be appreciated.

<telerik:RadComboBox ID="cmbUnvan" Runat="server" AllowCustomText="True"
 AutoPostBack="True" EnableLoadOnDemand="True"
onitemsrequested="cmbUnvan_ItemsRequested" Height="73px" Width="230px"
AutoCompleteSeparator=";" MarkFirstMatch="True">
<CollapseAnimation Duration="200" Type="OutQuint" />
</telerik:RadComboBox>


    protected void cmbUnvan_ItemsRequested(object o, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
    {
        RadComboBox combo = (RadComboBox)o;
        combo.Items.Clear();

        SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Personelcon"].ConnectionString);

        string text = e.Text;
        string sql = "SELECT * from Unvan WHERE Uname LIKE '" + text.Replace("'", "''") + "%'";

        SqlCommand selectCommand = new SqlCommand(sql, connection);
        SqlDataAdapter adapter = new SqlDataAdapter(selectCommand);
        DataTable dt = new DataTable();
        adapter.Fill(dt);

        foreach (DataRow row in dt.Rows)
        {
            RadComboBoxItem item = new RadComboBoxItem(row["Uname"].ToString());
            item.Value = row["Uid"].ToString();
            //item.Text = Convert.ToString(row["Uname"]);
            combo.Items.Add(item);
        }
    }

[Shinu]

Hi Noyan,

Try the following code snippet and see whether it is working fine.

CS:

protected void cmbUnvan_ItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e)
{
    RadComboBox combo = (RadComboBox)o;
    if (e.Text.Contains(";"))
    {
        String temp = e.Text.ToString();
        int index = temp.LastIndexOf(";");
        text = temp.Substring(index + 1);
    }
    else
    {
        text = e.Text;
    }
    SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Personelcon"].ConnectionString);
    string sql = "SELECT * from Unvan WHERE Uname LIKE '" + text.Replace("'", "''") + "%'";
    SqlCommand selectCommand = new SqlCommand(sql, connection);
    SqlDataAdapter adapter = new SqlDataAdapter(selectCommand);
    DataTable dt = new DataTable();
    adapter.Fill(dt);
    foreach (DataRow row in dt.Rows)
    {
        RadComboBoxItem item = new RadComboBoxItem(row["Uname"].ToString());
        item.Value = row["Uid"].ToString();
        //item.Text = Convert.ToString(row["Uname"]);
        combo.Items.Add(item);
    }
}

JavaScript:

<script type="text/javascript">
function pageLoad()
{
    var combo = $find("<%= cmbUnvan.ClientID %>");
    if(combo.get_text() != "")
    {
        combo.set_text(combo.get_text()+';');
    }
}
</script>

Thanks,
Shinu.