# Binding to ASP DataSource Components

**RadSearchBox** supports binding to all ASP.NET DataSource components, including:

* SqlDataSource

* XmlDataSource

* ObjectDataSource

* EntityDateSource

* LinqDataSource

To bind RadSearchBox to a DataSource component, you need to set its **DataSourceID** property to the ID of the DataSource component. You should also set its **DataTextField** and **DataValueField** properties to map the **Text** and **Value** properties of the items to the respective columns or fields from the data source.

You can also set the **DataKeyNames** property to add additional fields from the data source that you will need in the DataItem object for your scenario.

## SqlDataSource

Here is a sample that shows how to achieve binding with SqlDataSource.

```ASPNET
<telerik:RadSearchBox RenderMode="Lightweight" runat="server" ID="RadSearchBox1" 
	DataSourceID="SqlDataSource1"
	DataValueField="ProductId"
	DataTextField="ProductName">
	<DropDownSettings Height="400" Width="300" />
</telerik:RadSearchBox>

<asp:SqlDataSource ID="SqlDataSource2" runat="server" 
	ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>" 
	SelectCommand="SELECT * FROM [Products]">
</asp:SqlDataSource>
```

## LinqDataSource

Here is a sample that shows how to achieve binding with LinqDataSource.

```ASPNET
<asp:LinqDataSource runat="server" ID="LinqDataSource1" ContextTypeName="LinqToSqlReadOnly.NorthwindReadOnlyDataContext"
	OrderBy="ContactName" Select="new (ContactName, City, ContactTitle)" TableName="Customers">
</asp:LinqDataSource>

 <telerik:RadSearchBox RenderMode="Lightweight" runat="server" ID="RadSearchBox2"  EmptyMessage="Linq"
	DataSourceID="LinqDataSource1" DataValueField="ContactName"
	DataTextField="City">
	<DropDownSettings Height="400" Width="300" />
</telerik:RadSearchBox>
	       
```

## EntityDateSource

Here is a sample how to doe how to achieve it with EntityDateSource.

```ASPNET
<asp:EntityDataSource ID="EntityDataSource1" runat="server" ConnectionString="name=NorthwindEntities35"
	DefaultContainerName="NorthwindEntities35" EntitySetName="Customers" Select="it.[ContactName], it.[City], it.[ContactTitle]"
	AutoPage="true" OrderBy="it.[ContactName]">
</asp:EntityDataSource>
<telerik:RadSearchBox RenderMode="Lightweight" runat="server" ID="RadSearchBox3"  EmptyMessage="Entity"
	DataSourceID="EntityDataSource1" DataValueField="ContactName"
	DataTextField="City">
	<DropDownSettings Height="400" Width="300" />
</telerik:RadSearchBox>
```

## ObjectDateSource

Here is a sample that shows how to achieve binding with ObjectDateSource.

```ASPNET
<telerik:RadSearchBox RenderMode="Lightweight" runat="server" ID="RadSearchBox4"  EmptyMessage="Object"
	DataSourceID="ObjectDataSource1" DataValueField="ID"
	DataTextField="Text">
	<DropDownSettings Height="400" Width="300" />
</telerik:RadSearchBox>
<asp:ObjectDataSource ID="ObjectDataSource1" TypeName="SearchBoxDataObject" SelectMethod="GetItems"
	runat="server"></asp:ObjectDataSource>
	
```

```C#
	
public class SearchBoxDataObject
{
	public SearchBoxDataObject() { }
	public static List<SearchBoxDataItem> GetItems()
	{
		List<SearchBoxDataItem> itemsList = new List<SearchBoxDataItem>();
		itemsList.Add(new SearchBoxDataItem(1, "item 1"));
		itemsList.Add(new SearchBoxDataItem(2, "item 2"));
		itemsList.Add(new SearchBoxDataItem(3, "item 3"));
		return itemsList;
	}
	public class SearchBoxDataItem
	{
		private string _text;
		private int _id;
		public string Text
		{
			get
			{
				return _text;
			}
			set
			{
				_text = value;
			}
		}
		public int ID
		{
			get
			{
				return _id;
			}
			set
			{
				_id = value;
			}
		}
		public SearchBoxDataItem(int id, string text)
		{
			_id = id;
			_text = text;
		}
	}
}
	
```

```VB.NET
	
Public Class SearchBoxDataObject
	Public Sub New()
	End Sub
	Public Shared Function GetItems() As List(Of SearchBoxDataItem)
		Dim itemsList As New List(Of SearchBoxDataItem)()
		itemsList.Add(New SearchBoxDataItem(1, "item 1"))
		itemsList.Add(New SearchBoxDataItem(2, "item 2"))
		itemsList.Add(New SearchBoxDataItem(3, "item 3"))
		Return itemsList
	End Function
	Public Class SearchBoxDataItem
		Private _text As String
		Private _id As Integer
		Public Property Text() As String
			Get
				Return _text
			End Get
			Set(value As String)
				_text = value
			End Set
		End Property
		Public Property ID() As Integer
			Get
				Return _id
			End Get
			Set(value As Integer)
				_id = value
			End Set
		End Property
		Public Sub New(id As Integer, text As String)
			_id = id
			_text = text
		End Sub
	End Class
End Class
	
	
```

## XMLDataSource

Here is a sample that shows how to achieve binding with XMLDataSource.

```ASPNET
<telerik:RadSearchBox RenderMode="Lightweight" runat="server" ID="RadSearchBox5"  EmptyMessage="XML"
	DataSourceID="XmlDataSource1" DataValueField="Value"
	DataTextField="Text">
	<DropDownSettings Height="400" Width="300" />
</telerik:RadSearchBox>
<asp:XmlDataSource ID="XmlDataSource1" runat="server" DataFile="~/ContentFile.xml"></asp:XmlDataSource>
```

```ASPNET
<items>
 <Item Text="New York" Value="1" />
 <Item Text="Paris" Value="2" />
 <Item Text="London" Value="3" />
</items>
```
