Data binding with combobox

Question

Hi, How to bind data with ComboBox in silverlight. Thanks, in advance

Priya Linge · Answer

Hi, MainPage.Xaml : We have Combobox Service.svc.cs : Select CustomerName from Customer Table as below, [ServiceContract(Namespace = "")] [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)] public class Service1 { SqlConnection con = new SqlConnection("Data Source= TFServer\;Initial Catalog=Pub4;Persist Security Info=True;User ID=trustfort;Password=Admin@123"); SqlDataReader dr; List list = new List (); [OperationContract] public List data() { con.Open(); string qry = "select Name from Customer"; SqlCommand cmd = new SqlCommand(qry, con); dr = cmd.ExecuteReader(); while (dr.Read()) { list.Add(dr[0].ToString()); } con.Close(); return list.ToList(); } } Here we return list of customer names ,those names we are going to bind the Combobox as below, public partial class MainPage : UserControl { List items = new List (); public MainPage() { InitializeComponent(); getdata(); } public void getdata() { ServiceReference1.Service1Client service = new ServiceReference1.Service1Client(); service.dataCompleted += new EventHandler (service_dataCompleted); service.dataAsync(); } void service_dataCompleted(object sender, ServiceReference1.dataCompletedEventArgs e) { items = e.Result.ToList(); for (int i = 0; i { comboBox1.Items.Add(items[i].ToString()); // Here we add names in combobox. } } } } Please see attached file. Hope this will help you. Thanks.

Data binding with combobox

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (1)