<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>

<telerik:RadComboBox runat="server" ID="ddlSponsor" Height="190px" Width="340px"
                                        MarkFirstMatch="true" DataSourceID="SessionDataSource1" EnableLoadOnDemand="true"
                                        HighlightTemplatedItems="true" OnClientItemsRequested="UpdateItemCountField"
                                        OnDataBound="RadComboBox1_DataBound" OnItemDataBound="RadComboBox1_ItemDataBound"
                                        OnItemsRequested="RadComboBox1_ItemsRequested" DropDownCssClass="exampleRadComboBox">
                                        <HeaderTemplate>
                                            <ul>
                                                <li class="col1">Consultant Id</li>
                                                <li class="col2">Name</li>                                
                                            </ul>
                                        </HeaderTemplate>
                                        <ItemTemplate>
                                            <ul>
                                                <li class="col1">
                                                    <%# DataBinder.Eval(Container.DataItem, "ConsultantId") %></li>
                                                <li class="col2">
                                                    <%# DataBinder.Eval(Container.DataItem, "consultant_name") %></li>                                
                                             </ul>
                                        </ItemTemplate>
                                        <FooterTemplate>
                                            Sponsors Listing 
                                            <asp:Literal runat="server" ID="RadComboItemsSelected" />                
                                        </FooterTemplate>
                                </telerik:RadComboBox>   
                                <asp:SqlDataSource ID="SessionDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:sql_connection %>"  
                                        SelectCommand="SELECT ConsultantId,dbo.FirstCap(fname+', '+lname) as consultant_name FROM [Consultants] WHERE YEAR(DATEADD(YEAR,1, IntroDate))>=YEAR(getdate())"></asp:SqlDataSource>        
                                        <telerik:RadScriptBlock ID="RadScriptBlock1" runat="server">
                                            <script type="text/javascript">
                                                    function UpdateItemCountField(sender, args) {
                                                            //Set the footer text.
                                                        sender.get_dropDownElement().lastChild.innerHTML = "Select or type the name of the sponsor ";  //-+ sender.get_items().get_count() + " items";
                                                    }
                                            </script>
                                        </telerik:RadScriptBlock>         

using Telerik.Web.UI;

//- Change the code as needed

 protected void RadComboBox1_DataBound(object sender, EventArgs e)
    {
        //set the initial footer label        
        ((Literal)ddlSponsor.Footer.FindControl("RadComboItemsSelected")).Text = ddlSponsor.SelectedValue;
    }
    protected void RadComboBox1_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e)
    {
        //-get all consultants whose name starts with e.Text        
        string sql = "SELECT ConsultantId,dbo.FirstCap(fname+', '+lname) as consultant_name,telephone FROM [Consultants] WHERE LNAME LIKE '" + e.Text + "%'";
        SessionDataSource1.SelectCommand = sql;
        ddlSponsor.DataBind();
    }
    protected void RadComboBox1_ItemDataBound(object sender, RadComboBoxItemEventArgs e)
    {
        //set the Text and Value property of every item
        //here you can set any other properties like Enabled, ToolTip, Visible, etc.
        e.Item.Text = ((DataRowView)e.Item.DataItem)["Consultant_Name"].ToString();
        e.Item.Value = ((DataRowView)e.Item.DataItem)["ConsultantId"].ToString();
    }
    protected void OnSelectedStates_Changed(object sender, EventArgs e)
    {
        if (ddlUnitedStates.Text.Trim() != "XX")
        {
            PopulateSponsorListing(sender, e);            
        }
    }