Preview
Name Surname Marital status Age Birthday Employed
Joe Crosswave Married 32 1/5/1993 False
Merry Lisel Widowed 41 5/6/1983
Henry Crux Single 29 11/19/1995 True
Cody Jurut 49 8/11/1975 False
Simon Scranton Single 34 10/10/1990
Leena Laurent Divorced 19 7/1/2005 False
Ode Cosmides Married 53 4/17/1971 True
Diandra Mizner Single 20 8/20/2004 False
Pete Cassel Married 22 3/13/2002 False
Nicky Tremblay Married 32 1/5/1993 True
Mary Cassel Married 24 7/10/2000 True
Preview
Name Surname Marital status Age Birthday Employed
Joe Crosswave Married 32 1/5/1993 False
Merry Lisel Widowed 41 5/6/1983
Henry Crux Single 29 11/19/1995 True
Cody Jurut 49 8/11/1975 False
Simon Scranton Single 34 10/10/1990
Leena Laurent Divorced 19 7/1/2005 False
Ode Cosmides Married 53 4/17/1971 True
Diandra Mizner Single 20 8/20/2004 False
Pete Cassel Married 22 3/13/2002 False
Nicky Tremblay Married 32 1/5/1993 True
Mary Cassel Married 24 7/10/2000 True
Preview
Joe Crosswave Married 32 1/5/1993 False
Merry Lisel Widowed 41 5/6/1983
Henry Crux Single 29 11/19/1995 True
Cody Jurut 49 8/11/1975 False
Simon Scranton Single 34 10/10/1990
Leena Laurent Divorced 19 7/1/2005 False
Ode Cosmides Married 53 4/17/1971 True
Diandra Mizner Single 20 8/20/2004 False
Pete Cassel Married 22 3/13/2002 False
Nicky Tremblay Married 32 1/5/1993 True
Mary Cassel Married 24 7/10/2000 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()
)