Object reference not set to an instance of an object in linq to sql

Question

When running the following code I get the exception "System.Nullreferenceexception:object reference not set to an instance of an object". I believe it has something to with not initializing the allStudents variable but I'm not sure what type allStudents is.

Any help is appreciated

    private void showStudents(string c)
    {
        try
        {
            using (SMDataClassesDataContext db = new SMDataClassesDataContext())
            {

                var allStudents = from t in db.tbl_students
                                  where t.current_class == c
                                  select t;
              dgViewStudents.ItemsSource = allStudents;
            }
        }
        catch (Exception e)
        {
            MessageBox.Show(e.ToString());
        }
    }

allStudents won't be the problem. Have you used the debugger? What variable is null? — Jeroen Vannevel
– Jeroen Vannevel, Commented Sep 7, 2013 at 18:06
As a side-note, if you're ever unsure about the type of a var, hover the mouse over it, and Intellisense will tell you what type it is, if it can. — Chris Mantle
– Chris Mantle, Commented Sep 7, 2013 at 18:08
the message disappeared when I write dgViewStudents = new DataGrid(); However, the data is no longer loaded to dgViewStudents like this. — Monty Swanson
– Monty Swanson, Commented Sep 7, 2013 at 18:11
If you're using winforms, be sure to let the InitializeComponent -method get called before trying to access the components from your own code. — bobblez
– bobblez, Commented Sep 7, 2013 at 18:14

Monty Swanson · Accepted Answer · 2013-09-08 09:45:10Z

1

I managed to solve the problem. Adding a check for null values solved the problem like this:

   if (dgViewStudents != null)
                    dgViewStudents.ItemsSource = allStudents.ToList();

answered Sep 8, 2013 at 9:45

Monty Swanson

7951 gold badge19 silver badges47 bronze badges

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

Comments

phil · Accepted Answer · 2013-09-07 19:02:55Z

0

You need to force the evaluation of your query and set it up as a DataSource for your DataGridView....assuming the dgViewStudents variable itself is not null and that the allStudents query brings back results, this should work I think.

var bindingSource = new BindingSource();
var allStudents = from t in db.tbl_students
                  where t.current_class == c
                  select t;
bindingSource.DataSource = allStudents.ToList();
dgViewStudents.DataSource = bindingSource;

edited Sep 7, 2013 at 19:02

answered Sep 7, 2013 at 18:14

phil

9691 gold badge10 silver badges20 bronze badges

2 Comments

phil Over a year ago

Doesn't it also need to be DataSource that is set? See edited answer.

Monty Swanson Over a year ago

unfortunately, the result is still the same.

Collectives™ on Stack Overflow

Object reference not set to an instance of an object in linq to sql

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related