New to Telerik UI for ASP.NET AJAX? Download free 30-day trial

Binding to DataTable

RadSearchBox can be bound to a DataTable, DataSet and DataView objects. The following example shows binding to a DataTable object.

Binding to a DataTable at runtime

The declaration of RadSearchBox in the markup does not include DataSourceID property.

<telerik:RadSearchBox RenderMode="Lightweight" runat="server" ID="RadSearchBox1" >
    <DropDownSettings Height="400" Width="300" />

In the Page_Load event handler, create and fill the DataTable object, then setting the DataSource property.

protected void Page_Load(object sender, EventArgs e)
    RadSearchBox1.DataSource = GetData();
    RadSearchBox1.DataTextField = "ProductName";
    RadSearchBox1.DataValueField = "ProductID";

private static DataTable GetData()
    SqlDataAdapter adapter = new SqlDataAdapter(@"SELECT [ProductID], [ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], 
    [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued] FROM [Products]",

    DataTable data = new DataTable();

    return data;

Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
    RadSearchBox1.DataSource = GetData()
    RadSearchBox1.DataTextField = "ProductName"
    RadSearchBox1.DataValueField = "ProductID"
End Sub

Private Shared Function GetData() As DataTable
    Dim adapter As New SqlDataAdapter("SELECT * FROM [Products]", ConfigurationManager.ConnectionStrings("NorthwindConnectionString").ConnectionString)

    Dim data As New DataTable()

    Return data
End Function

In this article