Tutorial - Data Binding The Combobox has a set of properties and methods that allow developers to bind the component with many types of objects from the .NET Framework.

Supported types ArrayList HashTable DataTable ObjectDataSource (.NET 2.0 only) SqlDataSource (.NET 2.0 only)

Examples

ArrayList

C#   VB.NET ArrayList arrListStates = new ArrayList(); arrListStates.Add("Alaska"); arrListStates.Add("California"); arrListStates.Add("New York"); cbo1.DataSource = arrListStates; cbo1.DataBind();   Dim arrListStates = new ArrayList() arrListStates.Add("Alaska") arrListStates.Add("California") arrListStates.Add("New York") cbo1.DataSource = arrListStates cbo1.DataBind()

HashTable

C#   VB.NET Hashtable hLang = new Hashtable(); hLang.Add("1", "ASP.NET"); hLang.Add("2", "C#"); hLang.Add("3", "VBNET"); cbo1.DataSource = hLang; cbo1.DataBind();   Dim hLang = new Hashtable() hLang.Add("1", "ASP.NET") hLang.Add("2", "C#") hLang.Add("3", "VBNET") cbo1.DataSource = hLang cbo1.DataBind()

DataTable

C#   VB.NET DataSet ds = new DataSet(); // load data from a database cbo1.DataSource = ds.Tables[0]; cbo1.DataBind();   Dim ds = new DataSet() ' load data from a database cbo1.DataSource = ds.Tables(0) cbo1.DataBind()

ObjectDataSource

<asp:ObjectDataSource ID="ods1" runat="server" SelectMethod="GetOptions" TypeName="CData"></asp:ObjectDataSource> <obout:Combobox id="cbo1" runat="server" DataSourceID="ods1"></obout:Combobox>

SqlDataSource

<asp:SqlDataSource ID="sqlDs" Runat="server" SelectCommand="SELECT option_id, text, icon FROM combobox" ConnectionString="<%$ ConnectionStrings:Obout %>" /> <obout:Combobox id="cbo1" runat="server" DataSourceID="sqlDs"></obout:Combobox>

Tip: If the Combobox is binded with a DataSet, ObjectDataSource or SqlDataSource then you should use the DataField_Value, DataField_Text and DataField_Icon properties to set the names of the columns you have in your database table. See also the DataBinding section from the Server side documentation page.

Please visit HOW-TO and Help page for any questions.

"I've scanned the Internet for ASP.NET controls and yours are *BY FAR* the most featured and attractive (not to mention they don't crash, unlike some others!). Building the site around your component suite gave us the competitive edge." Shane Mitchell University of Queensland (Australia)