Search in LINQ to SQL

Question

hi

I want to Search in my Table. I write follow Code :

var w = from act in Movie_List.Actors
                     where act.Actor_Name == Snametxt.Text
                     select new {act.Actor_Name};
Acttxt.Text= w.SingleOrDefault().Actor_Name;

this code work only for FIRST search and when I want to search again , appear exception .

Exception :

Object reference not set to an instance of an object.

I don't know how to solve this problem.

help me please.

Answer 1

1. What is the exception?
2. Changing the primary key is really bad, mmkay, k.

Answer 2

I could solve problem finally.

you must remove binding after binding data .

            try
            {
                Acttxt.DataBindings.RemoveAt(0);
            }
            catch
            {

            }

before bind control too database write this code for any control.

Answer 3

you gotta first check to see if w contains any element :

var w = from act in Movie_List.Actors
                     where act.Actor_Name == Snametxt.Text
                     select new {act.Actor_Name};
if (w.Any())
   Acttxt.Text= w.SingleOrDefault().Actor_Name;