title: How to retrieve and bind data to ListBox from SQLCe Db
body: <p>I have inserted the data into the SqlCe Database with the below code:</p>
  
  <pre>
  
  using (DBContacts context = new DBContacts(ConnectionString))
              {
                  TblContacts tblCtc = new TblContacts();
  
                  tblCtc.FirstName = txtBoxFirstNm.Text;
                  tblCtc.LastName = txtBoxLastNm.Text;
                  tblCtc.Mobile1 = txtMobile1.Text;
                  tblCtc.Email1 = txtEmail1.Text;
  
                  context.TblContacts.InsertOnSubmit(tblCtc);
                  context.SubmitChanges();
  
                  MessageBox.Show("Inserted Ok.");
  
  
              }
  </pre>
  
  <p>Questions:</p>
  
  <p>1) How do I use select from Linq To SQL and display the retrieved data ?</p>
  
  <pre>
  
   using (DBContacts context = new DBContacts(ConnectionString))
              {
                IEnumerable  ctc = from c in context.TblContacts select c;   
  
  
          // what to get the result and display ??
  
                 // txtBlkFirstname.Text =   ctc.FirstName  ??
                 // txtBlkLastname.Text = ctc.LastName    ??
                 .....     
  
              }
  </pre>
  
  <p>1a) Which to use ? IQueryable or IEnumerable?</p>
  
  <p>1b) What does Select-statement return?  How to handle the data-return?</p>
  
  <p>1c) How to get the data out from Iqueryable or IEnumerable and assign values to the TextBlock controls?</p>
  
  <p>------ How to bind the data to the ListBox 
  
         
                      
               
                      
                  
     </p>