How to create a webgrid with dynamic columns?

Question

I saw several examples using Webgrid but all with the number of fixed columns. My data source will return a dynamic list, IE, either returns 5 columns and then can return 6 columns, how to do ?

Answer 1

Something like that:

@model IEnumerable<dynamic>

@{
    WebGrid grid = new WebGrid(source: Model, rowsPerPage: 5, canPage: true);

    List<WebGridColumn> cols = new List<WebGridColumn>();
    cols.Add(grid.Column("ColunaManual", "Coluna Manual"));
    foreach (Dictionary<string, string> linha in Model.Select(m => m.ToPropertyDictionary()))
    {
        cols.Add(grid.Column(linha.Key, linha.Key, 
            format: item => Html.Raw("<text>" + linha.Value + "</text>")
        ));
    }
}

ToPropertyDictionary() is here:

public static class DictionaryExtensions 
{
    public static Dictionary<string, string> ToPropertyDictionary(this object obj)
    {
        var dictionary = new Dictionary<string, string>();
        foreach (var propertyInfo in obj.GetType().GetProperties())
            if (propertyInfo.CanRead && propertyInfo.GetIndexParameters().Length == 0)
                dictionary[propertyInfo.Name] = (propertyInfo.GetValue(obj, null) ?? "").ToString();
        return dictionary;
    }
}