i'm having two different run time errors

Question

i get two run time errors first({"Sequence contains more than one element"} ==> System.InvalidOperationException ) when there is more than once it occurred and also when i want to delete what i wrote in my textbox what should i do?

here is my code

 private AutoCompleteStringCollection GetLinqDataSourceForString(string p)
    {
        var c = new AutoCompleteStringCollection();
        c.Add( Getauto(p));
        return c;
    }

   private void txtSearch_TextChanged(object sender, EventArgs e)
    {
        txtSearch.AutoCompleteSource = AutoCompleteSource.CustomSource;
        txtSearch.AutoCompleteMode = AutoCompleteMode.Suggest;
          txtSearch.AutoCompleteCustomSource = GetLinqDataSourceForString(txtSearch.Text);
      }

and this one is in another layer to get info from data Base

    public string AutoUpdate(string _search)
    {
        using (var context = new Phone_BookEntities1())
        {
            var c = (from d in context.Cantacts
                     where d.Cantact1.StartsWith(_search)
                     select d.Cantact1).SingleOrDefault();
            return c;
        }
    }

Probably where d.Cantact1.StartsWith(_search) is matching multiple items, hence Sequence contains more than one element. — Arghya C
– Arghya C, Commented Nov 13, 2015 at 10:07
stackoverflow.com/users/265419/james-barrass public string GetAutoupdate(string _search) { Ref_Model = new Model._Model(); return Ref_Model.AutoUpdate(_search); } #endreg — Mostafa Bouzari
– Mostafa Bouzari, Commented Nov 13, 2015 at 10:09

Aditya Santoso · Accepted Answer · 2015-11-13 10:08:36Z

6

SingleOrDefault will throw if your sequence has more than one element. If your intention is to get the first matching contact in your table, use FirstOrDefault instead.

answered Nov 13, 2015 at 10:08

Aditya Santoso

1,0817 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

i'm having two different run time errors

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related