CRIAR MAIS ROTAS DE PESQUISAS UTILIZANDO JSON

   [ô] GET: api/RelatTop/5
        Public Function GetValue(ByVal Inicial As String, ByVal Final As String) As IEnumerable(Of TopPerdas)



            Dim JsSerializer As New JavaScriptSerializer()


            Dim constr As String = [Ô]Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\BANCO\BancoTop10.mdb[Ô]
            Dim con As New OleDb.OleDbConnection(constr)
            Dim cmd As New OleDb.OleDbCommand([Ô]select  N, Produto, PLU, Qtd, Valor, Loja, Sequencia from  TbTop where Data >= [ô][Ô] & Inicial & [Ô][ô] and Data <= [ô][Ô] & Final & [Ô][ô] Order by  Sequencia Asc[Ô])
            cmd.Connection = con

            Dim customers As New List(Of TopPerdas)()


            con.Open()
            Dim sdr As OleDb.OleDbDataReader = cmd.ExecuteReader()
            While sdr.Read()
                customers.Add(New TopPerdas() With { _
                         .Produto = sdr([Ô]Produto[Ô]).ToString(), _
                         .PLU = sdr([Ô]PLU[Ô]).ToString(), _
                         .Qtd = sdr([Ô]Qtd[Ô]).ToString(), _
                         .Valor = sdr([Ô]Valor[Ô]).ToString(), _
                         .Loja = sdr([Ô]Loja[Ô]).ToString() _
                        })



            End While

            con.Close()
            Dim js As JavaScriptSerializer = New JavaScriptSerializer()

            js.MaxJsonLength = Integer.MaxValue
            js.Serialize(customers)
            [ô]Context.Response.Write(js.Serialize(customers))
            Return customers

        End Function 

   <script type = [Ô]text/javascript[Ô]>
        function RelatioTop() {
            var id = $([ô]#Inicial[ô]).val()
            var idd = $([ô]#Final[ô]).val()

            var xmlhttp = new XMLHttpRequest();
            var url = [Ô]http://localhost:49433/api/RelatTop/[Ô] + id + [Ô]/[Ô] + idd;

            xmlhttp.onreadystatechange = function () {
                if (this.readyState == 4 && this.status == 200) {

                    myFunction(this.responseText);

                }
            }
            xmlhttp.open([Ô]GET[Ô], url, true);
            xmlhttp.send();

            function myFunction(response) {
                var arr = JSON.parse(response);
                var i;
                var out = [Ô]<table>[Ô];

                for (i = 0; i < arr.length; i++) {
                    out += [Ô]<tr><td>[Ô] +
                    arr[i].Produto +
                    [Ô]</td><td>[Ô] +
                    arr[i].PLU +
                    [Ô]</td><td>[Ô] +
                    arr[i].Qtd +
                    [Ô]</td><td>[Ô] +
                    arr[i].Valor +
                    [Ô]</td><td>[Ô] +
                    arr[i].Loja +
                    [Ô]</td></tr>[Ô];
                }
                out += [Ô]</table>[Ô];
                document.getElementById([Ô]id01[Ô]).innerHTML = out;
            }
        }

        </script>