Specifying Columns |
Docs
You can control the columns selected from the table or view by defining GridColumn objects and adding them the Columns property. In this example columns are selected and combined in an expression and also given a label. |
Loading...
Razor code
GridModel customerGrid = new GridModel(DataSourceType.SQLite, "northwind", "Customers");
customerGrid.Columns = new List
{
new GridColumn("CompanyName", "Name"), // First argument is the expression, second is the label
new GridColumn("coalesce(Address,'') || ', ' || coalesce(City,'')", "Address") { DataType = typeof(string)},
new GridColumn("coalesce(Phone,'') || '/' || coalesce(Fax,'')", "Phone/Fax") { DataType = typeof(string)}
};
@(await new DbNetSuiteCore.GridControl(HttpContext).Render(customerGrid))