How to handle null exception for column values returned from controller in webgrid?

Question

I am developing an MVC application in which the Webgrid is used to show table columns. I have One primary table named Item and secondary table named Category. I am trying to bind Item table's columns into Webgrid of a View but getting exception inside webgrid while binding foreign table(Category) column.

Microsoft.CSharp.RuntimeBinder.RuntimeBinderException

Model

public class ItemModel   
{  
    public long id { get; set; }
    public Nullable<long> category_id { get; set; }          
    public virtual Category Category { get; set; }   
}

Controller

List<ItemModel> lstItemModel = new List<ItemModel>();
List<Item> lstItemss = db.Items.ToList();
lstItemss.ForEach(x =>
{
    ItemModel stuModel = new ItemModel();
    stuModel.id= x.id;
    stuModel.Category = x.Category;
    lstItemModel.Add(stuModel);
});
return View(lstItemModel);

View inside webgrid I have

dataGrid.Column("Category", "Category", format: (Item) => string.IsNullOrEmpty(Item.Category.name)?string.Empty:Item.Category.name)

You can see in the view I am handing null exception but still it generates exception in view for Item.Category.name where as Item.id gets bind without any issue.

Thanks a lot

in debug mode look the value of Item.Category, and then share with us — kgzdev
– kgzdev, Commented Feb 2, 2017 at 7:52
You not handling the case when Category is null - string.IsNullOrEmpty(Item.Category.name) will throw an exception if the value of Category is null because you cannot access the name proprty of null) — user3559349
– user3559349, Commented Feb 2, 2017 at 7:52

Aish Khan · Accepted Answer · 2017-02-02 08:17:27Z

1

Thanks for the comments guys. Resolved the issue with this change that worked like charm.

Instead of this

string.IsNullOrEmpty(item.Category.name)

use this

(item.Category!= null)

so finally my view modified to

dataGrid.Column("Category", "Category", format: (Item) => (Item.Category==null)?string.Empty:Item.Category.name),

answered Feb 2, 2017 at 8:17

Aish Khan

195 bronze badges

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

1 Comment

user3559349 Over a year ago

Or you could just do stuModel.Category = x.Category ?? new Category() and simplify the code in the view

Collectives™ on Stack Overflow

How to handle null exception for column values returned from controller in webgrid?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related