Can't bind data to DropDownList - NullReferenceException

Question

I am trying to bind data to a DropDownList that I created using the <asp:DropDownList tag. It successfully works for the first DropDownList, but an exception is thrown for the remaining two. I know that the data source is not null and does indeed have values, so the only thing I can think of is that the other two list boxes have not yet been loaded or bound.

I attempted to use the Page_LoadComplete method to add the content, but it doesn't seem to be firing. I'm used to MVC and I'm very new to Web Forms, so I'm not sure what I am doing wrong. Am I correct by stating that the elements have not yet been loaded, and if so how do I bind them once they are loaded?

protected void Page_Load(object sender, EventArgs e)
    {
        //Page.LoadComplete += new EventHandler(Page_LoadComplete);
        if (DataContext == null)
        {
            DataContext = new ReuseLibraryDataContext(SPContext.Current.Web.Url);
        }

        // top level category for all documents
        _functions = DataContext.ReuseLibrary.Select(p => p.FunctionalCategories).Distinct().ToList();

        // the first sub category
        _sc1 = DataContext.ReuseLibrary.Select(p => p.SubCategoriesLevel1).Distinct().ToList();

        // the second sub category
        _sc2 = DataContext.ReuseLibrary.Select(p => p.SubCategoriesLevel2).Distinct().ToList();


        // add the functions to the dropdown
        listFunctions.DataSource = _functions;
        listFunctions.DataBind();

        // add the sub cat 1 to the dropdown
        listSC1.DataSource = _sc1;
        listSC1.DataBind();

        // add the sub cat 2 to the dropdown
        listSC2.DataSource = _sc2;
        listSC2.DataBind();
    }

    //protected void Page_LoadComplete(object sender, EventArgs e)
    //{
    //    // add the functions to the dropdown
    //    listFunctions.DataSource = _functions;
    //    listFunctions.DataBind();

    //    // add the sub cat 1 to the dropdown
    //    listSC1.DataSource = _sc1;
    //    listSC1.DataBind();

    //    // add the sub cat 2 to the dropdown
    //    listSC2.DataSource = _sc2;
    //    listSC2.DataBind();
    //}

Almost all cases of NullReferenceException are the same. Please see "What is a NullReferenceException in .NET?" for some hints. — John Saunders
– John Saunders, Commented Sep 20, 2013 at 19:04

Cody · Accepted Answer · 2013-09-20 19:01:58Z

3

I feel dumb - but I'll post what the issue was in case anyone else gets caught by something like this.

Even though I was supplying a list of data, any null objects in that list will also throw a NullReferenceException. Quite understandable.

To solve I removed the null values, and viola. Works as expected.

_sc1.RemoveAll(item => item == null);
_sc2.RemoveAll(item => item == null);

I ended up updating the query to exclude null values:

_sc1 = DataContext.ReuseLibrary.Select(p => p.SubCategoriesLevel1).Where(p => p != null).Distinct().ToList();

edited Sep 20, 2013 at 19:01

answered Sep 20, 2013 at 18:54

Cody

9,00419 gold badges75 silver badges128 bronze badges

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

Collectives™ on Stack Overflow

Can't bind data to DropDownList - NullReferenceException

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related