Hidden
The Grid allows the user to show or hide its columns.
You can configure the hidden state of the columns by:
Using Built-In Options
To hide a particular Grid column, set the hidden option.
import { Component } from '@angular/core';
import { sampleCustomers } from './customers';
@Component({
selector: 'my-app',
template: `
<div class="example-config">
<button (click)="restoreColumns()" class="k-button">Restore hidden columns</button>
</div>
<kendo-grid [data]="gridData" style="height:400px">
<ng-template ngFor [ngForOf]="columns" let-column>
<kendo-grid-column
field="{{column}}"
[hidden]="hiddenColumns.indexOf(column) > -1"
>
<ng-template kendoGridHeaderTemplate let-dataItem>
{{dataItem.field}}
<button
(click)="hideColumn(dataItem.field)"
class="k-button k-primary"
style="float: right;"
>
Hide
</button>
</ng-template>
</kendo-grid-column>
</ng-template>
</kendo-grid>
`
})
export class AppComponent {
public gridData: any[] = sampleCustomers;
public columns: string[] = [
'CompanyName', 'ContactName', 'ContactTitle'
];
public hiddenColumns: string[] = [];
public restoreColumns(): void {
this.hiddenColumns = [];
}
public hideColumn(field: string): void {
this.hiddenColumns.push(field);
}
}
import { NgModule } from '@angular/core';
import { BrowserModule } from '@angular/platform-browser';
import { BrowserAnimationsModule } from '@angular/platform-browser/animations';
import { FormsModule } from '@angular/forms';
import { GridModule } from '@progress/kendo-angular-grid';
import { AppComponent } from './app.component';
@NgModule({
imports: [ BrowserModule, BrowserAnimationsModule, FormsModule, GridModule ],
declarations: [ AppComponent ],
bootstrap: [ AppComponent ]
})
export class AppModule { }
import { enableProdMode } from '@angular/core';
import { platformBrowserDynamic } from '@angular/platform-browser-dynamic';
import { AppModule } from './ng.module';
enableProdMode();
const platform = platformBrowserDynamic();
platform.bootstrapModule(AppModule);
export const sampleCustomers = [{
'Id': 'ALFKI',
'CompanyName': 'Alfreds Futterkiste',
'ContactName': 'Maria Anders',
'ContactTitle': 'Sales Representative',
'City': 'Berlin'
}, {
'Id': 'ANATR',
'CompanyName': 'Ana Trujillo Emparedados y helados',
'ContactName': 'Ana Trujillo',
'ContactTitle': 'Owner',
'City': 'México D.F.'
}, {
'Id': 'ANTON',
'CompanyName': 'Antonio Moreno Taquería',
'ContactName': 'Antonio Moreno',
'ContactTitle': 'Owner',
'City': 'México D.F.'
}, {
'Id': 'AROUT',
'CompanyName': 'Around the Horn',
'ContactName': 'Thomas Hardy',
'ContactTitle': 'Sales Representative',
'City': 'London'
}, {
'Id': 'BERGS',
'CompanyName': 'Berglunds snabbköp',
'ContactName': 'Christina Berglund',
'ContactTitle': 'Order Administrator',
'City': 'Luleå'
}, {
'Id': 'BLAUS',
'CompanyName': 'Blauer See Delikatessen',
'ContactName': 'Hanna Moos',
'ContactTitle': 'Sales Representative',
'City': 'Mannheim'
}, {
'Id': 'BLONP',
'CompanyName': 'Blondesddsl père et fils',
'ContactName': 'Frédérique Citeaux',
'ContactTitle': 'Marketing Manager',
'City': 'Strasbourg'
}, {
'Id': 'BOLID',
'CompanyName': 'Bólido Comidas preparadas',
'ContactName': 'Martín Sommer',
'ContactTitle': 'Owner',
'City': 'Madrid'
}, {
'Id': 'BONAP',
'CompanyName': 'Bon app',
'ContactName': 'Laurence Lebihan',
'ContactTitle': 'Owner',
'City': 'Marseille'
}, {
'Id': 'BOTTM',
'CompanyName': 'Bottom-Dollar Markets',
'ContactName': 'Elizabeth Lincoln',
'ContactTitle': 'Accounting Manager',
'City': 'Tsawassen'
}];
export const customers = [{
'Id': 'ALFKI',
'CompanyName': 'Alfreds Futterkiste',
'ContactName': 'Maria Anders',
'ContactTitle': 'Sales Representative',
'Address': 'Obere Str. 57',
'City': 'Berlin',
'PostalCode': '12209',
'Country': 'Germany',
'Phone': '030-0074321',
'Fax': '030-0076545'
}, {
'Id': 'ANATR',
'CompanyName': 'Ana Trujillo Emparedados y helados',
'ContactName': 'Ana Trujillo',
'ContactTitle': 'Owner',
'Address': 'Avda. de la Constitución 2222',
'City': 'México D.F.',
'PostalCode': '05021',
'Country': 'Mexico',
'Phone': '(5) 555-4729',
'Fax': '(5) 555-3745'
}, {
'Id': 'ANTON',
'CompanyName': 'Antonio Moreno Taquería',
'ContactName': 'Antonio Moreno',
'ContactTitle': 'Owner',
'Address': 'Mataderos 2312',
'City': 'México D.F.',
'PostalCode': '05023',
'Country': 'Mexico',
'Phone': '(5) 555-3932'
}, {
'Id': 'AROUT',
'CompanyName': 'Around the Horn',
'ContactName': 'Thomas Hardy',
'ContactTitle': 'Sales Representative',
'Address': '120 Hanover Sq.',
'City': 'London',
'PostalCode': 'WA1 1DP',
'Country': 'UK',
'Phone': '(171) 555-7788',
'Fax': '(171) 555-6750'
}, {
'Id': 'BERGS',
'CompanyName': 'Berglunds snabbköp',
'ContactName': 'Christina Berglund',
'ContactTitle': 'Order Administrator',
'Address': 'Berguvsvägen 8',
'City': 'Luleå',
'PostalCode': 'S-958 22',
'Country': 'Sweden',
'Phone': '0921-12 34 65',
'Fax': '0921-12 34 67'
}, {
'Id': 'BLAUS',
'CompanyName': 'Blauer See Delikatessen',
'ContactName': 'Hanna Moos',
'ContactTitle': 'Sales Representative',
'Address': 'Forsterstr. 57',
'City': 'Mannheim',
'PostalCode': '68306',
'Country': 'Germany',
'Phone': '0621-08460',
'Fax': '0621-08924'
}, {
'Id': 'BLONP',
'CompanyName': 'Blondesddsl père et fils',
'ContactName': 'Frédérique Citeaux',
'ContactTitle': 'Marketing Manager',
'Address': '24, place Kléber',
'City': 'Strasbourg',
'PostalCode': '67000',
'Country': 'France',
'Phone': '88.60.15.31',
'Fax': '88.60.15.32'
}, {
'Id': 'BOLID',
'CompanyName': 'Bólido Comidas preparadas',
'ContactName': 'Martín Sommer',
'ContactTitle': 'Owner',
'Address': 'C/ Araquil, 67',
'City': 'Madrid',
'PostalCode': '28023',
'Country': 'Spain',
'Phone': '(91) 555 22 82',
'Fax': '(91) 555 91 99'
}, {
'Id': 'BONAP',
'CompanyName': 'Bon app',
'ContactName': 'Laurence Lebihan',
'ContactTitle': 'Owner',
'Address': '12, rue des Bouchers',
'City': 'Marseille',
'PostalCode': '13008',
'Country': 'France',
'Phone': '91.24.45.40',
'Fax': '91.24.45.41'
}, {
'Id': 'BOTTM',
'CompanyName': 'Bottom-Dollar Markets',
'ContactName': 'Elizabeth Lincoln',
'ContactTitle': 'Accounting Manager',
'Address': '23 Tsawassen Blvd.',
'City': 'Tsawassen',
'Region': 'BC',
'PostalCode': 'T2F 8M4',
'Country': 'Canada',
'Phone': '(604) 555-4729',
'Fax': '(604) 555-3745'
}, {
'Id': 'BSBEV',
'CompanyName': 'Bad Beverages',
'ContactName': 'Victoria Ashworth',
'ContactTitle': 'Sales Representative',
'Address': 'Fauntleroy Circus',
'City': 'London',
'PostalCode': 'EC2 5NT',
'Country': 'UK',
'Phone': '(171) 555-1212'
}, {
'Id': 'CACTU',
'CompanyName': 'Cactus Comidas para llevar',
'ContactName': 'Patricio Simpson',
'ContactTitle': 'Sales Agent',
'Address': 'Cerrito 333',
'City': 'Buenos Aires',
'PostalCode': '1010',
'Country': 'Argentina',
'Phone': '(1) 135-5555',
'Fax': '(1) 135-4892'
}, {
'Id': 'CENTC',
'CompanyName': 'Centro comercial Moctezuma',
'ContactName': 'Francisco Chang',
'ContactTitle': 'Marketing Manager',
'Address': 'Sierras de Granada 9993',
'City': 'México D.F.',
'PostalCode': '05022',
'Country': 'Mexico',
'Phone': '(5) 555-3392',
'Fax': '(5) 555-7293'
}, {
'Id': 'CHOPS',
'CompanyName': 'Chop-suey Chinese',
'ContactName': 'Yang Wang',
'ContactTitle': 'Owner',
'Address': 'Hauptstr. 29',
'City': 'Bern',
'PostalCode': '3012',
'Country': 'Switzerland',
'Phone': '0452-076545'
}, {
'Id': 'COMMI',
'CompanyName': 'Comércio Mineiro',
'ContactName': 'Pedro Afonso',
'ContactTitle': 'Sales Associate',
'Address': 'Av. dos Lusíadas, 23',
'City': 'Sao Paulo',
'Region': 'SP',
'PostalCode': '05432-043',
'Country': 'Brazil',
'Phone': '(11) 555-7647'
}, {
'Id': 'CONSH',
'CompanyName': 'Consolidated Holdings',
'ContactName': 'Elizabeth Brown',
'ContactTitle': 'Sales Representative',
'Address': 'Berkeley Gardens 12 Brewery',
'City': 'London',
'PostalCode': 'WX1 6LT',
'Country': 'UK',
'Phone': '(171) 555-2282',
'Fax': '(171) 555-9199'
}, {
'Id': 'DRACD',
'CompanyName': 'Drachenblut Delikatessen',
'ContactName': 'Sven Ottlieb',
'ContactTitle': 'Order Administrator',
'Address': 'Walserweg 21',
'City': 'Aachen',
'PostalCode': '52066',
'Country': 'Germany',
'Phone': '0241-039123',
'Fax': '0241-059428'
}, {
'Id': 'DUMON',
'CompanyName': 'Du monde entier',
'ContactName': 'Janine Labrune',
'ContactTitle': 'Owner',
'Address': '67, rue des Cinquante Otages',
'City': 'Nantes',
'PostalCode': '44000',
'Country': 'France',
'Phone': '40.67.88.88',
'Fax': '40.67.89.89'
}, {
'Id': 'EASTC',
'CompanyName': 'Eastern Connection',
'ContactName': 'Ann Devon',
'ContactTitle': 'Sales Agent',
'Address': '35 King George',
'City': 'London',
'PostalCode': 'WX3 6FW',
'Country': 'UK',
'Phone': '(171) 555-0297',
'Fax': '(171) 555-3373'
}, {
'Id': 'ERNSH',
'CompanyName': 'Ernst Handel',
'ContactName': 'Roland Mendel',
'ContactTitle': 'Sales Manager',
'Address': 'Kirchgasse 6',
'City': 'Graz',
'PostalCode': '8010',
'Country': 'Austria',
'Phone': '7675-3425',
'Fax': '7675-3426'
}, {
'Id': 'FAMIA',
'CompanyName': 'Familia Arquibaldo',
'ContactName': 'Aria Cruz',
'ContactTitle': 'Marketing Assistant',
'Address': 'Rua Orós, 92',
'City': 'Sao Paulo',
'Region': 'SP',
'PostalCode': '05442-030',
'Country': 'Brazil',
'Phone': '(11) 555-9857'
}, {
'Id': 'FISSA',
'CompanyName': 'FISSA Fabrica Inter. Salchichas S.A.',
'ContactName': 'Diego Roel',
'ContactTitle': 'Accounting Manager',
'Address': 'C/ Moralzarzal, 86',
'City': 'Madrid',
'PostalCode': '28034',
'Country': 'Spain',
'Phone': '(91) 555 94 44',
'Fax': '(91) 555 55 93'
}, {
'Id': 'FOLIG',
'CompanyName': 'Folies gourmandes',
'ContactName': 'Martine Rancé',
'ContactTitle': 'Assistant Sales Agent',
'Address': '184, chaussée de Tournai',
'City': 'Lille',
'PostalCode': '59000',
'Country': 'France',
'Phone': '20.16.10.16',
'Fax': '20.16.10.17'
}, {
'Id': 'FOLKO',
'CompanyName': 'Folk och fä HB',
'ContactName': 'Maria Larsson',
'ContactTitle': 'Owner',
'Address': 'Åkergatan 24',
'City': 'Bräcke',
'PostalCode': 'S-844 67',
'Country': 'Sweden',
'Phone': '0695-34 67 21'
}, {
'Id': 'FRANK',
'CompanyName': 'Frankenversand',
'ContactName': 'Peter Franken',
'ContactTitle': 'Marketing Manager',
'Address': 'Berliner Platz 43',
'City': 'München',
'PostalCode': '80805',
'Country': 'Germany',
'Phone': '089-0877310',
'Fax': '089-0877451'
}, {
'Id': 'FRANR',
'CompanyName': 'France restauration',
'ContactName': 'Carine Schmitt',
'ContactTitle': 'Marketing Manager',
'Address': '54, rue Royale',
'City': 'Nantes',
'PostalCode': '44000',
'Country': 'France',
'Phone': '40.32.21.21',
'Fax': '40.32.21.20'
}, {
'Id': 'FRANS',
'CompanyName': 'Franchi S.p.A.',
'ContactName': 'Paolo Accorti',
'ContactTitle': 'Sales Representative',
'Address': 'Via Monte Bianco 34',
'City': 'Torino',
'PostalCode': '10100',
'Country': 'Italy',
'Phone': '011-4988260',
'Fax': '011-4988261'
}, {
'Id': 'FURIB',
'CompanyName': 'Furia Bacalhau e Frutos do Mar',
'ContactName': 'Lino Rodriguez',
'ContactTitle': 'Sales Manager',
'Address': 'Jardim das rosas n. 32',
'City': 'Lisboa',
'PostalCode': '1675',
'Country': 'Portugal',
'Phone': '(1) 354-2534',
'Fax': '(1) 354-2535'
}, {
'Id': 'GALED',
'CompanyName': 'Galería del gastrónomo',
'ContactName': 'Eduardo Saavedra',
'ContactTitle': 'Marketing Manager',
'Address': 'Rambla de Cataluña, 23',
'City': 'Barcelona',
'PostalCode': '08022',
'Country': 'Spain',
'Phone': '(93) 203 4560',
'Fax': '(93) 203 4561'
}, {
'Id': 'GODOS',
'CompanyName': 'Godos Cocina Típica',
'ContactName': 'José Pedro Freyre',
'ContactTitle': 'Sales Manager',
'Address': 'C/ Romero, 33',
'City': 'Sevilla',
'PostalCode': '41101',
'Country': 'Spain',
'Phone': '(95) 555 82 82'
}, {
'Id': 'GOURL',
'CompanyName': 'Gourmet Lanchonetes',
'ContactName': 'André Fonseca',
'ContactTitle': 'Sales Associate',
'Address': 'Av. Brasil, 442',
'City': 'Campinas',
'Region': 'SP',
'PostalCode': '04876-786',
'Country': 'Brazil',
'Phone': '(11) 555-9482'
}, {
'Id': 'GREAL',
'CompanyName': 'Great Lakes Food Market',
'ContactName': 'Howard Snyder',
'ContactTitle': 'Marketing Manager',
'Address': '2732 Baker Blvd.',
'City': 'Eugene',
'Region': 'OR',
'PostalCode': '97403',
'Country': 'USA',
'Phone': '(503) 555-7555'
}, {
'Id': 'GROSR',
'CompanyName': 'GROSELLA-Restaurante',
'ContactName': 'Manuel Pereira',
'ContactTitle': 'Owner',
'Address': '5ª Ave. Los Palos Grandes',
'City': 'Caracas',
'Region': 'DF',
'PostalCode': '1081',
'Country': 'Venezuela',
'Phone': '(2) 283-2951',
'Fax': '(2) 283-3397'
}, {
'Id': 'HANAR',
'CompanyName': 'Hanari Carnes',
'ContactName': 'Mario Pontes',
'ContactTitle': 'Accounting Manager',
'Address': 'Rua do Paço, 67',
'City': 'Rio de Janeiro',
'Region': 'RJ',
'PostalCode': '05454-876',
'Country': 'Brazil',
'Phone': '(21) 555-0091',
'Fax': '(21) 555-8765'
}, {
'Id': 'HILAA',
'CompanyName': 'HILARION-Abastos',
'ContactName': 'Carlos Hernández',
'ContactTitle': 'Sales Representative',
'Address': 'Carrera 22 con Ave. Carlos Soublette #8-35',
'City': 'San Cristóbal',
'Region': 'Táchira',
'PostalCode': '5022',
'Country': 'Venezuela',
'Phone': '(5) 555-1340',
'Fax': '(5) 555-1948'
}, {
'Id': 'HUNGC',
'CompanyName': 'Hungry Coyote Import Store',
'ContactName': 'Yoshi Latimer',
'ContactTitle': 'Sales Representative',
'Address': 'City Center Plaza 516 Main St.',
'City': 'Elgin',
'Region': 'OR',
'PostalCode': '97827',
'Country': 'USA',
'Phone': '(503) 555-6874',
'Fax': '(503) 555-2376'
}, {
'Id': 'HUNGO',
'CompanyName': 'Hungry Owl All-Night Grocers',
'ContactName': 'Patricia McKenna',
'ContactTitle': 'Sales Associate',
'Address': '8 Johnstown Road',
'City': 'Cork',
'Region': 'Co. Cork',
'Country': 'Ireland',
'Phone': '2967 542',
'Fax': '2967 3333'
}, {
'Id': 'ISLAT',
'CompanyName': 'Island Trading',
'ContactName': 'Helen Bennett',
'ContactTitle': 'Marketing Manager',
'Address': 'Garden House Crowther Way',
'City': 'Cowes',
'Region': 'Isle of Wight',
'PostalCode': 'PO31 7PJ',
'Country': 'UK',
'Phone': '(198) 555-8888'
}, {
'Id': 'KOENE',
'CompanyName': 'Königlich Essen',
'ContactName': 'Philip Cramer',
'ContactTitle': 'Sales Associate',
'Address': 'Maubelstr. 90',
'City': 'Brandenburg',
'PostalCode': '14776',
'Country': 'Germany',
'Phone': '0555-09876'
}, {
'Id': 'LAUGB',
'CompanyName': 'Laughing Bacchus Wine Cellars',
'ContactName': 'Yoshi Tannamuri',
'ContactTitle': 'Marketing Assistant',
'Address': '1900 Oak St.',
'City': 'Vancouver',
'Region': 'BC',
'PostalCode': 'V3F 2K1',
'Country': 'Canada',
'Phone': '(604) 555-3392',
'Fax': '(604) 555-7293'
}, {
'Id': 'LAZYK',
'CompanyName': 'Lazy K Kountry Store',
'ContactName': 'John Steel',
'ContactTitle': 'Marketing Manager',
'Address': '12 Orchestra Terrace',
'City': 'Walla Walla',
'Region': 'WA',
'PostalCode': '99362',
'Country': 'USA',
'Phone': '(509) 555-7969',
'Fax': '(509) 555-6221'
}, {
'Id': 'LEHMS',
'CompanyName': 'Lehmanns Marktstand',
'ContactName': 'Renate Messner',
'ContactTitle': 'Sales Representative',
'Address': 'Magazinweg 7',
'City': 'Frankfurt a.M.',
'PostalCode': '60528',
'Country': 'Germany',
'Phone': '069-0245984',
'Fax': '069-0245874'
}, {
'Id': 'LILAS',
'CompanyName': 'LILA-Supermercado',
'ContactName': 'Carlos González',
'ContactTitle': 'Accounting Manager',
'Address': 'Carrera 52 con Ave. Bolívar #65-98 Llano Largo',
'City': 'Barquisimeto',
'Region': 'Lara',
'PostalCode': '3508',
'Country': 'Venezuela',
'Phone': '(9) 331-6954',
'Fax': '(9) 331-7256'
}, {
'Id': 'LINOD',
'CompanyName': 'LINO-Delicateses',
'ContactName': 'Felipe Izquierdo',
'ContactTitle': 'Owner',
'Address': 'Ave. 5 de Mayo Porlamar',
'City': 'I. de Margarita',
'Region': 'Nueva Esparta',
'PostalCode': '4980',
'Country': 'Venezuela',
'Phone': '(8) 34-56-12',
'Fax': '(8) 34-93-93'
}, {
'Id': 'LONEP',
'CompanyName': 'Lonesome Pine Restaurant',
'ContactName': 'Fran Wilson',
'ContactTitle': 'Sales Manager',
'Address': '89 Chiaroscuro Rd.',
'City': 'Portland',
'Region': 'OR',
'PostalCode': '97219',
'Country': 'USA',
'Phone': '(503) 555-9573',
'Fax': '(503) 555-9646'
}, {
'Id': 'MAGAA',
'CompanyName': 'Magazzini Alimentari Riuniti',
'ContactName': 'Giovanni Rovelli',
'ContactTitle': 'Marketing Manager',
'Address': 'Via Ludovico il Moro 22',
'City': 'Bergamo',
'PostalCode': '24100',
'Country': 'Italy',
'Phone': '035-640230',
'Fax': '035-640231'
}, {
'Id': 'MAISD',
'CompanyName': 'Maison Dewey',
'ContactName': 'Catherine Dewey',
'ContactTitle': 'Sales Agent',
'Address': 'Rue Joseph-Bens 532',
'City': 'Bruxelles',
'PostalCode': 'B-1180',
'Country': 'Belgium',
'Phone': '(02) 201 24 67',
'Fax': '(02) 201 24 68'
}, {
'Id': 'MEREP',
'CompanyName': 'Mère Paillarde',
'ContactName': 'Jean Fresnière',
'ContactTitle': 'Marketing Assistant',
'Address': '43 rue St. Laurent',
'City': 'Montréal',
'Region': 'Québec',
'PostalCode': 'H1J 1C3',
'Country': 'Canada',
'Phone': '(514) 555-8054',
'Fax': '(514) 555-8055'
}, {
'Id': 'MORGK',
'CompanyName': 'Morgenstern Gesundkost',
'ContactName': 'Alexander Feuer',
'ContactTitle': 'Marketing Assistant',
'Address': 'Heerstr. 22',
'City': 'Leipzig',
'PostalCode': '04179',
'Country': 'Germany',
'Phone': '0342-023176'
}, {
'Id': 'NORTS',
'CompanyName': 'North/South',
'ContactName': 'Simon Crowther',
'ContactTitle': 'Sales Associate',
'Address': 'South House 300 Queensbridge',
'City': 'London',
'PostalCode': 'SW7 1RZ',
'Country': 'UK',
'Phone': '(171) 555-7733',
'Fax': '(171) 555-2530'
}, {
'Id': 'OCEAN',
'CompanyName': 'Océano Atlántico Ltda.',
'ContactName': 'Yvonne Moncada',
'ContactTitle': 'Sales Agent',
'Address': 'Ing. Gustavo Moncada 8585 Piso 20-A',
'City': 'Buenos Aires',
'PostalCode': '1010',
'Country': 'Argentina',
'Phone': '(1) 135-5333',
'Fax': '(1) 135-5535'
}, {
'Id': 'OLDWO',
'CompanyName': 'Old World Delicatessen',
'ContactName': 'Rene Phillips',
'ContactTitle': 'Sales Representative',
'Address': '2743 Bering St.',
'City': 'Anchorage',
'Region': 'AK',
'PostalCode': '99508',
'Country': 'USA',
'Phone': '(907) 555-7584',
'Fax': '(907) 555-2880'
}, {
'Id': 'OTTIK',
'CompanyName': 'Ottilies Käseladen',
'ContactName': 'Henriette Pfalzheim',
'ContactTitle': 'Owner',
'Address': 'Mehrheimerstr. 369',
'City': 'Köln',
'PostalCode': '50739',
'Country': 'Germany',
'Phone': '0221-0644327',
'Fax': '0221-0765721'
}, {
'Id': 'PARIS',
'CompanyName': 'Paris spécialités',
'ContactName': 'Marie Bertrand',
'ContactTitle': 'Owner',
'Address': '265, boulevard Charonne',
'City': 'Paris',
'PostalCode': '75012',
'Country': 'France',
'Phone': '(1) 42.34.22.66',
'Fax': '(1) 42.34.22.77'
}, {
'Id': 'PERIC',
'CompanyName': 'Pericles Comidas clásicas',
'ContactName': 'Guillermo Fernández',
'ContactTitle': 'Sales Representative',
'Address': 'Calle Dr. Jorge Cash 321',
'City': 'México D.F.',
'PostalCode': '05033',
'Country': 'Mexico',
'Phone': '(5) 552-3745',
'Fax': '(5) 545-3745'
}, {
'Id': 'PICCO',
'CompanyName': 'Piccolo und mehr',
'ContactName': 'Georg Pipps',
'ContactTitle': 'Sales Manager',
'Address': 'Geislweg 14',
'City': 'Salzburg',
'PostalCode': '5020',
'Country': 'Austria',
'Phone': '6562-9722',
'Fax': '6562-9723'
}, {
'Id': 'PRINI',
'CompanyName': 'Princesa Isabel Vinhos',
'ContactName': 'Isabel de Castro',
'ContactTitle': 'Sales Representative',
'Address': 'Estrada da saúde n. 58',
'City': 'Lisboa',
'PostalCode': '1756',
'Country': 'Portugal',
'Phone': '(1) 356-5634'
}, {
'Id': 'QUEDE',
'CompanyName': 'Que Delícia',
'ContactName': 'Bernardo Batista',
'ContactTitle': 'Accounting Manager',
'Address': 'Rua da Panificadora, 12',
'City': 'Rio de Janeiro',
'Region': 'RJ',
'PostalCode': '02389-673',
'Country': 'Brazil',
'Phone': '(21) 555-4252',
'Fax': '(21) 555-4545'
}, {
'Id': 'QUEEN',
'CompanyName': 'Queen Cozinha',
'ContactName': 'Lúcia Carvalho',
'ContactTitle': 'Marketing Assistant',
'Address': 'Alameda dos Canàrios, 891',
'City': 'Sao Paulo',
'Region': 'SP',
'PostalCode': '05487-020',
'Country': 'Brazil',
'Phone': '(11) 555-1189'
}, {
'Id': 'QUICK',
'CompanyName': 'QUICK-Stop',
'ContactName': 'Horst Kloss',
'ContactTitle': 'Accounting Manager',
'Address': 'Taucherstraße 10',
'City': 'Cunewalde',
'PostalCode': '01307',
'Country': 'Germany',
'Phone': '0372-035188'
}, {
'Id': 'RANCH',
'CompanyName': 'Rancho grande',
'ContactName': 'Sergio Gutiérrez',
'ContactTitle': 'Sales Representative',
'Address': 'Av. del Libertador 900',
'City': 'Buenos Aires',
'PostalCode': '1010',
'Country': 'Argentina',
'Phone': '(1) 123-5555',
'Fax': '(1) 123-5556'
}, {
'Id': 'RATTC',
'CompanyName': 'Rattlesnake Canyon Grocery',
'ContactName': 'Paula Wilson',
'ContactTitle': 'Assistant Sales Representative',
'Address': '2817 Milton Dr.',
'City': 'Albuquerque',
'Region': 'NM',
'PostalCode': '87110',
'Country': 'USA',
'Phone': '(505) 555-5939',
'Fax': '(505) 555-3620'
}, {
'Id': 'REGGC',
'CompanyName': 'Reggiani Caseifici',
'ContactName': 'Maurizio Moroni',
'ContactTitle': 'Sales Associate',
'Address': 'Strada Provinciale 124',
'City': 'Reggio Emilia',
'PostalCode': '42100',
'Country': 'Italy',
'Phone': '0522-556721',
'Fax': '0522-556722'
}, {
'Id': 'RICAR',
'CompanyName': 'Ricardo Adocicados',
'ContactName': 'Janete Limeira',
'ContactTitle': 'Assistant Sales Agent',
'Address': 'Av. Copacabana, 267',
'City': 'Rio de Janeiro',
'Region': 'RJ',
'PostalCode': '02389-890',
'Country': 'Brazil',
'Phone': '(21) 555-3412'
}, {
'Id': 'RICSU',
'CompanyName': 'Richter Supermarkt',
'ContactName': 'Michael Holz',
'ContactTitle': 'Sales Manager',
'Address': 'Grenzacherweg 237',
'City': 'Genève',
'PostalCode': '1203',
'Country': 'Switzerland',
'Phone': '0897-034214'
}, {
'Id': 'ROMEY',
'CompanyName': 'Romero y tomillo',
'ContactName': 'Alejandra Camino',
'ContactTitle': 'Accounting Manager',
'Address': 'Gran Vía, 1',
'City': 'Madrid',
'PostalCode': '28001',
'Country': 'Spain',
'Phone': '(91) 745 6200',
'Fax': '(91) 745 6210'
}, {
'Id': 'SANTG',
'CompanyName': 'Santé Gourmet',
'ContactName': 'Jonas Bergulfsen',
'ContactTitle': 'Owner',
'Address': 'Erling Skakkes gate 78',
'City': 'Stavern',
'PostalCode': '4110',
'Country': 'Norway',
'Phone': '07-98 92 35',
'Fax': '07-98 92 47'
}, {
'Id': 'SAVEA',
'CompanyName': 'Save-a-lot Markets',
'ContactName': 'Jose Pavarotti',
'ContactTitle': 'Sales Representative',
'Address': '187 Suffolk Ln.',
'City': 'Boise',
'Region': 'ID',
'PostalCode': '83720',
'Country': 'USA',
'Phone': '(208) 555-8097'
}, {
'Id': 'SEVES',
'CompanyName': 'Seven Seas Imports',
'ContactName': 'Hari Kumar',
'ContactTitle': 'Sales Manager',
'Address': '90 Wadhurst Rd.',
'City': 'London',
'PostalCode': 'OX15 4NB',
'Country': 'UK',
'Phone': '(171) 555-1717',
'Fax': '(171) 555-5646'
}, {
'Id': 'SIMOB',
'CompanyName': 'Simons bistro',
'ContactName': 'Jytte Petersen',
'ContactTitle': 'Owner',
'Address': 'Vinbæltet 34',
'City': 'Kobenhavn',
'PostalCode': '1734',
'Country': 'Denmark',
'Phone': '31 12 34 56',
'Fax': '31 13 35 57'
}, {
'Id': 'SPECD',
'CompanyName': 'Spécialités du monde',
'ContactName': 'Dominique Perrier',
'ContactTitle': 'Marketing Manager',
'Address': '25, rue Lauriston',
'City': 'Paris',
'PostalCode': '75016',
'Country': 'France',
'Phone': '(1) 47.55.60.10',
'Fax': '(1) 47.55.60.20'
}, {
'Id': 'SPLIR',
'CompanyName': 'Split Rail Beer & Ale',
'ContactName': 'Art Braunschweiger',
'ContactTitle': 'Sales Manager',
'Address': 'P.O. Box 555',
'City': 'Lander',
'Region': 'WY',
'PostalCode': '82520',
'Country': 'USA',
'Phone': '(307) 555-4680',
'Fax': '(307) 555-6525'
}, {
'Id': 'SUPRD',
'CompanyName': 'Suprêmes délices',
'ContactName': 'Pascale Cartrain',
'ContactTitle': 'Accounting Manager',
'Address': 'Boulevard Tirou, 255',
'City': 'Charleroi',
'PostalCode': 'B-6000',
'Country': 'Belgium',
'Phone': '(071) 23 67 22 20',
'Fax': '(071) 23 67 22 21'
}, {
'Id': 'THEBI',
'CompanyName': 'The Big Cheese',
'ContactName': 'Liz Nixon',
'ContactTitle': 'Marketing Manager',
'Address': '89 Jefferson Way Suite 2',
'City': 'Portland',
'Region': 'OR',
'PostalCode': '97201',
'Country': 'USA',
'Phone': '(503) 555-3612'
}, {
'Id': 'THECR',
'CompanyName': 'The Cracker Box',
'ContactName': 'Liu Wong',
'ContactTitle': 'Marketing Assistant',
'Address': '55 Grizzly Peak Rd.',
'City': 'Butte',
'Region': 'MT',
'PostalCode': '59801',
'Country': 'USA',
'Phone': '(406) 555-5834',
'Fax': '(406) 555-8083'
}, {
'Id': 'TOMSP',
'CompanyName': 'Toms Spezialitäten',
'ContactName': 'Karin Josephs',
'ContactTitle': 'Marketing Manager',
'Address': 'Luisenstr. 48',
'City': 'Münster',
'PostalCode': '44087',
'Country': 'Germany',
'Phone': '0251-031259',
'Fax': '0251-035695'
}, {
'Id': 'TORTU',
'CompanyName': 'Tortuga Restaurante',
'ContactName': 'Miguel Angel Paolino',
'ContactTitle': 'Owner',
'Address': 'Avda. Azteca 123',
'City': 'México D.F.',
'PostalCode': '05033',
'Country': 'Mexico',
'Phone': '(5) 555-2933'
}, {
'Id': 'TRADH',
'CompanyName': 'Tradição Hipermercados',
'ContactName': 'Anabela Domingues',
'ContactTitle': 'Sales Representative',
'Address': 'Av. Inês de Castro, 414',
'City': 'Sao Paulo',
'Region': 'SP',
'PostalCode': '05634-030',
'Country': 'Brazil',
'Phone': '(11) 555-2167',
'Fax': '(11) 555-2168'
}, {
'Id': 'VAFFE',
'CompanyName': 'Vaffeljernet',
'ContactName': 'Palle Ibsen',
'ContactTitle': 'Sales Manager',
'Address': 'Smagsloget 45',
'City': 'Århus',
'PostalCode': '8200',
'Country': 'Denmark',
'Phone': '86 21 32 43',
'Fax': '86 22 33 44'
}, {
'Id': 'VICTE',
'CompanyName': 'Victuailles en stock',
'ContactName': 'Mary Saveley',
'ContactTitle': 'Sales Agent',
'Address': '2, rue du Commerce',
'City': 'Lyon',
'PostalCode': '69004',
'Country': 'France',
'Phone': '78.32.54.86',
'Fax': '78.32.54.87'
}, {
'Id': 'WANDK',
'CompanyName': 'Die Wandernde Kuh',
'ContactName': 'Rita Müller',
'ContactTitle': 'Sales Representative',
'Address': 'Adenauerallee 900',
'City': 'Stuttgart',
'PostalCode': '70563',
'Country': 'Germany',
'Phone': '0711-020361',
'Fax': '0711-035428'
}, {
'Id': 'WARTH',
'CompanyName': 'Wartian Herkku',
'ContactName': 'Pirkko Koskitalo',
'ContactTitle': 'Accounting Manager',
'Address': 'Torikatu 38',
'City': 'Oulu',
'PostalCode': '90110',
'Country': 'Finland',
'Phone': '981-443655',
'Fax': '981-443655'
}, {
'Id': 'WELLI',
'CompanyName': 'Wellington Importadora',
'ContactName': 'Paula Parente',
'ContactTitle': 'Sales Manager',
'Address': 'Rua do Mercado, 12',
'City': 'Resende',
'Region': 'SP',
'PostalCode': '08737-363',
'Country': 'Brazil',
'Phone': '(14) 555-8122'
}, {
'Id': 'WHITC',
'CompanyName': 'White Clover Markets',
'ContactName': 'Karl Jablonski',
'ContactTitle': 'Owner',
'Address': '305 - 14th Ave. S. Suite 3B',
'City': 'Seattle',
'Region': 'WA',
'PostalCode': '98128',
'Country': 'USA',
'Phone': '(206) 555-4112',
'Fax': '(206) 555-4115'
}, {
'Id': 'WILMK',
'CompanyName': 'Wilman Kala',
'ContactName': 'Matti Karttunen',
'ContactTitle': 'Owner/Marketing Assistant',
'Address': 'Keskuskatu 45',
'City': 'Helsinki',
'PostalCode': '21240',
'Country': 'Finland',
'Phone': '90-224 8858',
'Fax': '90-224 8858'
}, {
'Id': 'WOLZA',
'CompanyName': 'Wolski Zajazd',
'ContactName': 'Zbyszek Piestrzeniewicz',
'ContactTitle': 'Owner',
'Address': 'ul. Filtrowa 68',
'City': 'Warszawa',
'PostalCode': '01-012',
'Country': 'Poland',
'Phone': '(26) 642-7012',
'Fax': '(26) 642-7012'
}];
Using Structural Directives
To show or hide particular Grid columns, use the ngIf Angular directive.
Unlike the
hiddenbuilt-in option,*ngIfimposes certain limitations. As a result, when you use the*ngIfdirective to conditionally control the columns of the Grid, particular features, such as the titles in specific grouping scenarios, grouping templates, and responsiveness, are not available.
import { Component } from '@angular/core';
import { sampleCustomers } from './customers';
@Component({
selector: 'my-app',
template: `
<div class="row example-config">
<div *ngFor="let column of columns" class="col-xs-12 col-md-3 example-col">
<input type="checkbox"
id="{{column}}"
class="k-checkbox"
[disabled]="isDisabled(column)"
[checked]="!isHidden(column)"
(change)="hideColumn(column)" />
<label class="k-checkbox-label" for="{{column}}">{{column}}</label>
</div>
</div>
<kendo-grid [data]="gridData">
<kendo-grid-column field="CompanyName" title="Company Name" *ngIf="!isHidden('CompanyName')">
</kendo-grid-column>
<kendo-grid-column field="ContactName" title="Contact Name" *ngIf="!isHidden('ContactName')">
</kendo-grid-column>
<kendo-grid-column field="ContactTitle" title="ContactTitle" *ngIf="!isHidden('ContactTitle')">
</kendo-grid-column>
</kendo-grid>
`
})
export class AppComponent {
public gridData: any[] = sampleCustomers;
public columns: string[] = [
'CompanyName', 'ContactName', 'ContactTitle'
];
public hiddenColumns: string[] = [];
public isHidden(columnName: string): boolean {
return this.hiddenColumns.indexOf(columnName) > -1;
}
public isDisabled(columnName: string): boolean {
return this.columns.length - this.hiddenColumns.length === 1 && !this.isHidden(columnName);
}
public hideColumn(columnName: string): void {
const hiddenColumns = this.hiddenColumns;
if (!this.isHidden(columnName)) {
hiddenColumns.push(columnName);
} else {
hiddenColumns.splice(hiddenColumns.indexOf(columnName), 1);
}
}
}
import { NgModule } from '@angular/core';
import { BrowserModule } from '@angular/platform-browser';
import { BrowserAnimationsModule } from '@angular/platform-browser/animations';
import { FormsModule } from '@angular/forms';
import { GridModule } from '@progress/kendo-angular-grid';
import { AppComponent } from './app.component';
@NgModule({
imports: [ BrowserModule, BrowserAnimationsModule, FormsModule, GridModule ],
declarations: [ AppComponent ],
bootstrap: [ AppComponent ]
})
export class AppModule { }
import { enableProdMode } from '@angular/core';
import { platformBrowserDynamic } from '@angular/platform-browser-dynamic';
import { AppModule } from './ng.module';
enableProdMode();
const platform = platformBrowserDynamic();
platform.bootstrapModule(AppModule);
export const sampleCustomers = [{
'Id': 'ALFKI',
'CompanyName': 'Alfreds Futterkiste',
'ContactName': 'Maria Anders',
'ContactTitle': 'Sales Representative',
'City': 'Berlin'
}, {
'Id': 'ANATR',
'CompanyName': 'Ana Trujillo Emparedados y helados',
'ContactName': 'Ana Trujillo',
'ContactTitle': 'Owner',
'City': 'México D.F.'
}, {
'Id': 'ANTON',
'CompanyName': 'Antonio Moreno Taquería',
'ContactName': 'Antonio Moreno',
'ContactTitle': 'Owner',
'City': 'México D.F.'
}, {
'Id': 'AROUT',
'CompanyName': 'Around the Horn',
'ContactName': 'Thomas Hardy',
'ContactTitle': 'Sales Representative',
'City': 'London'
}, {
'Id': 'BERGS',
'CompanyName': 'Berglunds snabbköp',
'ContactName': 'Christina Berglund',
'ContactTitle': 'Order Administrator',
'City': 'Luleå'
}, {
'Id': 'BLAUS',
'CompanyName': 'Blauer See Delikatessen',
'ContactName': 'Hanna Moos',
'ContactTitle': 'Sales Representative',
'City': 'Mannheim'
}, {
'Id': 'BLONP',
'CompanyName': 'Blondesddsl père et fils',
'ContactName': 'Frédérique Citeaux',
'ContactTitle': 'Marketing Manager',
'City': 'Strasbourg'
}, {
'Id': 'BOLID',
'CompanyName': 'Bólido Comidas preparadas',
'ContactName': 'Martín Sommer',
'ContactTitle': 'Owner',
'City': 'Madrid'
}, {
'Id': 'BONAP',
'CompanyName': 'Bon app',
'ContactName': 'Laurence Lebihan',
'ContactTitle': 'Owner',
'City': 'Marseille'
}, {
'Id': 'BOTTM',
'CompanyName': 'Bottom-Dollar Markets',
'ContactName': 'Elizabeth Lincoln',
'ContactTitle': 'Accounting Manager',
'City': 'Tsawassen'
}];
export const customers = [{
'Id': 'ALFKI',
'CompanyName': 'Alfreds Futterkiste',
'ContactName': 'Maria Anders',
'ContactTitle': 'Sales Representative',
'Address': 'Obere Str. 57',
'City': 'Berlin',
'PostalCode': '12209',
'Country': 'Germany',
'Phone': '030-0074321',
'Fax': '030-0076545'
}, {
'Id': 'ANATR',
'CompanyName': 'Ana Trujillo Emparedados y helados',
'ContactName': 'Ana Trujillo',
'ContactTitle': 'Owner',
'Address': 'Avda. de la Constitución 2222',
'City': 'México D.F.',
'PostalCode': '05021',
'Country': 'Mexico',
'Phone': '(5) 555-4729',
'Fax': '(5) 555-3745'
}, {
'Id': 'ANTON',
'CompanyName': 'Antonio Moreno Taquería',
'ContactName': 'Antonio Moreno',
'ContactTitle': 'Owner',
'Address': 'Mataderos 2312',
'City': 'México D.F.',
'PostalCode': '05023',
'Country': 'Mexico',
'Phone': '(5) 555-3932'
}, {
'Id': 'AROUT',
'CompanyName': 'Around the Horn',
'ContactName': 'Thomas Hardy',
'ContactTitle': 'Sales Representative',
'Address': '120 Hanover Sq.',
'City': 'London',
'PostalCode': 'WA1 1DP',
'Country': 'UK',
'Phone': '(171) 555-7788',
'Fax': '(171) 555-6750'
}, {
'Id': 'BERGS',
'CompanyName': 'Berglunds snabbköp',
'ContactName': 'Christina Berglund',
'ContactTitle': 'Order Administrator',
'Address': 'Berguvsvägen 8',
'City': 'Luleå',
'PostalCode': 'S-958 22',
'Country': 'Sweden',
'Phone': '0921-12 34 65',
'Fax': '0921-12 34 67'
}, {
'Id': 'BLAUS',
'CompanyName': 'Blauer See Delikatessen',
'ContactName': 'Hanna Moos',
'ContactTitle': 'Sales Representative',
'Address': 'Forsterstr. 57',
'City': 'Mannheim',
'PostalCode': '68306',
'Country': 'Germany',
'Phone': '0621-08460',
'Fax': '0621-08924'
}, {
'Id': 'BLONP',
'CompanyName': 'Blondesddsl père et fils',
'ContactName': 'Frédérique Citeaux',
'ContactTitle': 'Marketing Manager',
'Address': '24, place Kléber',
'City': 'Strasbourg',
'PostalCode': '67000',
'Country': 'France',
'Phone': '88.60.15.31',
'Fax': '88.60.15.32'
}, {
'Id': 'BOLID',
'CompanyName': 'Bólido Comidas preparadas',
'ContactName': 'Martín Sommer',
'ContactTitle': 'Owner',
'Address': 'C/ Araquil, 67',
'City': 'Madrid',
'PostalCode': '28023',
'Country': 'Spain',
'Phone': '(91) 555 22 82',
'Fax': '(91) 555 91 99'
}, {
'Id': 'BONAP',
'CompanyName': 'Bon app',
'ContactName': 'Laurence Lebihan',
'ContactTitle': 'Owner',
'Address': '12, rue des Bouchers',
'City': 'Marseille',
'PostalCode': '13008',
'Country': 'France',
'Phone': '91.24.45.40',
'Fax': '91.24.45.41'
}, {
'Id': 'BOTTM',
'CompanyName': 'Bottom-Dollar Markets',
'ContactName': 'Elizabeth Lincoln',
'ContactTitle': 'Accounting Manager',
'Address': '23 Tsawassen Blvd.',
'City': 'Tsawassen',
'Region': 'BC',
'PostalCode': 'T2F 8M4',
'Country': 'Canada',
'Phone': '(604) 555-4729',
'Fax': '(604) 555-3745'
}, {
'Id': 'BSBEV',
'CompanyName': 'Bad Beverages',
'ContactName': 'Victoria Ashworth',
'ContactTitle': 'Sales Representative',
'Address': 'Fauntleroy Circus',
'City': 'London',
'PostalCode': 'EC2 5NT',
'Country': 'UK',
'Phone': '(171) 555-1212'
}, {
'Id': 'CACTU',
'CompanyName': 'Cactus Comidas para llevar',
'ContactName': 'Patricio Simpson',
'ContactTitle': 'Sales Agent',
'Address': 'Cerrito 333',
'City': 'Buenos Aires',
'PostalCode': '1010',
'Country': 'Argentina',
'Phone': '(1) 135-5555',
'Fax': '(1) 135-4892'
}, {
'Id': 'CENTC',
'CompanyName': 'Centro comercial Moctezuma',
'ContactName': 'Francisco Chang',
'ContactTitle': 'Marketing Manager',
'Address': 'Sierras de Granada 9993',
'City': 'México D.F.',
'PostalCode': '05022',
'Country': 'Mexico',
'Phone': '(5) 555-3392',
'Fax': '(5) 555-7293'
}, {
'Id': 'CHOPS',
'CompanyName': 'Chop-suey Chinese',
'ContactName': 'Yang Wang',
'ContactTitle': 'Owner',
'Address': 'Hauptstr. 29',
'City': 'Bern',
'PostalCode': '3012',
'Country': 'Switzerland',
'Phone': '0452-076545'
}, {
'Id': 'COMMI',
'CompanyName': 'Comércio Mineiro',
'ContactName': 'Pedro Afonso',
'ContactTitle': 'Sales Associate',
'Address': 'Av. dos Lusíadas, 23',
'City': 'Sao Paulo',
'Region': 'SP',
'PostalCode': '05432-043',
'Country': 'Brazil',
'Phone': '(11) 555-7647'
}, {
'Id': 'CONSH',
'CompanyName': 'Consolidated Holdings',
'ContactName': 'Elizabeth Brown',
'ContactTitle': 'Sales Representative',
'Address': 'Berkeley Gardens 12 Brewery',
'City': 'London',
'PostalCode': 'WX1 6LT',
'Country': 'UK',
'Phone': '(171) 555-2282',
'Fax': '(171) 555-9199'
}, {
'Id': 'DRACD',
'CompanyName': 'Drachenblut Delikatessen',
'ContactName': 'Sven Ottlieb',
'ContactTitle': 'Order Administrator',
'Address': 'Walserweg 21',
'City': 'Aachen',
'PostalCode': '52066',
'Country': 'Germany',
'Phone': '0241-039123',
'Fax': '0241-059428'
}, {
'Id': 'DUMON',
'CompanyName': 'Du monde entier',
'ContactName': 'Janine Labrune',
'ContactTitle': 'Owner',
'Address': '67, rue des Cinquante Otages',
'City': 'Nantes',
'PostalCode': '44000',
'Country': 'France',
'Phone': '40.67.88.88',
'Fax': '40.67.89.89'
}, {
'Id': 'EASTC',
'CompanyName': 'Eastern Connection',
'ContactName': 'Ann Devon',
'ContactTitle': 'Sales Agent',
'Address': '35 King George',
'City': 'London',
'PostalCode': 'WX3 6FW',
'Country': 'UK',
'Phone': '(171) 555-0297',
'Fax': '(171) 555-3373'
}, {
'Id': 'ERNSH',
'CompanyName': 'Ernst Handel',
'ContactName': 'Roland Mendel',
'ContactTitle': 'Sales Manager',
'Address': 'Kirchgasse 6',
'City': 'Graz',
'PostalCode': '8010',
'Country': 'Austria',
'Phone': '7675-3425',
'Fax': '7675-3426'
}, {
'Id': 'FAMIA',
'CompanyName': 'Familia Arquibaldo',
'ContactName': 'Aria Cruz',
'ContactTitle': 'Marketing Assistant',
'Address': 'Rua Orós, 92',
'City': 'Sao Paulo',
'Region': 'SP',
'PostalCode': '05442-030',
'Country': 'Brazil',
'Phone': '(11) 555-9857'
}, {
'Id': 'FISSA',
'CompanyName': 'FISSA Fabrica Inter. Salchichas S.A.',
'ContactName': 'Diego Roel',
'ContactTitle': 'Accounting Manager',
'Address': 'C/ Moralzarzal, 86',
'City': 'Madrid',
'PostalCode': '28034',
'Country': 'Spain',
'Phone': '(91) 555 94 44',
'Fax': '(91) 555 55 93'
}, {
'Id': 'FOLIG',
'CompanyName': 'Folies gourmandes',
'ContactName': 'Martine Rancé',
'ContactTitle': 'Assistant Sales Agent',
'Address': '184, chaussée de Tournai',
'City': 'Lille',
'PostalCode': '59000',
'Country': 'France',
'Phone': '20.16.10.16',
'Fax': '20.16.10.17'
}, {
'Id': 'FOLKO',
'CompanyName': 'Folk och fä HB',
'ContactName': 'Maria Larsson',
'ContactTitle': 'Owner',
'Address': 'Åkergatan 24',
'City': 'Bräcke',
'PostalCode': 'S-844 67',
'Country': 'Sweden',
'Phone': '0695-34 67 21'
}, {
'Id': 'FRANK',
'CompanyName': 'Frankenversand',
'ContactName': 'Peter Franken',
'ContactTitle': 'Marketing Manager',
'Address': 'Berliner Platz 43',
'City': 'München',
'PostalCode': '80805',
'Country': 'Germany',
'Phone': '089-0877310',
'Fax': '089-0877451'
}, {
'Id': 'FRANR',
'CompanyName': 'France restauration',
'ContactName': 'Carine Schmitt',
'ContactTitle': 'Marketing Manager',
'Address': '54, rue Royale',
'City': 'Nantes',
'PostalCode': '44000',
'Country': 'France',
'Phone': '40.32.21.21',
'Fax': '40.32.21.20'
}, {
'Id': 'FRANS',
'CompanyName': 'Franchi S.p.A.',
'ContactName': 'Paolo Accorti',
'ContactTitle': 'Sales Representative',
'Address': 'Via Monte Bianco 34',
'City': 'Torino',
'PostalCode': '10100',
'Country': 'Italy',
'Phone': '011-4988260',
'Fax': '011-4988261'
}, {
'Id': 'FURIB',
'CompanyName': 'Furia Bacalhau e Frutos do Mar',
'ContactName': 'Lino Rodriguez',
'ContactTitle': 'Sales Manager',
'Address': 'Jardim das rosas n. 32',
'City': 'Lisboa',
'PostalCode': '1675',
'Country': 'Portugal',
'Phone': '(1) 354-2534',
'Fax': '(1) 354-2535'
}, {
'Id': 'GALED',
'CompanyName': 'Galería del gastrónomo',
'ContactName': 'Eduardo Saavedra',
'ContactTitle': 'Marketing Manager',
'Address': 'Rambla de Cataluña, 23',
'City': 'Barcelona',
'PostalCode': '08022',
'Country': 'Spain',
'Phone': '(93) 203 4560',
'Fax': '(93) 203 4561'
}, {
'Id': 'GODOS',
'CompanyName': 'Godos Cocina Típica',
'ContactName': 'José Pedro Freyre',
'ContactTitle': 'Sales Manager',
'Address': 'C/ Romero, 33',
'City': 'Sevilla',
'PostalCode': '41101',
'Country': 'Spain',
'Phone': '(95) 555 82 82'
}, {
'Id': 'GOURL',
'CompanyName': 'Gourmet Lanchonetes',
'ContactName': 'André Fonseca',
'ContactTitle': 'Sales Associate',
'Address': 'Av. Brasil, 442',
'City': 'Campinas',
'Region': 'SP',
'PostalCode': '04876-786',
'Country': 'Brazil',
'Phone': '(11) 555-9482'
}, {
'Id': 'GREAL',
'CompanyName': 'Great Lakes Food Market',
'ContactName': 'Howard Snyder',
'ContactTitle': 'Marketing Manager',
'Address': '2732 Baker Blvd.',
'City': 'Eugene',
'Region': 'OR',
'PostalCode': '97403',
'Country': 'USA',
'Phone': '(503) 555-7555'
}, {
'Id': 'GROSR',
'CompanyName': 'GROSELLA-Restaurante',
'ContactName': 'Manuel Pereira',
'ContactTitle': 'Owner',
'Address': '5ª Ave. Los Palos Grandes',
'City': 'Caracas',
'Region': 'DF',
'PostalCode': '1081',
'Country': 'Venezuela',
'Phone': '(2) 283-2951',
'Fax': '(2) 283-3397'
}, {
'Id': 'HANAR',
'CompanyName': 'Hanari Carnes',
'ContactName': 'Mario Pontes',
'ContactTitle': 'Accounting Manager',
'Address': 'Rua do Paço, 67',
'City': 'Rio de Janeiro',
'Region': 'RJ',
'PostalCode': '05454-876',
'Country': 'Brazil',
'Phone': '(21) 555-0091',
'Fax': '(21) 555-8765'
}, {
'Id': 'HILAA',
'CompanyName': 'HILARION-Abastos',
'ContactName': 'Carlos Hernández',
'ContactTitle': 'Sales Representative',
'Address': 'Carrera 22 con Ave. Carlos Soublette #8-35',
'City': 'San Cristóbal',
'Region': 'Táchira',
'PostalCode': '5022',
'Country': 'Venezuela',
'Phone': '(5) 555-1340',
'Fax': '(5) 555-1948'
}, {
'Id': 'HUNGC',
'CompanyName': 'Hungry Coyote Import Store',
'ContactName': 'Yoshi Latimer',
'ContactTitle': 'Sales Representative',
'Address': 'City Center Plaza 516 Main St.',
'City': 'Elgin',
'Region': 'OR',
'PostalCode': '97827',
'Country': 'USA',
'Phone': '(503) 555-6874',
'Fax': '(503) 555-2376'
}, {
'Id': 'HUNGO',
'CompanyName': 'Hungry Owl All-Night Grocers',
'ContactName': 'Patricia McKenna',
'ContactTitle': 'Sales Associate',
'Address': '8 Johnstown Road',
'City': 'Cork',
'Region': 'Co. Cork',
'Country': 'Ireland',
'Phone': '2967 542',
'Fax': '2967 3333'
}, {
'Id': 'ISLAT',
'CompanyName': 'Island Trading',
'ContactName': 'Helen Bennett',
'ContactTitle': 'Marketing Manager',
'Address': 'Garden House Crowther Way',
'City': 'Cowes',
'Region': 'Isle of Wight',
'PostalCode': 'PO31 7PJ',
'Country': 'UK',
'Phone': '(198) 555-8888'
}, {
'Id': 'KOENE',
'CompanyName': 'Königlich Essen',
'ContactName': 'Philip Cramer',
'ContactTitle': 'Sales Associate',
'Address': 'Maubelstr. 90',
'City': 'Brandenburg',
'PostalCode': '14776',
'Country': 'Germany',
'Phone': '0555-09876'
}, {
'Id': 'LAUGB',
'CompanyName': 'Laughing Bacchus Wine Cellars',
'ContactName': 'Yoshi Tannamuri',
'ContactTitle': 'Marketing Assistant',
'Address': '1900 Oak St.',
'City': 'Vancouver',
'Region': 'BC',
'PostalCode': 'V3F 2K1',
'Country': 'Canada',
'Phone': '(604) 555-3392',
'Fax': '(604) 555-7293'
}, {
'Id': 'LAZYK',
'CompanyName': 'Lazy K Kountry Store',
'ContactName': 'John Steel',
'ContactTitle': 'Marketing Manager',
'Address': '12 Orchestra Terrace',
'City': 'Walla Walla',
'Region': 'WA',
'PostalCode': '99362',
'Country': 'USA',
'Phone': '(509) 555-7969',
'Fax': '(509) 555-6221'
}, {
'Id': 'LEHMS',
'CompanyName': 'Lehmanns Marktstand',
'ContactName': 'Renate Messner',
'ContactTitle': 'Sales Representative',
'Address': 'Magazinweg 7',
'City': 'Frankfurt a.M.',
'PostalCode': '60528',
'Country': 'Germany',
'Phone': '069-0245984',
'Fax': '069-0245874'
}, {
'Id': 'LILAS',
'CompanyName': 'LILA-Supermercado',
'ContactName': 'Carlos González',
'ContactTitle': 'Accounting Manager',
'Address': 'Carrera 52 con Ave. Bolívar #65-98 Llano Largo',
'City': 'Barquisimeto',
'Region': 'Lara',
'PostalCode': '3508',
'Country': 'Venezuela',
'Phone': '(9) 331-6954',
'Fax': '(9) 331-7256'
}, {
'Id': 'LINOD',
'CompanyName': 'LINO-Delicateses',
'ContactName': 'Felipe Izquierdo',
'ContactTitle': 'Owner',
'Address': 'Ave. 5 de Mayo Porlamar',
'City': 'I. de Margarita',
'Region': 'Nueva Esparta',
'PostalCode': '4980',
'Country': 'Venezuela',
'Phone': '(8) 34-56-12',
'Fax': '(8) 34-93-93'
}, {
'Id': 'LONEP',
'CompanyName': 'Lonesome Pine Restaurant',
'ContactName': 'Fran Wilson',
'ContactTitle': 'Sales Manager',
'Address': '89 Chiaroscuro Rd.',
'City': 'Portland',
'Region': 'OR',
'PostalCode': '97219',
'Country': 'USA',
'Phone': '(503) 555-9573',
'Fax': '(503) 555-9646'
}, {
'Id': 'MAGAA',
'CompanyName': 'Magazzini Alimentari Riuniti',
'ContactName': 'Giovanni Rovelli',
'ContactTitle': 'Marketing Manager',
'Address': 'Via Ludovico il Moro 22',
'City': 'Bergamo',
'PostalCode': '24100',
'Country': 'Italy',
'Phone': '035-640230',
'Fax': '035-640231'
}, {
'Id': 'MAISD',
'CompanyName': 'Maison Dewey',
'ContactName': 'Catherine Dewey',
'ContactTitle': 'Sales Agent',
'Address': 'Rue Joseph-Bens 532',
'City': 'Bruxelles',
'PostalCode': 'B-1180',
'Country': 'Belgium',
'Phone': '(02) 201 24 67',
'Fax': '(02) 201 24 68'
}, {
'Id': 'MEREP',
'CompanyName': 'Mère Paillarde',
'ContactName': 'Jean Fresnière',
'ContactTitle': 'Marketing Assistant',
'Address': '43 rue St. Laurent',
'City': 'Montréal',
'Region': 'Québec',
'PostalCode': 'H1J 1C3',
'Country': 'Canada',
'Phone': '(514) 555-8054',
'Fax': '(514) 555-8055'
}, {
'Id': 'MORGK',
'CompanyName': 'Morgenstern Gesundkost',
'ContactName': 'Alexander Feuer',
'ContactTitle': 'Marketing Assistant',
'Address': 'Heerstr. 22',
'City': 'Leipzig',
'PostalCode': '04179',
'Country': 'Germany',
'Phone': '0342-023176'
}, {
'Id': 'NORTS',
'CompanyName': 'North/South',
'ContactName': 'Simon Crowther',
'ContactTitle': 'Sales Associate',
'Address': 'South House 300 Queensbridge',
'City': 'London',
'PostalCode': 'SW7 1RZ',
'Country': 'UK',
'Phone': '(171) 555-7733',
'Fax': '(171) 555-2530'
}, {
'Id': 'OCEAN',
'CompanyName': 'Océano Atlántico Ltda.',
'ContactName': 'Yvonne Moncada',
'ContactTitle': 'Sales Agent',
'Address': 'Ing. Gustavo Moncada 8585 Piso 20-A',
'City': 'Buenos Aires',
'PostalCode': '1010',
'Country': 'Argentina',
'Phone': '(1) 135-5333',
'Fax': '(1) 135-5535'
}, {
'Id': 'OLDWO',
'CompanyName': 'Old World Delicatessen',
'ContactName': 'Rene Phillips',
'ContactTitle': 'Sales Representative',
'Address': '2743 Bering St.',
'City': 'Anchorage',
'Region': 'AK',
'PostalCode': '99508',
'Country': 'USA',
'Phone': '(907) 555-7584',
'Fax': '(907) 555-2880'
}, {
'Id': 'OTTIK',
'CompanyName': 'Ottilies Käseladen',
'ContactName': 'Henriette Pfalzheim',
'ContactTitle': 'Owner',
'Address': 'Mehrheimerstr. 369',
'City': 'Köln',
'PostalCode': '50739',
'Country': 'Germany',
'Phone': '0221-0644327',
'Fax': '0221-0765721'
}, {
'Id': 'PARIS',
'CompanyName': 'Paris spécialités',
'ContactName': 'Marie Bertrand',
'ContactTitle': 'Owner',
'Address': '265, boulevard Charonne',
'City': 'Paris',
'PostalCode': '75012',
'Country': 'France',
'Phone': '(1) 42.34.22.66',
'Fax': '(1) 42.34.22.77'
}, {
'Id': 'PERIC',
'CompanyName': 'Pericles Comidas clásicas',
'ContactName': 'Guillermo Fernández',
'ContactTitle': 'Sales Representative',
'Address': 'Calle Dr. Jorge Cash 321',
'City': 'México D.F.',
'PostalCode': '05033',
'Country': 'Mexico',
'Phone': '(5) 552-3745',
'Fax': '(5) 545-3745'
}, {
'Id': 'PICCO',
'CompanyName': 'Piccolo und mehr',
'ContactName': 'Georg Pipps',
'ContactTitle': 'Sales Manager',
'Address': 'Geislweg 14',
'City': 'Salzburg',
'PostalCode': '5020',
'Country': 'Austria',
'Phone': '6562-9722',
'Fax': '6562-9723'
}, {
'Id': 'PRINI',
'CompanyName': 'Princesa Isabel Vinhos',
'ContactName': 'Isabel de Castro',
'ContactTitle': 'Sales Representative',
'Address': 'Estrada da saúde n. 58',
'City': 'Lisboa',
'PostalCode': '1756',
'Country': 'Portugal',
'Phone': '(1) 356-5634'
}, {
'Id': 'QUEDE',
'CompanyName': 'Que Delícia',
'ContactName': 'Bernardo Batista',
'ContactTitle': 'Accounting Manager',
'Address': 'Rua da Panificadora, 12',
'City': 'Rio de Janeiro',
'Region': 'RJ',
'PostalCode': '02389-673',
'Country': 'Brazil',
'Phone': '(21) 555-4252',
'Fax': '(21) 555-4545'
}, {
'Id': 'QUEEN',
'CompanyName': 'Queen Cozinha',
'ContactName': 'Lúcia Carvalho',
'ContactTitle': 'Marketing Assistant',
'Address': 'Alameda dos Canàrios, 891',
'City': 'Sao Paulo',
'Region': 'SP',
'PostalCode': '05487-020',
'Country': 'Brazil',
'Phone': '(11) 555-1189'
}, {
'Id': 'QUICK',
'CompanyName': 'QUICK-Stop',
'ContactName': 'Horst Kloss',
'ContactTitle': 'Accounting Manager',
'Address': 'Taucherstraße 10',
'City': 'Cunewalde',
'PostalCode': '01307',
'Country': 'Germany',
'Phone': '0372-035188'
}, {
'Id': 'RANCH',
'CompanyName': 'Rancho grande',
'ContactName': 'Sergio Gutiérrez',
'ContactTitle': 'Sales Representative',
'Address': 'Av. del Libertador 900',
'City': 'Buenos Aires',
'PostalCode': '1010',
'Country': 'Argentina',
'Phone': '(1) 123-5555',
'Fax': '(1) 123-5556'
}, {
'Id': 'RATTC',
'CompanyName': 'Rattlesnake Canyon Grocery',
'ContactName': 'Paula Wilson',
'ContactTitle': 'Assistant Sales Representative',
'Address': '2817 Milton Dr.',
'City': 'Albuquerque',
'Region': 'NM',
'PostalCode': '87110',
'Country': 'USA',
'Phone': '(505) 555-5939',
'Fax': '(505) 555-3620'
}, {
'Id': 'REGGC',
'CompanyName': 'Reggiani Caseifici',
'ContactName': 'Maurizio Moroni',
'ContactTitle': 'Sales Associate',
'Address': 'Strada Provinciale 124',
'City': 'Reggio Emilia',
'PostalCode': '42100',
'Country': 'Italy',
'Phone': '0522-556721',
'Fax': '0522-556722'
}, {
'Id': 'RICAR',
'CompanyName': 'Ricardo Adocicados',
'ContactName': 'Janete Limeira',
'ContactTitle': 'Assistant Sales Agent',
'Address': 'Av. Copacabana, 267',
'City': 'Rio de Janeiro',
'Region': 'RJ',
'PostalCode': '02389-890',
'Country': 'Brazil',
'Phone': '(21) 555-3412'
}, {
'Id': 'RICSU',
'CompanyName': 'Richter Supermarkt',
'ContactName': 'Michael Holz',
'ContactTitle': 'Sales Manager',
'Address': 'Grenzacherweg 237',
'City': 'Genève',
'PostalCode': '1203',
'Country': 'Switzerland',
'Phone': '0897-034214'
}, {
'Id': 'ROMEY',
'CompanyName': 'Romero y tomillo',
'ContactName': 'Alejandra Camino',
'ContactTitle': 'Accounting Manager',
'Address': 'Gran Vía, 1',
'City': 'Madrid',
'PostalCode': '28001',
'Country': 'Spain',
'Phone': '(91) 745 6200',
'Fax': '(91) 745 6210'
}, {
'Id': 'SANTG',
'CompanyName': 'Santé Gourmet',
'ContactName': 'Jonas Bergulfsen',
'ContactTitle': 'Owner',
'Address': 'Erling Skakkes gate 78',
'City': 'Stavern',
'PostalCode': '4110',
'Country': 'Norway',
'Phone': '07-98 92 35',
'Fax': '07-98 92 47'
}, {
'Id': 'SAVEA',
'CompanyName': 'Save-a-lot Markets',
'ContactName': 'Jose Pavarotti',
'ContactTitle': 'Sales Representative',
'Address': '187 Suffolk Ln.',
'City': 'Boise',
'Region': 'ID',
'PostalCode': '83720',
'Country': 'USA',
'Phone': '(208) 555-8097'
}, {
'Id': 'SEVES',
'CompanyName': 'Seven Seas Imports',
'ContactName': 'Hari Kumar',
'ContactTitle': 'Sales Manager',
'Address': '90 Wadhurst Rd.',
'City': 'London',
'PostalCode': 'OX15 4NB',
'Country': 'UK',
'Phone': '(171) 555-1717',
'Fax': '(171) 555-5646'
}, {
'Id': 'SIMOB',
'CompanyName': 'Simons bistro',
'ContactName': 'Jytte Petersen',
'ContactTitle': 'Owner',
'Address': 'Vinbæltet 34',
'City': 'Kobenhavn',
'PostalCode': '1734',
'Country': 'Denmark',
'Phone': '31 12 34 56',
'Fax': '31 13 35 57'
}, {
'Id': 'SPECD',
'CompanyName': 'Spécialités du monde',
'ContactName': 'Dominique Perrier',
'ContactTitle': 'Marketing Manager',
'Address': '25, rue Lauriston',
'City': 'Paris',
'PostalCode': '75016',
'Country': 'France',
'Phone': '(1) 47.55.60.10',
'Fax': '(1) 47.55.60.20'
}, {
'Id': 'SPLIR',
'CompanyName': 'Split Rail Beer & Ale',
'ContactName': 'Art Braunschweiger',
'ContactTitle': 'Sales Manager',
'Address': 'P.O. Box 555',
'City': 'Lander',
'Region': 'WY',
'PostalCode': '82520',
'Country': 'USA',
'Phone': '(307) 555-4680',
'Fax': '(307) 555-6525'
}, {
'Id': 'SUPRD',
'CompanyName': 'Suprêmes délices',
'ContactName': 'Pascale Cartrain',
'ContactTitle': 'Accounting Manager',
'Address': 'Boulevard Tirou, 255',
'City': 'Charleroi',
'PostalCode': 'B-6000',
'Country': 'Belgium',
'Phone': '(071) 23 67 22 20',
'Fax': '(071) 23 67 22 21'
}, {
'Id': 'THEBI',
'CompanyName': 'The Big Cheese',
'ContactName': 'Liz Nixon',
'ContactTitle': 'Marketing Manager',
'Address': '89 Jefferson Way Suite 2',
'City': 'Portland',
'Region': 'OR',
'PostalCode': '97201',
'Country': 'USA',
'Phone': '(503) 555-3612'
}, {
'Id': 'THECR',
'CompanyName': 'The Cracker Box',
'ContactName': 'Liu Wong',
'ContactTitle': 'Marketing Assistant',
'Address': '55 Grizzly Peak Rd.',
'City': 'Butte',
'Region': 'MT',
'PostalCode': '59801',
'Country': 'USA',
'Phone': '(406) 555-5834',
'Fax': '(406) 555-8083'
}, {
'Id': 'TOMSP',
'CompanyName': 'Toms Spezialitäten',
'ContactName': 'Karin Josephs',
'ContactTitle': 'Marketing Manager',
'Address': 'Luisenstr. 48',
'City': 'Münster',
'PostalCode': '44087',
'Country': 'Germany',
'Phone': '0251-031259',
'Fax': '0251-035695'
}, {
'Id': 'TORTU',
'CompanyName': 'Tortuga Restaurante',
'ContactName': 'Miguel Angel Paolino',
'ContactTitle': 'Owner',
'Address': 'Avda. Azteca 123',
'City': 'México D.F.',
'PostalCode': '05033',
'Country': 'Mexico',
'Phone': '(5) 555-2933'
}, {
'Id': 'TRADH',
'CompanyName': 'Tradição Hipermercados',
'ContactName': 'Anabela Domingues',
'ContactTitle': 'Sales Representative',
'Address': 'Av. Inês de Castro, 414',
'City': 'Sao Paulo',
'Region': 'SP',
'PostalCode': '05634-030',
'Country': 'Brazil',
'Phone': '(11) 555-2167',
'Fax': '(11) 555-2168'
}, {
'Id': 'VAFFE',
'CompanyName': 'Vaffeljernet',
'ContactName': 'Palle Ibsen',
'ContactTitle': 'Sales Manager',
'Address': 'Smagsloget 45',
'City': 'Århus',
'PostalCode': '8200',
'Country': 'Denmark',
'Phone': '86 21 32 43',
'Fax': '86 22 33 44'
}, {
'Id': 'VICTE',
'CompanyName': 'Victuailles en stock',
'ContactName': 'Mary Saveley',
'ContactTitle': 'Sales Agent',
'Address': '2, rue du Commerce',
'City': 'Lyon',
'PostalCode': '69004',
'Country': 'France',
'Phone': '78.32.54.86',
'Fax': '78.32.54.87'
}, {
'Id': 'WANDK',
'CompanyName': 'Die Wandernde Kuh',
'ContactName': 'Rita Müller',
'ContactTitle': 'Sales Representative',
'Address': 'Adenauerallee 900',
'City': 'Stuttgart',
'PostalCode': '70563',
'Country': 'Germany',
'Phone': '0711-020361',
'Fax': '0711-035428'
}, {
'Id': 'WARTH',
'CompanyName': 'Wartian Herkku',
'ContactName': 'Pirkko Koskitalo',
'ContactTitle': 'Accounting Manager',
'Address': 'Torikatu 38',
'City': 'Oulu',
'PostalCode': '90110',
'Country': 'Finland',
'Phone': '981-443655',
'Fax': '981-443655'
}, {
'Id': 'WELLI',
'CompanyName': 'Wellington Importadora',
'ContactName': 'Paula Parente',
'ContactTitle': 'Sales Manager',
'Address': 'Rua do Mercado, 12',
'City': 'Resende',
'Region': 'SP',
'PostalCode': '08737-363',
'Country': 'Brazil',
'Phone': '(14) 555-8122'
}, {
'Id': 'WHITC',
'CompanyName': 'White Clover Markets',
'ContactName': 'Karl Jablonski',
'ContactTitle': 'Owner',
'Address': '305 - 14th Ave. S. Suite 3B',
'City': 'Seattle',
'Region': 'WA',
'PostalCode': '98128',
'Country': 'USA',
'Phone': '(206) 555-4112',
'Fax': '(206) 555-4115'
}, {
'Id': 'WILMK',
'CompanyName': 'Wilman Kala',
'ContactName': 'Matti Karttunen',
'ContactTitle': 'Owner/Marketing Assistant',
'Address': 'Keskuskatu 45',
'City': 'Helsinki',
'PostalCode': '21240',
'Country': 'Finland',
'Phone': '90-224 8858',
'Fax': '90-224 8858'
}, {
'Id': 'WOLZA',
'CompanyName': 'Wolski Zajazd',
'ContactName': 'Zbyszek Piestrzeniewicz',
'ContactTitle': 'Owner',
'Address': 'ul. Filtrowa 68',
'City': 'Warszawa',
'PostalCode': '01-012',
'Country': 'Poland',
'Phone': '(26) 642-7012',
'Fax': '(26) 642-7012'
}];
You can use the ngFor Angular directive to dynamically generate column declarations.
import { Component } from '@angular/core';
import { sampleProducts } from './products';
interface ColumnSetting {
field: string;
title: string;
format?: string;
type: 'text' | 'numeric' | 'boolean' | 'date';
}
@Component({
selector: 'my-app',
template: `
<kendo-grid
[kendoGridBinding]="gridData"
[filterable]="true"
scrollable="none"
>
<kendo-grid-column
*ngFor="let column of columns"
field="{{column.field}}"
title="{{column.title}}"
format="{{column.format}}"
filter="{{column.type}}"
></kendo-grid-column>
</kendo-grid>
`
})
export class AppComponent {
public gridData: any[] = sampleProducts;
public columns: ColumnSetting[] = [
{
field: 'ProductName',
title: 'Product Name',
type: 'text'
}, {
field: 'UnitPrice',
format: '{0:c}',
title: 'Unit Price',
type: 'numeric'
}, {
field: 'FirstOrderedOn',
format: '{0:d}',
title: 'First Ordered',
type: 'date'
}
];
}
import { NgModule } from '@angular/core';
import { BrowserModule } from '@angular/platform-browser';
import { BrowserAnimationsModule } from '@angular/platform-browser/animations';
import { FormsModule } from '@angular/forms';
import { GridModule } from '@progress/kendo-angular-grid';
import { AppComponent } from './app.component';
@NgModule({
imports: [ BrowserModule, BrowserAnimationsModule, FormsModule, GridModule ],
declarations: [ AppComponent ],
bootstrap: [ AppComponent ]
})
export class AppModule { }
import { enableProdMode } from '@angular/core';
import { platformBrowserDynamic } from '@angular/platform-browser-dynamic';
import { AppModule } from './ng.module';
enableProdMode();
const platform = platformBrowserDynamic();
platform.bootstrapModule(AppModule);
export const sampleProducts = [
{
"ProductID": 1,
"ProductName": "Chai",
"SupplierID": 1,
"CategoryID": 1,
"QuantityPerUnit": "10 boxes x 20 bags",
"UnitPrice": 18,
"UnitsInStock": 39,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
},
"FirstOrderedOn": new Date(1996, 8, 20)
},
{
"ProductID": 2,
"ProductName": "Chang",
"SupplierID": 1,
"CategoryID": 1,
"QuantityPerUnit": "24 - 12 oz bottles",
"UnitPrice": 19,
"UnitsInStock": 17,
"UnitsOnOrder": 40,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
},
"FirstOrderedOn": new Date(1996, 7, 12)
},
{
"ProductID": 3,
"ProductName": "Aniseed Syrup",
"SupplierID": 1,
"CategoryID": 2,
"QuantityPerUnit": "12 - 550 ml bottles",
"UnitPrice": 10,
"UnitsInStock": 13,
"UnitsOnOrder": 70,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
},
"FirstOrderedOn": new Date(1996, 8, 26)
},
{
"ProductID": 4,
"ProductName": "Chef Anton's Cajun Seasoning",
"SupplierID": 2,
"CategoryID": 2,
"QuantityPerUnit": "48 - 6 oz jars",
"UnitPrice": 22,
"UnitsInStock": 53,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
},
"FirstOrderedOn": new Date(1996, 9, 19)
},
{
"ProductID": 5,
"ProductName": "Chef Anton's Gumbo Mix",
"SupplierID": 2,
"CategoryID": 2,
"QuantityPerUnit": "36 boxes",
"UnitPrice": 21.35,
"UnitsInStock": 0,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
},
"FirstOrderedOn": new Date(1996, 7, 17)
},
{
"ProductID": 6,
"ProductName": "Grandma's Boysenberry Spread",
"SupplierID": 3,
"CategoryID": 2,
"QuantityPerUnit": "12 - 8 oz jars",
"UnitPrice": 25,
"UnitsInStock": 120,
"UnitsOnOrder": 0,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
},
"FirstOrderedOn": new Date(1996, 9, 19)
},
{
"ProductID": 7,
"ProductName": "Uncle Bob's Organic Dried Pears",
"SupplierID": 3,
"CategoryID": 7,
"QuantityPerUnit": "12 - 1 lb pkgs.",
"UnitPrice": 30,
"UnitsInStock": 15,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 7,
"CategoryName": "Produce",
"Description": "Dried fruit and bean curd"
},
"FirstOrderedOn": new Date(1996, 7, 22)
},
{
"ProductID": 8,
"ProductName": "Northwoods Cranberry Sauce",
"SupplierID": 3,
"CategoryID": 2,
"QuantityPerUnit": "12 - 12 oz jars",
"UnitPrice": 40,
"UnitsInStock": 6,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
},
"FirstOrderedOn": new Date(1996, 11, 1)
},
{
"ProductID": 9,
"ProductName": "Mishi Kobe Niku",
"SupplierID": 4,
"CategoryID": 6,
"QuantityPerUnit": "18 - 500 g pkgs.",
"UnitPrice": 97,
"UnitsInStock": 29,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 6,
"CategoryName": "Meat/Poultry",
"Description": "Prepared meats"
},
"FirstOrderedOn": new Date(1997, 1, 21)
},
{
"ProductID": 10,
"ProductName": "Ikura",
"SupplierID": 4,
"CategoryID": 8,
"QuantityPerUnit": "12 - 200 ml jars",
"UnitPrice": 31,
"UnitsInStock": 31,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
},
"FirstOrderedOn": new Date(1996, 8, 5)
}
];
export const products = [{
"ProductID": 1,
"ProductName": "Chai",
"SupplierID": 1,
"CategoryID": 1,
"QuantityPerUnit": "10 boxes x 20 bags",
"UnitPrice": 18.0000,
"UnitsInStock": 39,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
}
}, {
"ProductID": 2,
"ProductName": "Chang",
"SupplierID": 1,
"CategoryID": 1,
"QuantityPerUnit": "24 - 12 oz bottles",
"UnitPrice": 19.0000,
"UnitsInStock": 17,
"UnitsOnOrder": 40,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
}
}, {
"ProductID": 3,
"ProductName": "Aniseed Syrup",
"SupplierID": 1,
"CategoryID": 2,
"QuantityPerUnit": "12 - 550 ml bottles",
"UnitPrice": 10.0000,
"UnitsInStock": 13,
"UnitsOnOrder": 70,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
}
}, {
"ProductID": 4,
"ProductName": "Chef Anton's Cajun Seasoning",
"SupplierID": 2,
"CategoryID": 2,
"QuantityPerUnit": "48 - 6 oz jars",
"UnitPrice": 22.0000,
"UnitsInStock": 53,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
}
}, {
"ProductID": 5,
"ProductName": "Chef Anton's Gumbo Mix",
"SupplierID": 2,
"CategoryID": 2,
"QuantityPerUnit": "36 boxes",
"UnitPrice": 21.3500,
"UnitsInStock": 0,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
}
}, {
"ProductID": 6,
"ProductName": "Grandma's Boysenberry Spread",
"SupplierID": 3,
"CategoryID": 2,
"QuantityPerUnit": "12 - 8 oz jars",
"UnitPrice": 25.0000,
"UnitsInStock": 120,
"UnitsOnOrder": 0,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
}
}, {
"ProductID": 7,
"ProductName": "Uncle Bob's Organic Dried Pears",
"SupplierID": 3,
"CategoryID": 7,
"QuantityPerUnit": "12 - 1 lb pkgs.",
"UnitPrice": 30.0000,
"UnitsInStock": 15,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 7,
"CategoryName": "Produce",
"Description": "Dried fruit and bean curd"
}
}, {
"ProductID": 8,
"ProductName": "Northwoods Cranberry Sauce",
"SupplierID": 3,
"CategoryID": 2,
"QuantityPerUnit": "12 - 12 oz jars",
"UnitPrice": 40.0000,
"UnitsInStock": 6,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
}
}, {
"ProductID": 9,
"ProductName": "Mishi Kobe Niku",
"SupplierID": 4,
"CategoryID": 6,
"QuantityPerUnit": "18 - 500 g pkgs.",
"UnitPrice": 97.0000,
"UnitsInStock": 29,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 6,
"CategoryName": "Meat/Poultry",
"Description": "Prepared meats"
}
}, {
"ProductID": 10,
"ProductName": "Ikura",
"SupplierID": 4,
"CategoryID": 8,
"QuantityPerUnit": "12 - 200 ml jars",
"UnitPrice": 31.0000,
"UnitsInStock": 31,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
}
}, {
"ProductID": 11,
"ProductName": "Queso Cabrales",
"SupplierID": 5,
"CategoryID": 4,
"QuantityPerUnit": "1 kg pkg.",
"UnitPrice": 21.0000,
"UnitsInStock": 22,
"UnitsOnOrder": 30,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
}
}, {
"ProductID": 12,
"ProductName": "Queso Manchego La Pastora",
"SupplierID": 5,
"CategoryID": 4,
"QuantityPerUnit": "10 - 500 g pkgs.",
"UnitPrice": 38.0000,
"UnitsInStock": 86,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
}
}, {
"ProductID": 13,
"ProductName": "Konbu",
"SupplierID": 6,
"CategoryID": 8,
"QuantityPerUnit": "2 kg box",
"UnitPrice": 6.0000,
"UnitsInStock": 24,
"UnitsOnOrder": 0,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
}
}, {
"ProductID": 14,
"ProductName": "Tofu",
"SupplierID": 6,
"CategoryID": 7,
"QuantityPerUnit": "40 - 100 g pkgs.",
"UnitPrice": 23.2500,
"UnitsInStock": 35,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 7,
"CategoryName": "Produce",
"Description": "Dried fruit and bean curd"
}
}, {
"ProductID": 15,
"ProductName": "Genen Shouyu",
"SupplierID": 6,
"CategoryID": 2,
"QuantityPerUnit": "24 - 250 ml bottles",
"UnitPrice": 15.5000,
"UnitsInStock": 39,
"UnitsOnOrder": 0,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
}
}, {
"ProductID": 16,
"ProductName": "Pavlova",
"SupplierID": 7,
"CategoryID": 3,
"QuantityPerUnit": "32 - 500 g boxes",
"UnitPrice": 17.4500,
"UnitsInStock": 29,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
}
}, {
"ProductID": 17,
"ProductName": "Alice Mutton",
"SupplierID": 7,
"CategoryID": 6,
"QuantityPerUnit": "20 - 1 kg tins",
"UnitPrice": 39.0000,
"UnitsInStock": 0,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 6,
"CategoryName": "Meat/Poultry",
"Description": "Prepared meats"
}
}, {
"ProductID": 18,
"ProductName": "Carnarvon Tigers",
"SupplierID": 7,
"CategoryID": 8,
"QuantityPerUnit": "16 kg pkg.",
"UnitPrice": 62.5000,
"UnitsInStock": 42,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
}
}, {
"ProductID": 19,
"ProductName": "Teatime Chocolate Biscuits",
"SupplierID": 8,
"CategoryID": 3,
"QuantityPerUnit": "10 boxes x 12 pieces",
"UnitPrice": 9.2000,
"UnitsInStock": 25,
"UnitsOnOrder": 0,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
}
}, {
"ProductID": 20,
"ProductName": "Sir Rodney's Marmalade",
"SupplierID": 8,
"CategoryID": 3,
"QuantityPerUnit": "30 gift boxes",
"UnitPrice": 81.0000,
"UnitsInStock": 40,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
}
}, {
"ProductID": 21,
"ProductName": "Sir Rodney's Scones",
"SupplierID": 8,
"CategoryID": 3,
"QuantityPerUnit": "24 pkgs. x 4 pieces",
"UnitPrice": 10.0000,
"UnitsInStock": 3,
"UnitsOnOrder": 40,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
}
}, {
"ProductID": 22,
"ProductName": "Gustaf's Knäckebröd",
"SupplierID": 9,
"CategoryID": 5,
"QuantityPerUnit": "24 - 500 g pkgs.",
"UnitPrice": 21.0000,
"UnitsInStock": 104,
"UnitsOnOrder": 0,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 5,
"CategoryName": "Grains/Cereals",
"Description": "Breads, crackers, pasta, and cereal"
}
}, {
"ProductID": 23,
"ProductName": "Tunnbröd",
"SupplierID": 9,
"CategoryID": 5,
"QuantityPerUnit": "12 - 250 g pkgs.",
"UnitPrice": 9.0000,
"UnitsInStock": 61,
"UnitsOnOrder": 0,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 5,
"CategoryName": "Grains/Cereals",
"Description": "Breads, crackers, pasta, and cereal"
}
}, {
"ProductID": 24,
"ProductName": "Guaraná Fantástica",
"SupplierID": 10,
"CategoryID": 1,
"QuantityPerUnit": "12 - 355 ml cans",
"UnitPrice": 4.5000,
"UnitsInStock": 20,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
}
}, {
"ProductID": 25,
"ProductName": "NuNuCa Nuß-Nougat-Creme",
"SupplierID": 11,
"CategoryID": 3,
"QuantityPerUnit": "20 - 450 g glasses",
"UnitPrice": 14.0000,
"UnitsInStock": 76,
"UnitsOnOrder": 0,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
}
}, {
"ProductID": 26,
"ProductName": "Gumbär Gummibärchen",
"SupplierID": 11,
"CategoryID": 3,
"QuantityPerUnit": "100 - 250 g bags",
"UnitPrice": 31.2300,
"UnitsInStock": 15,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
}
}, {
"ProductID": 27,
"ProductName": "Schoggi Schokolade",
"SupplierID": 11,
"CategoryID": 3,
"QuantityPerUnit": "100 - 100 g pieces",
"UnitPrice": 43.9000,
"UnitsInStock": 49,
"UnitsOnOrder": 0,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
}
}, {
"ProductID": 28,
"ProductName": "Rössle Sauerkraut",
"SupplierID": 12,
"CategoryID": 7,
"QuantityPerUnit": "25 - 825 g cans",
"UnitPrice": 45.6000,
"UnitsInStock": 26,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 7,
"CategoryName": "Produce",
"Description": "Dried fruit and bean curd"
}
}, {
"ProductID": 29,
"ProductName": "Thüringer Rostbratwurst",
"SupplierID": 12,
"CategoryID": 6,
"QuantityPerUnit": "50 bags x 30 sausgs.",
"UnitPrice": 123.7900,
"UnitsInStock": 0,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 6,
"CategoryName": "Meat/Poultry",
"Description": "Prepared meats"
}
}, {
"ProductID": 30,
"ProductName": "Nord-Ost Matjeshering",
"SupplierID": 13,
"CategoryID": 8,
"QuantityPerUnit": "10 - 200 g glasses",
"UnitPrice": 25.8900,
"UnitsInStock": 10,
"UnitsOnOrder": 0,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
}
}, {
"ProductID": 31,
"ProductName": "Gorgonzola Telino",
"SupplierID": 14,
"CategoryID": 4,
"QuantityPerUnit": "12 - 100 g pkgs",
"UnitPrice": 12.5000,
"UnitsInStock": 0,
"UnitsOnOrder": 70,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
}
}, {
"ProductID": 32,
"ProductName": "Mascarpone Fabioli",
"SupplierID": 14,
"CategoryID": 4,
"QuantityPerUnit": "24 - 200 g pkgs.",
"UnitPrice": 32.0000,
"UnitsInStock": 9,
"UnitsOnOrder": 40,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
}
}, {
"ProductID": 33,
"ProductName": "Geitost",
"SupplierID": 15,
"CategoryID": 4,
"QuantityPerUnit": "500 g",
"UnitPrice": 2.5000,
"UnitsInStock": 112,
"UnitsOnOrder": 0,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
}
}, {
"ProductID": 34,
"ProductName": "Sasquatch Ale",
"SupplierID": 16,
"CategoryID": 1,
"QuantityPerUnit": "24 - 12 oz bottles",
"UnitPrice": 14.0000,
"UnitsInStock": 111,
"UnitsOnOrder": 0,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
}
}, {
"ProductID": 35,
"ProductName": "Steeleye Stout",
"SupplierID": 16,
"CategoryID": 1,
"QuantityPerUnit": "24 - 12 oz bottles",
"UnitPrice": 18.0000,
"UnitsInStock": 20,
"UnitsOnOrder": 0,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
}
}, {
"ProductID": 36,
"ProductName": "Inlagd Sill",
"SupplierID": 17,
"CategoryID": 8,
"QuantityPerUnit": "24 - 250 g jars",
"UnitPrice": 19.0000,
"UnitsInStock": 112,
"UnitsOnOrder": 0,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
}
}, {
"ProductID": 37,
"ProductName": "Gravad lax",
"SupplierID": 17,
"CategoryID": 8,
"QuantityPerUnit": "12 - 500 g pkgs.",
"UnitPrice": 26.0000,
"UnitsInStock": 11,
"UnitsOnOrder": 50,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
}
}, {
"ProductID": 38,
"ProductName": "Côte de Blaye",
"SupplierID": 18,
"CategoryID": 1,
"QuantityPerUnit": "12 - 75 cl bottles",
"UnitPrice": 263.5000,
"UnitsInStock": 17,
"UnitsOnOrder": 0,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
}
}, {
"ProductID": 39,
"ProductName": "Chartreuse verte",
"SupplierID": 18,
"CategoryID": 1,
"QuantityPerUnit": "750 cc per bottle",
"UnitPrice": 18.0000,
"UnitsInStock": 69,
"UnitsOnOrder": 0,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
}
}, {
"ProductID": 40,
"ProductName": "Boston Crab Meat",
"SupplierID": 19,
"CategoryID": 8,
"QuantityPerUnit": "24 - 4 oz tins",
"UnitPrice": 18.4000,
"UnitsInStock": 123,
"UnitsOnOrder": 0,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
}
}, {
"ProductID": 41,
"ProductName": "Jack's New England Clam Chowder",
"SupplierID": 19,
"CategoryID": 8,
"QuantityPerUnit": "12 - 12 oz cans",
"UnitPrice": 9.6500,
"UnitsInStock": 85,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
}
}, {
"ProductID": 42,
"ProductName": "Singaporean Hokkien Fried Mee",
"SupplierID": 20,
"CategoryID": 5,
"QuantityPerUnit": "32 - 1 kg pkgs.",
"UnitPrice": 14.0000,
"UnitsInStock": 26,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 5,
"CategoryName": "Grains/Cereals",
"Description": "Breads, crackers, pasta, and cereal"
}
}, {
"ProductID": 43,
"ProductName": "Ipoh Coffee",
"SupplierID": 20,
"CategoryID": 1,
"QuantityPerUnit": "16 - 500 g tins",
"UnitPrice": 46.0000,
"UnitsInStock": 17,
"UnitsOnOrder": 10,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
}
}, {
"ProductID": 44,
"ProductName": "Gula Malacca",
"SupplierID": 20,
"CategoryID": 2,
"QuantityPerUnit": "20 - 2 kg bags",
"UnitPrice": 19.4500,
"UnitsInStock": 27,
"UnitsOnOrder": 0,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
}
}, {
"ProductID": 45,
"ProductName": "Rogede sild",
"SupplierID": 21,
"CategoryID": 8,
"QuantityPerUnit": "1k pkg.",
"UnitPrice": 9.5000,
"UnitsInStock": 5,
"UnitsOnOrder": 70,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
}
}, {
"ProductID": 46,
"ProductName": "Spegesild",
"SupplierID": 21,
"CategoryID": 8,
"QuantityPerUnit": "4 - 450 g glasses",
"UnitPrice": 12.0000,
"UnitsInStock": 95,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
}
}, {
"ProductID": 47,
"ProductName": "Zaanse koeken",
"SupplierID": 22,
"CategoryID": 3,
"QuantityPerUnit": "10 - 4 oz boxes",
"UnitPrice": 9.5000,
"UnitsInStock": 36,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
}
}, {
"ProductID": 48,
"ProductName": "Chocolade",
"SupplierID": 22,
"CategoryID": 3,
"QuantityPerUnit": "10 pkgs.",
"UnitPrice": 12.7500,
"UnitsInStock": 15,
"UnitsOnOrder": 70,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
}
}, {
"ProductID": 49,
"ProductName": "Maxilaku",
"SupplierID": 23,
"CategoryID": 3,
"QuantityPerUnit": "24 - 50 g pkgs.",
"UnitPrice": 20.0000,
"UnitsInStock": 10,
"UnitsOnOrder": 60,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
}
}, {
"ProductID": 50,
"ProductName": "Valkoinen suklaa",
"SupplierID": 23,
"CategoryID": 3,
"QuantityPerUnit": "12 - 100 g bars",
"UnitPrice": 16.2500,
"UnitsInStock": 65,
"UnitsOnOrder": 0,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
}
}, {
"ProductID": 51,
"ProductName": "Manjimup Dried Apples",
"SupplierID": 24,
"CategoryID": 7,
"QuantityPerUnit": "50 - 300 g pkgs.",
"UnitPrice": 53.0000,
"UnitsInStock": 20,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 7,
"CategoryName": "Produce",
"Description": "Dried fruit and bean curd"
}
}, {
"ProductID": 52,
"ProductName": "Filo Mix",
"SupplierID": 24,
"CategoryID": 5,
"QuantityPerUnit": "16 - 2 kg boxes",
"UnitPrice": 7.0000,
"UnitsInStock": 38,
"UnitsOnOrder": 0,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 5,
"CategoryName": "Grains/Cereals",
"Description": "Breads, crackers, pasta, and cereal"
}
}, {
"ProductID": 53,
"ProductName": "Perth Pasties",
"SupplierID": 24,
"CategoryID": 6,
"QuantityPerUnit": "48 pieces",
"UnitPrice": 32.8000,
"UnitsInStock": 0,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": true,
"Category": {
"CategoryID": 6,
"CategoryName": "Meat/Poultry",
"Description": "Prepared meats"
}
}, {
"ProductID": 54,
"ProductName": "Tourtière",
"SupplierID": 25,
"CategoryID": 6,
"QuantityPerUnit": "16 pies",
"UnitPrice": 7.4500,
"UnitsInStock": 21,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 6,
"CategoryName": "Meat/Poultry",
"Description": "Prepared meats"
}
}, {
"ProductID": 55,
"ProductName": "Pâté chinois",
"SupplierID": 25,
"CategoryID": 6,
"QuantityPerUnit": "24 boxes x 2 pies",
"UnitPrice": 24.0000,
"UnitsInStock": 115,
"UnitsOnOrder": 0,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 6,
"CategoryName": "Meat/Poultry",
"Description": "Prepared meats"
}
}, {
"ProductID": 56,
"ProductName": "Gnocchi di nonna Alice",
"SupplierID": 26,
"CategoryID": 5,
"QuantityPerUnit": "24 - 250 g pkgs.",
"UnitPrice": 38.0000,
"UnitsInStock": 21,
"UnitsOnOrder": 10,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 5,
"CategoryName": "Grains/Cereals",
"Description": "Breads, crackers, pasta, and cereal"
}
}, {
"ProductID": 57,
"ProductName": "Ravioli Angelo",
"SupplierID": 26,
"CategoryID": 5,
"QuantityPerUnit": "24 - 250 g pkgs.",
"UnitPrice": 19.5000,
"UnitsInStock": 36,
"UnitsOnOrder": 0,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 5,
"CategoryName": "Grains/Cereals",
"Description": "Breads, crackers, pasta, and cereal"
}
}, {
"ProductID": 58,
"ProductName": "Escargots de Bourgogne",
"SupplierID": 27,
"CategoryID": 8,
"QuantityPerUnit": "24 pieces",
"UnitPrice": 13.2500,
"UnitsInStock": 62,
"UnitsOnOrder": 0,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
}
}, {
"ProductID": 59,
"ProductName": "Raclette Courdavault",
"SupplierID": 28,
"CategoryID": 4,
"QuantityPerUnit": "5 kg pkg.",
"UnitPrice": 55.0000,
"UnitsInStock": 79,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
}
}, {
"ProductID": 60,
"ProductName": "Camembert Pierrot",
"SupplierID": 28,
"CategoryID": 4,
"QuantityPerUnit": "15 - 300 g rounds",
"UnitPrice": 34.0000,
"UnitsInStock": 19,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
}
}, {
"ProductID": 61,
"ProductName": "Sirop d'érable",
"SupplierID": 29,
"CategoryID": 2,
"QuantityPerUnit": "24 - 500 ml bottles",
"UnitPrice": 28.5000,
"UnitsInStock": 113,
"UnitsOnOrder": 0,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
}
}, {
"ProductID": 62,
"ProductName": "Tarte au sucre",
"SupplierID": 29,
"CategoryID": 3,
"QuantityPerUnit": "48 pies",
"UnitPrice": 49.3000,
"UnitsInStock": 17,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
}
}, {
"ProductID": 63,
"ProductName": "Vegie-spread",
"SupplierID": 7,
"CategoryID": 2,
"QuantityPerUnit": "15 - 625 g jars",
"UnitPrice": 43.9000,
"UnitsInStock": 24,
"UnitsOnOrder": 0,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
}
}, {
"ProductID": 64,
"ProductName": "Wimmers gute Semmelknödel",
"SupplierID": 12,
"CategoryID": 5,
"QuantityPerUnit": "20 bags x 4 pieces",
"UnitPrice": 33.2500,
"UnitsInStock": 22,
"UnitsOnOrder": 80,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 5,
"CategoryName": "Grains/Cereals",
"Description": "Breads, crackers, pasta, and cereal"
}
}, {
"ProductID": 65,
"ProductName": "Louisiana Fiery Hot Pepper Sauce",
"SupplierID": 2,
"CategoryID": 2,
"QuantityPerUnit": "32 - 8 oz bottles",
"UnitPrice": 21.0500,
"UnitsInStock": 76,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
}
}, {
"ProductID": 66,
"ProductName": "Louisiana Hot Spiced Okra",
"SupplierID": 2,
"CategoryID": 2,
"QuantityPerUnit": "24 - 8 oz jars",
"UnitPrice": 17.0000,
"UnitsInStock": 4,
"UnitsOnOrder": 100,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
}
}, {
"ProductID": 67,
"ProductName": "Laughing Lumberjack Lager",
"SupplierID": 16,
"CategoryID": 1,
"QuantityPerUnit": "24 - 12 oz bottles",
"UnitPrice": 14.0000,
"UnitsInStock": 52,
"UnitsOnOrder": 0,
"ReorderLevel": 10,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
}
}, {
"ProductID": 68,
"ProductName": "Scottish Longbreads",
"SupplierID": 8,
"CategoryID": 3,
"QuantityPerUnit": "10 boxes x 8 pieces",
"UnitPrice": 12.5000,
"UnitsInStock": 6,
"UnitsOnOrder": 10,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 3,
"CategoryName": "Confections",
"Description": "Desserts, candies, and sweet breads"
}
}, {
"ProductID": 69,
"ProductName": "Gudbrandsdalsost",
"SupplierID": 15,
"CategoryID": 4,
"QuantityPerUnit": "10 kg pkg.",
"UnitPrice": 36.0000,
"UnitsInStock": 26,
"UnitsOnOrder": 0,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
}
}, {
"ProductID": 70,
"ProductName": "Outback Lager",
"SupplierID": 7,
"CategoryID": 1,
"QuantityPerUnit": "24 - 355 ml bottles",
"UnitPrice": 15.0000,
"UnitsInStock": 15,
"UnitsOnOrder": 10,
"ReorderLevel": 30,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
}
}, {
"ProductID": 71,
"ProductName": "Flotemysost",
"SupplierID": 15,
"CategoryID": 4,
"QuantityPerUnit": "10 - 500 g pkgs.",
"UnitPrice": 21.5000,
"UnitsInStock": 26,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
}
}, {
"ProductID": 72,
"ProductName": "Mozzarella di Giovanni",
"SupplierID": 14,
"CategoryID": 4,
"QuantityPerUnit": "24 - 200 g pkgs.",
"UnitPrice": 34.8000,
"UnitsInStock": 14,
"UnitsOnOrder": 0,
"ReorderLevel": 0,
"Discontinued": false,
"Category": {
"CategoryID": 4,
"CategoryName": "Dairy Products",
"Description": "Cheeses"
}
}, {
"ProductID": 73,
"ProductName": "Röd Kaviar",
"SupplierID": 17,
"CategoryID": 8,
"QuantityPerUnit": "24 - 150 g jars",
"UnitPrice": 15.0000,
"UnitsInStock": 101,
"UnitsOnOrder": 0,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 8,
"CategoryName": "Seafood",
"Description": "Seaweed and fish"
}
}, {
"ProductID": 74,
"ProductName": "Longlife Tofu",
"SupplierID": 4,
"CategoryID": 7,
"QuantityPerUnit": "5 kg pkg.",
"UnitPrice": 10.0000,
"UnitsInStock": 4,
"UnitsOnOrder": 20,
"ReorderLevel": 5,
"Discontinued": false,
"Category": {
"CategoryID": 7,
"CategoryName": "Produce",
"Description": "Dried fruit and bean curd"
}
}, {
"ProductID": 75,
"ProductName": "Rhönbräu Klosterbier",
"SupplierID": 12,
"CategoryID": 1,
"QuantityPerUnit": "24 - 0.5 l bottles",
"UnitPrice": 7.7500,
"UnitsInStock": 125,
"UnitsOnOrder": 0,
"ReorderLevel": 25,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
}
}, {
"ProductID": 76,
"ProductName": "Lakkalikööri",
"SupplierID": 23,
"CategoryID": 1,
"QuantityPerUnit": "500 ml",
"UnitPrice": 18.0000,
"UnitsInStock": 57,
"UnitsOnOrder": 0,
"ReorderLevel": 20,
"Discontinued": false,
"Category": {
"CategoryID": 1,
"CategoryName": "Beverages",
"Description": "Soft drinks, coffees, teas, beers, and ales"
}
}, {
"ProductID": 77,
"ProductName": "Original Frankfurter grüne Soße",
"SupplierID": 12,
"CategoryID": 2,
"QuantityPerUnit": "12 boxes",
"UnitPrice": 13.0000,
"UnitsInStock": 32,
"UnitsOnOrder": 0,
"ReorderLevel": 15,
"Discontinued": false,
"Category": {
"CategoryID": 2,
"CategoryName": "Condiments",
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
}
}];