Preview
Name Surname Marital status Age Birthday Employed
Joe Crosswave Married 32 1/5/1992 False
Merry Lisel Widowed 41 5/6/1982
Henry Crux Single 29 11/19/1994 True
Cody Jurut 49 8/11/1974 False
Simon Scranton Single 34 10/10/1989
Leena Laurent Divorced 19 7/1/2004 False
Ode Cosmides Married 54 4/17/1970 True
Diandra Mizner Single 20 8/20/2003 False
Pete Cassel Married 23 3/13/2001 False
Nicky Tremblay Married 32 1/5/1992 True
Mary Cassel Married 24 7/10/1999 True
Preview
Name Surname Marital status Age Birthday Employed
Joe Crosswave Married 32 1/5/1992 False
Merry Lisel Widowed 41 5/6/1982
Henry Crux Single 29 11/19/1994 True
Cody Jurut 49 8/11/1974 False
Simon Scranton Single 34 10/10/1989
Leena Laurent Divorced 19 7/1/2004 False
Ode Cosmides Married 54 4/17/1970 True
Diandra Mizner Single 20 8/20/2003 False
Pete Cassel Married 23 3/13/2001 False
Nicky Tremblay Married 32 1/5/1992 True
Mary Cassel Married 24 7/10/1999 True
Preview
Joe Crosswave Married 32 1/5/1992 False
Merry Lisel Widowed 41 5/6/1982
Henry Crux Single 29 11/19/1994 True
Cody Jurut 49 8/11/1974 False
Simon Scranton Single 34 10/10/1989
Leena Laurent Divorced 19 7/1/2004 False
Ode Cosmides Married 54 4/17/1970 True
Diandra Mizner Single 20 8/20/2003 False
Pete Cassel Married 23 3/13/2001 False
Nicky Tremblay Married 32 1/5/1992 True
Mary Cassel Married 24 7/10/1999 True
Filter row view

@model IQueryable<Person>

@(Html
    .Grid(Model)
    .Build(columns =>
    {
        columns.Add(model => model.Name);
        columns.Add(model => model.Surname);
        columns.Add(model => model.MaritalStatus);

        columns.Add(model => model.Age);
        columns.Add(model => model.Birthday).Formatted("{0:d}");
        columns.Add(model => model.IsWorking);
    })
    .Using(GridFilterMode.Row)
    .Empty("No data found")
    .Filterable()
    .Sortable()
)

Excel row view

@model IQueryable<Person>

@(Html
    .Grid(Model)
    .Build(columns =>
    {
        columns.Add(model => model.Name);
        columns.Add(model => model.Surname);
        columns.Add(model => model.MaritalStatus);

        columns.Add(model => model.Age);
        columns.Add(model => model.Birthday).Formatted("{0:d}");
        columns.Add(model => model.IsWorking);
    })
    .Using(GridFilterMode.Excel)
    .Empty("No data found")
    .Filterable()
    .Sortable()
)

Header row view

@model IQueryable<Person>

@(Html
    .Grid(Model)
    .Build(columns =>
    {
        columns.Add(model => model.Name);
        columns.Add(model => model.Surname);
        columns.Add(model => model.MaritalStatus);

        columns.Add(model => model.Age);
        columns.Add(model => model.Birthday).Formatted("{0:d}");
        columns.Add(model => model.IsWorking);
    })
    .Using(GridFilterMode.Header)
    .Empty("No data found")
    .Filterable()
    .Sortable()
)