Available in the OSS Version

Data Source - OData Binding

This sample demonstrates how to bind igDataSource component to open data protocol (OData service).
Image Name Notes
Nancy DavolioEducation includes a BA in psychology from Colorado State University in 1970. She also completed "The Art of the Cold Call." Nancy is a member of Toastmasters International.
Andrew FullerAndrew received his BTS commercial in 1974 and a Ph.D. in international marketing from the University of Dallas in 1981. He is fluent in French and Italian and reads German. He joined the company as a sales representative, was promoted to sales manager in January 1992 and to vice president of sales in March 1993. Andrew is a member of the Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association.
Janet LeverlingJanet has a BS degree in chemistry from Boston College (1984). She has also completed a certificate program in food retailing management. Janet was hired as a sales associate in 1991 and promoted to sales representative in February 1992.
Margaret PeacockMargaret holds a BA in English literature from Concordia College (1958) and an MA from the American Institute of Culinary Arts (1966). She was assigned to the London office temporarily from July through November 1992.
Steven BuchananSteven Buchanan graduated from St. Andrews University, Scotland, with a BSC degree in 1976. Upon joining the company as a sales representative in 1992, he spent 6 months in an orientation program at the Seattle office and then returned to his permanent post in London. He was promoted to sales manager in March 1993. Mr. Buchanan has completed the courses "Successful Telemarketing" and "International Sales Management." He is fluent in French.
Michael SuyamaMichael is a graduate of Sussex University (MA, economics, 1983) and the University of California at Los Angeles (MBA, marketing, 1986). He has also taken the courses "Multi-Cultural Selling" and "Time Management for the Sales Professional." He is fluent in Japanese and can read and write French, Portuguese, and Spanish.
Robert KingRobert King served in the Peace Corps and traveled extensively before completing his degree in English at the University of Michigan in 1992, the year he joined the company. After completing a course entitled "Selling in Europe," he was transferred to the London office in March 1993.
Laura CallahanLaura received a BA in psychology from the University of Washington. She has also completed a course in business French. She reads and writes French.
Anne DodsworthAnne has a BA degree in English from St. Lawrence College. She is fluent in French and German.

This sample is designed for a larger screen size.

On mobile, try rotating your screen, view full size, or email to another device.

Code View

Copy to Clipboard 
<!DOCTYPE html>
<html>
<head>
    <title></title>
    <style type="text/css">
        .standard-grid { width:100%; border-top:1px solid #b1b1b1; border-right:1px solid #b1b1b1; border-spacing: 0;}
        .standard-grid th, .standard-grid td { text-align:left; border-bottom:1px solid #b1b1b1; border-left:1px solid #b1b1b1; padding:4px;}
    </style>

    <!-- Ignite UI for jQuery Required Combined CSS Files -->
    <link href="http://cdn-na.infragistics.com/igniteui/2024.2/latest/css/themes/infragistics/infragistics.theme.css" rel="stylesheet" />
    <link href="http://cdn-na.infragistics.com/igniteui/2024.2/latest/css/structure/infragistics.css" rel="stylesheet" />

    <script src="http://ajax.aspnetcdn.com/ajax/modernizr/modernizr-2.8.3.js"></script>
    <script src="http://code.jquery.com/jquery-1.11.3.min.js"></script>
    <script src="http://code.jquery.com/ui/1.11.1/jquery-ui.min.js"></script>

    <!-- Ignite UI for jQuery Required Combined JavaScript Files -->
    <script src="http://cdn-na.infragistics.com/igniteui/2024.2/latest/js/infragistics.core.js"></script>
    <script src="http://cdn-na.infragistics.com/igniteui/2024.2/latest/js/infragistics.lob.js"></script>

</head>
<body>

    <table id="table" class="standard-grid">
        <thead>
            <tr>
                <th>
                    Image
                </th>
                <th>
                    Name
                    
                </th>
                <th>
                    Notes                   
                </th>
            </tr>
        </thead>
        <tbody></tbody>
    </table>
    <br />

    <script>

        $(function () {
            // Renders the table
            var renderTable = function (success, error) {
                var template = "<tr><td><img width='90' height='100' src='${ImageUrl}' /img></td></td><td>${Name}</td><td>{{html Notes}}</td></tr>";
                if (success) {
                    $("#table tbody").empty();
                    $($.ig.tmpl(template, ds.dataView())).appendTo("#table tbody");
                } else {
                    alert(error);
                }
            }

            // The $.ig.DataSchema is used to define the schema of the data
            var oDataSchema = new $.ig.DataSchema("json", { 
                fields: [
                    { name: "Name" },
                    { name: "ImageUrl" },
                    { name: "Notes" }
                ],
                searchField: "d.results"
            });


            // service Url
            var url = "https://www.igniteui.com/api/employees?callback=?";

            // This code creates an $.ig.DataSource bound to oData service
            var ds = new $.ig.DataSource({
                type: "remoteUrl",
                callback: renderTable,
                dataSource: url,
                schema: oDataSchema,
                responseDataKey: "d.results",
                responseDataType: "jsonp",
                responseContentType: "application/json; charset=utf-8"
            });

            // Binds to the underlying data
            ds.dataBind();
        });

    </script>

</body>
</html>