Data Binding in ASP.NET MVC Spreadsheet Control

22 Jul 202624 minutes to read

The Spreadsheet uses DataManager, which supports both RESTful JSON data services and local JavaScript object array binding to a range. The dataSource property can be assigned either with the instance of DataManager or JavaScript object array collection.

NOTE

To bind data to a cell, use cell data binding support.

Local data

To bind local data to the Spreadsheet, you can assign a JavaScript object array to the dataSource property.

Refer to the following code example for local data binding.

@Html.EJS().Spreadsheet("spreadsheet").Sheets((sheet) =>
{
    sheet.Ranges((ranges) =>
    {
        ranges.DataSource(@ViewBag.defaultData).Add();
    }).Add();
}).Render()
public ActionResult Index()
{
    List<object> data = new List<object>()
    {
        new { CustomerName= "Romona Heaslip",  Model= "Taurus",  Color= "Aquamarine",  PaymentMode= "Debit Card",  DeliveryDate= "07/11/2015",  Amount= "8529.22" },
        new { CustomerName= "Clare Batterton",  Model= "Sparrow",  Color= "Pink",  PaymentMode= "Cash On Delivery",  DeliveryDate= "7/13/2016",  Amount= "17866.19" },
        new { CustomerName= "Eamon Traise",  Model= "Grand Cherokee",  Color= "Blue",  PaymentMode= "Net Banking",  DeliveryDate= "09/04/2015",  Amount= "13853.09" },
        new { CustomerName= "Julius Gorner",  Model= "GTO",  Color= "Aquamarine",  PaymentMode= "Credit Card",  DeliveryDate= "12/15/2017",  Amount= "2338.74" },
        new { CustomerName= "Jenna Schoolfield",  Model= "LX",  Color= "Yellow",  PaymentMode= "Credit Card",  DeliveryDate= "10/08/2014",  Amount= "9578.45" },
        new { CustomerName= "Marylynne Harring",  Model= "Catera",  Color= "Green",  PaymentMode= "Cash On Delivery",  DeliveryDate= "7/01/2017",  Amount= "19141.62" },
        new { CustomerName= "Vilhelmina Leipelt",  Model= "7 Series",  Color= "Goldenrod",  PaymentMode= "Credit Card",  DeliveryDate= "12/20/2015",  Amount= "6543.30" },
        new { CustomerName= "Barby Heisler",  Model= "Corvette",  Color= "Red",  PaymentMode= "Credit Card",  DeliveryDate= "11/24/2014",  Amount= "13035.06" },
        new { CustomerName= "Karyn Boik",  Model= "Regal",  Color= "Indigo",  PaymentMode= "Debit Card",  DeliveryDate= "05/12/2014",  Amount= "18488.80" },
        new { CustomerName= "Jeanette Pamplin",  Model= "S4",  Color= "Fuscia",  PaymentMode= "Net Banking",  DeliveryDate= "12/30/2014",  Amount= "12317.04" },
        new { CustomerName= "Cristi Espinos",  Model= "TL",  Color= "Aquamarine",  PaymentMode= "Credit Card",  DeliveryDate= "12/18/2013",  Amount= "6230.13" },
        new { CustomerName= "Issy Humm",  Model= "Club Wagon",  Color= "Pink",  PaymentMode= "Cash On Delivery",  DeliveryDate= "02/02/2015",  Amount= "9709.49" },
        new { CustomerName= "Tuesday Fautly",  Model= "V8 Vantage",  Color= "Crimson",  PaymentMode= "Debit Card",  DeliveryDate= "11/19/2014",  Amount= "9766.10" },
        new { CustomerName= "Rosemaria Thomann",  Model= "Caravan",  Color= "Violet",  PaymentMode= "Net Banking",  DeliveryDate= "02/08/2014",  Amount= "7685.49" },
    };
    ViewBag.DefaultData = data;
    return View();
}

NOTE

The local data source can also be provided as an instance of the DataManager. By default, DataManager uses JsonAdaptor for local data-binding.

Customizing column data mapping

By default, when a data source is bound to a sheet, columns are auto-assigned from the data source fields sequentially. This means that the first field in the data source is assigned to Column A, the second to Column B, and so on, sequentially. However, now you can customize the column assignments by specifying the appropriate field names in the desired order using the fieldsOrder property.

The fieldsOrder property accepts an array of field names. The order of the field names determines the worksheet columns to which the corresponding data source fields are mapped.

The following code example demonstrates how to customize the mapping of column data:

@Html.EJS().Spreadsheet("spreadsheet").Sheets(sheet => {
    sheet.Name("Price Details").Ranges(ranges => {
        ranges.DataSource((IEnumerable<object>)ViewBag.DefaultData).FieldsOrder(ViewBag.Order).Add();
    }).Add();
}).Render()
public ActionResult Index()
{
    List<object> defaultData = new List<object>()
    {
        new { CustomerName= "Romona Heaslip",  Model= "Taurus",  Color= "Aquamarine",  PaymentMode= "Debit Card",  DeliveryDate= "07/11/2015",  Amount= "8529.22" },
        new { CustomerName= "Clare Batterton",  Model= "Sparrow",  Color= "Pink",  PaymentMode= "Cash On Delivery",  DeliveryDate= "7/13/2016",  Amount= "17866.19" },
        new { CustomerName= "Eamon Traise",  Model= "Grand Cherokee",  Color= "Blue",  PaymentMode= "Net Banking",  DeliveryDate= "09/04/2015",  Amount= "13853.09" },
        new { CustomerName= "Julius Gorner",  Model= "GTO",  Color= "Aquamarine",  PaymentMode= "Credit Card",  DeliveryDate= "12/15/2017",  Amount= "2338.74" },
        new { CustomerName= "Jenna Schoolfield",  Model= "LX",  Color= "Yellow",  PaymentMode= "Credit Card",  DeliveryDate= "10/08/2014",  Amount= "9578.45" },
        new { CustomerName= "Marylynne Harring",  Model= "Catera",  Color= "Green",  PaymentMode= "Cash On Delivery",  DeliveryDate= "7/01/2017",  Amount= "19141.62" },
        new { CustomerName= "Vilhelmina Leipelt",  Model= "7 Series",  Color= "Goldenrod",  PaymentMode= "Credit Card",  DeliveryDate= "12/20/2015",  Amount= "6543.30" },
        new { CustomerName= "Barby Heisler",  Model= "Corvette",  Color= "Red",  PaymentMode= "Credit Card",  DeliveryDate= "11/24/2014",  Amount= "13035.06" },
        new { CustomerName= "Karyn Boik",  Model= "Regal",  Color= "Indigo",  PaymentMode= "Debit Card",  DeliveryDate= "05/12/2014",  Amount= "18488.80" },
        new { CustomerName= "Jeanette Pamplin",  Model= "S4",  Color= "Fuscia",  PaymentMode= "Net Banking",  DeliveryDate= "12/30/2014",  Amount= "12317.04" },
        new { CustomerName= "Cristi Espinos",  Model= "TL",  Color= "Aquamarine",  PaymentMode= "Credit Card",  DeliveryDate= "12/18/2013",  Amount= "6230.13" },
        new { CustomerName= "Issy Humm",  Model= "Club Wagon",  Color= "Pink",  PaymentMode= "Cash On Delivery",  DeliveryDate= "02/02/2015",  Amount= "9709.49" },
        new { CustomerName= "Tuesday Fautly",  Model= "V8 Vantage",  Color= "Crimson",  PaymentMode= "Debit Card",  DeliveryDate= "11/19/2014",  Amount= "9766.10" },
        new { CustomerName= "Rosemaria Thomann",  Model= "Caravan",  Color= "Violet",  PaymentMode= "Net Banking",  DeliveryDate= "02/08/2014",  Amount= "7685.49" },
    };
    ViewBag.DefaultData = defaultData;
    string[] fieldOrder = new string[] { "CustomerName", "PaymentMode", "Model", "Color", "Amount", "DeliveryDate" };
    ViewBag.Order = fieldOrder;
    return View();

}

Remote data

To bind remote data to the Spreadsheet control, assign service data as an instance of DataManager to the dataSource property. To interact with remote data source, provide the service endpoint url.

Refer to the following code example for remote data binding.

@Html.EJS().Spreadsheet("spreadsheet").Sheets(sheet =>
  {
      sheet.Name("Shipment Details").Ranges(ranges =>
      {
          ranges.ShowFieldAsHeader(false).StartCell("A2").Query("new ej.data.Query().select(['OrderID', 'CustomerID', 'ShipName', 'ShipCity', 'ShipCountry', 'Freight']).take(200)").DataSource(dataManger =>
   {
       dataManger.Url("https://services.syncfusion.com/js/production/api/Orders").CrossDomain(true);
   }).Add();
      }).Rows(row =>
      {
          row.Cells(cell =>
          {
              cell.Value("Order ID").Add();
              cell.Value("Customer Name").Add();
              cell.Value("Freight").Add();
              cell.Value("Ship Name").Add();
              cell.Value("Ship City").Add();
              cell.Value("Ship Country").Add();
          }).Add();
      }).Columns(column =>
      {
          column.Width(100).Add();
          column.Width(130).Add();
          column.Width(100).Add();
          column.Width(220).Add();
          column.Width(150).Add();
          column.Width(180).Add();
      }).Add();
  }).Render()
public ActionResult Index()
{
    return View();
}

NOTE

By default, DataManager uses ODataAdaptor for remote data-binding.

Binding with OData services

OData is a standardized protocol for accessing data services. You can retrieve data from an OData service using DataManager. The following code example demonstrates remote data binding using an OData service.

@Html.EJS().Spreadsheet("spreadsheet").Created("created").Sheets(sheet =>
  {
      sheet.Name("Order Details").Ranges(ranges =>
      {
        ranges.DataSource(dataManager =>
   {
       dataManager.Url("https://ej2services.syncfusion.com/production/web-services/api/Orders").CrossDomain(true).Adaptor("ODataAdaptor");
   }).Add();
      }).Columns(column =>
      {
          column.Width(80).Add();
          column.Width(80).Add();
          column.Width(80).Add();
          column.Width(80).Add();
          column.Width(80).Add();
          column.Width(80).Add();
          column.Width(280).Add();
          column.Width(180).Add();
          column.Width(80).Add();
          column.Width(180).Add();
          column.Width(180).Add();
      }).Add();
  }).Render()

<script>

    function created() {
        var spreadsheetObj = ej.base.getComponent(document.getElementById('spreadsheet'), 'spreadsheet');
        //Applies cell and number formatting to specified range of the active sheet
        spreadsheetObj.cellFormat({ fontWeight: 'bold', textAlign: 'center', verticalAlign: 'middle' },
            'A1:K1');
    }

</script>
public ActionResult Index()
{
    return View();
}

Web API

You can use WebApiAdaptor to bind spreadsheet with Web API created using OData endpoint.

@Html.EJS().Spreadsheet("spreadsheet").Created("created").Sheets(sheet =>
  {
      sheet.Name("Order Details").Ranges(ranges =>
      {
        ranges.DataSource(dataManager =>
   {
       dataManager.Url("https://ej2services.syncfusion.com/production/web-services/api/Orders").CrossDomain(true).Adaptor("WebApiAdaptor");
   }).Add();
      }).Columns(column =>
      {
          column.Width(80).Add();
          column.Width(80).Add();
          column.Width(80).Add();
          column.Width(80).Add();
          column.Width(80).Add();
          column.Width(80).Add();
          column.Width(280).Add();
          column.Width(180).Add();
          column.Width(80).Add();
          column.Width(180).Add();
          column.Width(180).Add();
      }).Add();
  }).Render()

<script>

    function created() {
        var spreadsheetObj = ej.base.getComponent(document.getElementById('spreadsheet'), 'spreadsheet');
        //Applies cell and number formatting to specified range of the active sheet
        spreadsheetObj.cellFormat({ fontWeight: 'bold', textAlign: 'center', verticalAlign: 'middle' },
            'A1:K1');
    }

</script>
public ActionResult Index()
{
    return View();
}

Cell data binding

The Spreadsheet can bind data to an individual cell in a worksheet. To achieve this, use the value property.

Refer to the following code example for cell data binding.

@Html.EJS().Spreadsheet("spreadsheet").ShowRibbon(false).ShowFormulaBar(false).Sheets(sheet =>
   {
       sheet.Name("Monthly Budget").SelectedRange("D13").Rows(row =>
       {
           row.Cells(cell =>
           {
               cell.Value("Category").Style(new SpreadsheetCellStyle() { FontWeight = FontWeight.Bold, TextAlign = TextAlign.Center }).Add();
               cell.Value("Planned cost").Style(new SpreadsheetCellStyle() { FontWeight = FontWeight.Bold, TextAlign = TextAlign.Center }).Add();
               cell.Value("Actual cost").Style(new SpreadsheetCellStyle() { FontWeight = FontWeight.Bold, TextAlign = TextAlign.Center }).Add();
           }).Add();
           row.Cells(cell =>
           {
               cell.Value("Food").Add();
               cell.Value("$7000").Add();
               cell.Value("$8120").Add();
           }).Add();
           row.Cells(cell =>
           {
               cell.Value("Loan").Add();
               cell.Value("$1500").Add();
               cell.Value("$1500").Add();
           }).Add();
           row.Cells(cell =>
           {
               cell.Value("Medical").Add();
               cell.Value("$300").Add();
               cell.Value("$0").Add();
           }).Add();
           row.Cells(cell =>
           {
               cell.Value("Clothing").Add();
               cell.Value("$400").Add();
               cell.Value("$140").Add();
           }).Add();
           row.Cells(cell =>
           {
               cell.Value("Education").Add();
               cell.Value("$900").Add();
               cell.Value("$750").Add();
           }).Add();
           row.Cells(cell =>
           {
               cell.Value("Insurance").Add();
               cell.Value("$30").Add();
               cell.Value("$30").Add();
           }).Add();
           row.Cells(cell =>
           {
               cell.Value("Utilities").Add();
               cell.Value("$130").Add();
               cell.Value("$160").Add();
           }).Add();
       }).Columns(column =>
       {
           column.Width(110).Add();
           column.Width(115).Add();
           column.Width(110).Add();
           column.Width(100).Add();
       }).Add();
   }).Render()
public ActionResult Index()
{
    return View();
}

NOTE

The cell data binding also supports formula, style, number format, and more.

Dynamic data binding and data source change event

You can dynamically change the Spreadsheet data source by updating the dataSource property of a range in the worksheet. The dataSourceChanged event is triggered when a row is edited, inserted, or deleted within the data source range. The action property in the event arguments indicates whether the operation is an edit, add, or delete action.

The following table defines the arguments of the dataSourceChanged event.

Property Type Description
action string Indicates the type of action, such as edit, add, or delete, performed in the data source range.
data object[] Specifies the modified data for an edit action, new data for an add action, or deleted data for a delete action.
rangeIndex number Specifies the index of the data source range.
sheetIndex number Specifies the index of the worksheet that contains the data source.

NOTE

During an add action, all field values in the event data are initially null. If the primary key must contain a value before the data is sent to the backend service, assign the primary key and then process the change as an edit action.

To trigger the dataSourceChanged event with the add action, insert a row immediately below the end of the data source range.

Bind the dataSourceChanged event to the Spreadsheet and use its event arguments to identify whether an edit, add, or delete action occurred in the data source range.

After running the sample, edit, insert, or delete a row in the data source range and verify that the dataSourceChanged event is triggered with the corresponding action.

<div>
      <button id="changeDataBtn" class='e-btn'>Change Datasource</button>
</div>

@Html.EJS().Spreadsheet("spreadsheet").DataSourceChanged("dataSourceChanged").Sheets((sheet) =>
{
    sheet.Ranges((ranges) =>
    {
        ranges.DataSource(@ViewBag.DefaultData).Add();
    }).Add();
}).Render()

<div>
                        <h4><b>Event Trace</b></h4>
                        <div id="evt">
                                <div style="height:173px;overflow: auto;min-width: 250px;">
                                        <span id="EventLog" style="word-break: normal;"></span>
                                </div>
                                <button id="clearBtn" class='e-btn'>Clear</button>
                        </div>
                </div>

<script>

document.getElementById('changeDataBtn').addEventListener('click', ()=> {
    var spreadsheet = ej.base.getComponent(document.getElementById('spreadsheet'), 'spreadsheet');
    var itemData = [
            {
                'Item Name': 'Casual Shoes',
                'Date': '02/14/2019',
                'Time': '11:34:32 AM',
                'Quantity': 10,
                'Price': 20,
                'Amount': '=D2*E2',
                'Discount': 1,
                'Profit': 10
            },
            {
                'Item Name': 'Sports Shoes',
                'Date': '06/11/2019',
                'Time': '05:56:32 AM',
                'Quantity': 20,
                'Price': 30,
                'Amount': '=D3*E3',
                'Discount': 5,
                'Profit': 50
            } 
        ];
    spreadsheet.sheets[0].ranges[0].dataSource = itemData;
});

document.getElementById('clearBtn').addEventListener('click', ()=> {
    document.getElementById('EventLog').innerHTML = "";
});

function appendElement(html) {
     var span = document.createElement("span");
     span.innerHTML = html;
     var log = document.getElementById('EventLog');
     log.insertBefore(span, log.firstChild);
}

function dataSourceChanged(args) {
    appendElement("Data source changed with" + "<b>&nbsp;" + args.action + "</b> action<hr>");
}

</script>

<style>

#changeDataBtn {
    margin-bottom: 10px;
}

#EventLog b {
  color: #388e3c;
 }

#evt {
  border: 1px solid #dcdcdc;
  padding: 10px;
}

hr {
  margin-top: 0;
  margin-bottom: 0;
}

</style>
public ActionResult Index()
{
    List<object> data = new List<object>()
    {
        new { CustomerName= "Romona Heaslip",  Model= "Taurus",  Color= "Aquamarine",  PaymentMode= "Debit Card",  DeliveryDate= "07/11/2015",  Amount= "8529.22" },
        new { CustomerName= "Clare Batterton",  Model= "Sparrow",  Color= "Pink",  PaymentMode= "Cash On Delivery",  DeliveryDate= "7/13/2016",  Amount= "17866.19" },
        new { CustomerName= "Eamon Traise",  Model= "Grand Cherokee",  Color= "Blue",  PaymentMode= "Net Banking",  DeliveryDate= "09/04/2015",  Amount= "13853.09" },
        new { CustomerName= "Julius Gorner",  Model= "GTO",  Color= "Aquamarine",  PaymentMode= "Credit Card",  DeliveryDate= "12/15/2017",  Amount= "2338.74" },
        new { CustomerName= "Jenna Schoolfield",  Model= "LX",  Color= "Yellow",  PaymentMode= "Credit Card",  DeliveryDate= "10/08/2014",  Amount= "9578.45" },
        new { CustomerName= "Marylynne Harring",  Model= "Catera",  Color= "Green",  PaymentMode= "Cash On Delivery",  DeliveryDate= "7/01/2017",  Amount= "19141.62" },
        new { CustomerName= "Vilhelmina Leipelt",  Model= "7 Series",  Color= "Goldenrod",  PaymentMode= "Credit Card",  DeliveryDate= "12/20/2015",  Amount= "6543.30" },
        new { CustomerName= "Barby Heisler",  Model= "Corvette",  Color= "Red",  PaymentMode= "Credit Card",  DeliveryDate= "11/24/2014",  Amount= "13035.06" },
        new { CustomerName= "Karyn Boik",  Model= "Regal",  Color= "Indigo",  PaymentMode= "Debit Card",  DeliveryDate= "05/12/2014",  Amount= "18488.80" },
        new { CustomerName= "Jeanette Pamplin",  Model= "S4",  Color= "Fuscia",  PaymentMode= "Net Banking",  DeliveryDate= "12/30/2014",  Amount= "12317.04" },
        new { CustomerName= "Cristi Espinos",  Model= "TL",  Color= "Aquamarine",  PaymentMode= "Credit Card",  DeliveryDate= "12/18/2013",  Amount= "6230.13" },
        new { CustomerName= "Issy Humm",  Model= "Club Wagon",  Color= "Pink",  PaymentMode= "Cash On Delivery",  DeliveryDate= "02/02/2015",  Amount= "9709.49" },
        new { CustomerName= "Tuesday Fautly",  Model= "V8 Vantage",  Color= "Crimson",  PaymentMode= "Debit Card",  DeliveryDate= "11/19/2014",  Amount= "9766.10" },
        new { CustomerName= "Rosemaria Thomann",  Model= "Caravan",  Color= "Violet",  PaymentMode= "Net Banking",  DeliveryDate= "02/08/2014",  Amount= "7685.49" },
    };
    ViewBag.DefaultData = data;
    return View();
}

Dynamic data binding using updateRange method

The updateRange method allows you to dynamically update the dataSource in a spreadsheet without manually iterating through each cell. This method is especially useful for efficiently applying bulk updates to a specific range within the spreadsheet.

To use the updateRange method, provide the new dataSource and specify the starting cell for the update using the startCell property of the RangeModel. Additionally, set the sheetIndex to target the appropriate sheet for the update.

The following code example demonstrates how to dynamically update data using the updateRange method.

To update a range dynamically:

  1. Create the new data source.
  2. Specify the starting cell using the startCell property.
  3. Specify the target worksheet using the sheetIndex property.
  4. Pass the configured range to the updateRange method.

After running the sample, verify that the new data is populated from the specified starting cell in the target worksheet.

@Html.EJS().Button("updateDynamicData").Content("Update Dynamic Data").Render()
@Html.EJS().Spreadsheet("spreadsheet").Sheets((sheet) =>
{
    sheet.Ranges((ranges) =>
    {
        ranges.DataSource(@ViewBag.DefaultData).Add();
    }).Add();
}).Render()

<script>

document.getElementById("updateDynamicData").addEventListener('click', function () {
        var spreadsheet = document.getElementById("spreadsheet").ej2_instances[0];
        var newDataCollection = {
            dataSource: [
                {
                    "Payment Mode": "Debit Card",
                    "Delivery Date": "07/11/2015",
                    "Amount": "8529.22",
                },
                {
                    "Payment Mode": "Cash On Delivery",
                    "Delivery Date": "7/13/2016",
                    "Amount": "17866.19",
                },
                {
                    "Payment Mode": "Net Banking",
                    "Delivery Date": "09/04/2015",
                    "Amount": "13853.09",
                },
                {
                    "Payment Mode": "Credit Card",
                    "Delivery Date": "12/15/2017",
                    "Amount": "2338.74",
                },
                {
                    "Payment Mode": "Credit Card",
                    "Delivery Date": "10/08/2014",
                    "Amount": "9578.45",
                },
                {
                    "Payment Mode": "Cash On Delivery",
                    "Delivery Date": "7/01/2017",
                    "Amount": "19141.62",
                },
                {
                    "Payment Mode": "Credit Card",
                    "Delivery Date": "12/20/2015",
                    "Amount": "6543.30",
                },
                {
                    "Payment Mode": "Credit Card",
                    "Delivery Date": "11/24/2014",
                    "Amount": "13035.06",
                },
                {
                    "Payment Mode": "Debit Card",
                    "Delivery Date": "05/12/2014",
                    "Amount": "18488.80",
                },
                {
                    "Payment Mode": "Net Banking",
                    "Delivery Date": "12/30/2014",
                    "Amount": "12317.04",
                },
                {
                    "Payment Mode": "Credit Card",
                    "Delivery Date": "12/18/2013",
                    "Amount": "6230.13",
                },
                {
                    "Payment Mode": "Cash On Delivery",
                    "Delivery Date": "02/02/2015",
                    "Amount": "9709.49",
                },
                {
                    "Payment Mode": "Debit Card",
                    "Delivery Date": "11/19/2014",
                    "Amount": "9766.10",
                },
                {
                    "Payment Mode": "Net Banking",
                    "Delivery Date": "02/08/2014",
                    "Amount": "7685.49",
                },
                {
                    "Payment Mode": "Debit Card",
                    "Delivery Date": "08/05/2016",
                    "Amount": "18012.45",
                },
                {
                    "Payment Mode": "Credit Card",
                    "Delivery Date": "05/30/2016",
                    "Amount": "2785.49",
                },
                {
                    "Payment Mode": "Debit Card",
                    "Delivery Date": "12/10/2016",
                    "Amount": "9967.74",
                },
            ],
            startCell: 'D1',
        };
        spreadsheet.updateRange(newDataCollection, 0);
    });

</script>
public ActionResult Index()
{
    List<object> data = new List<object>()
    {
        new { CustomerName= "Romona Heaslip",  Model= "Taurus",  Color= "Aquamarine"},
        new { CustomerName= "Clare Batterton",  Model= "Sparrow",  Color= "Pink"},
        new { CustomerName= "Eamon Traise",  Model= "Grand Cherokee",  Color= "Blue" },
        new { CustomerName= "Julius Gorner",  Model= "GTO",  Color= "Aquamarine" },
        new { CustomerName= "Jenna Schoolfield",  Model= "LX",  Color= "Yellow" },
        new { CustomerName= "Marylynne Harring",  Model= "Catera",  Color= "Pink"},
        new { CustomerName= "Vilhelmina Leipelt",  Model= "7 Series",  Color= "Goldenrod"},
        new { CustomerName= "Barby Heisler",  Model= "Corvette",  Color= "Red"},
        new { CustomerName= "Karyn Boik",  Model= "Regal",  Color= "Pink"},
        new { CustomerName= "Jeanette Pamplin",  Model= "S4",  Color= "Fuscia"},
        new { CustomerName= "Cristi Espinos",  Model= "TL",  Color= "Aquamarine"},
        new { CustomerName= "Issy Humm",  Model= "Club Wagon",  Color= "Pink" },
        new { CustomerName= "Tuesday Fautly",  Model= "V8 Vantage",  Color= "Crimson"},
        new { CustomerName= "Rosemaria Thomann",  Model= "Caravan",  Color= "Violet"},
    };
    ViewBag.DefaultData = data;
    return View();
}

See Also