Re:How to bind ListBox in silverlight3 with items from DB

Service.svc.cs  :

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;
        SqlCommand cmd;

        [OperationContract]
        public List Getcustomerdata()
        {
            List list = new List();
            con.Open();
            string query = "select ID,Name from Customer";
            cmd = new SqlCommand(query, con);
            dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                var trn = new Customer
                {
                    Cus_ID = Convert.ToInt32(dr[0]),
                    Cus_name = dr[1].ToString()
                };

                list.Add(trn);
            }

            return list;
        }

        // Add more operations here and mark them with [OperationContract]
    }

Class Customer :

namespace listbindinsl3.Web
{
    public class Customer
    {

        private string _name;
        private Int32 _cusID;

        public string Cus_name
        {
            get { return _name; }
            set { _name = value; }
        }
        public Int32 Cus_ID
        {
            get { return _cusID; }
            set { _cusID = value; }
        }
    }

MainPage.xaml  :

                              SelectionMode="Extended" Margin="10"  >
           
               
                   
                        Cus_name}" Margin="5" Foreground="Black">
                   
               
           
       

MainPage.xaml.cs  :

        public MainPage()
        {
            InitializeComponent();
         
            getdata();
        }

        public void getdata()
        {
            ServiceReference1.Service1Client ser = new listbindinsl3.ServiceReference1.Service1Client();
            ser.GetcustomerdataCompleted += new EventHandler(ser_GetcustomerdataCompleted);
            ser.GetcustomerdataAsync();
        }

        void ser_GetcustomerdataCompleted(object sender, listbindinsl3.ServiceReference1.GetcustomerdataCompletedEventArgs e)
        {
           ListBox2.ItemsSource = e.Result;
         
        }
}

Hope this will help you.

Thanks.