Edit this page

Binding to DataTable, DataSet, or DataView

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

Binding to a DataTable at runtime

The declaration of RadAutoCompleteBox in the markup includes no DataSourceID property or Items section.

<telerik:RadAutoCompleteBox RenderMode="Lightweight" ID="RadAutoCompleteBox1" InputType="Text" runat="server">
</telerik:RadAutoCompleteBox>

In the Page_Load event handler, create and fill the DataTable object, then bind it to RadAutoCompleteBox. The DataBind method must be called after setting the DataSource property.

protected void Page_Load(object sender, EventArgs e)
{
    if (Page.IsCallback)
    {
        RadAutoCompleteBox1.DataSource = GetData();
        RadAutoCompleteBox1.DataTextField = "ProductName";
        RadAutoCompleteBox1.DataValueField = "ProductID";
    }
}

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

    DataTable data = new DataTable();
    adapter.Fill(data);

    return data;
}   
Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
    If Page.IsCallback Then
        RadAutoCompleteBox1.DataSource = GetData()
        RadAutoCompleteBox1.DataTextField = "ProductName"
        RadAutoCompleteBox1.DataValueField = "ProductID"
    End If
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()
    adapter.Fill(data)

    Return data
End Function

See Also

Is this article helpful? No Yes
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article

close
Dummy