// // Query Result ke JSON ??? - Geeks Portal

Query Result ke JSON ???

Last post 02-04-2011 22:02 by iyoumelodic. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 04-30-2009 14:20

    • titasix
    • Top 500 Contributor
    • Joined on 12-13-2007
    • 11199001
    • Posts 9
    • Points 120

    Query Result ke JSON ???

    Salam,

    Bagaimana menghasilkan JSON dari suatu query, misal Select nama,alamat,kota FROM Biodata. Saya menggunakan Web Service ASP/VB.net. 

    Terimakasih 

    • Post Points: 20
  • 01-19-2011 10:55 In reply to

    • joane3005
    • Top 500 Contributor
    • Joined on 01-12-2011
    • Posts 7
    • Points 95

    Re: Query Result ke JSON ???

    pertama bikin class dulu     

    Public Class myJson
            Public Function toJSON(ByVal obyek As Object) As String
                Dim serializer As javascriptserializer
                serializer = New JavaScriptSerializer
                Return serializer.Serialize(obyek)
            End Function
            Public Function toJSON(ByVal obyek As Object, ByVal rekursi As Integer) As String
                Dim serializer As JavaScriptSerializer
                serializer = New JavaScriptSerializer
                serializer.RecursionLimit = rekursi
                Return serializer.Serialize(obyek)
            End Function

       End Class

     

    terus bikin  structure di dalam web service nya

    structure biodata

    dim nama  as string
    dim alamat as string
    dim kota as string

    end structure

     

    Pindahkan data dari datarow ke object biodata

    dim hasil as  New List(Of biodata)

    for each row as datarow in [NamaDataTable].rows

    dim a as new biodata
    with a
    .nama=row("nama")
    .alamat=row("alamat")
    .kota=row("kota")
    end with
    hasil.add (a)

     

    next

    convert object biodata ke json 

     dim Obj as new myjson

     return  obj.tojson(hasil)

     

    udah deh .... 

    joane imoetz ..(",)
    Filed under: ,
    • Post Points: 20
  • 02-04-2011 22:02 In reply to

    • iyoumelodic
    • Not Ranked
    • Joined on 02-04-2011
    • Cisitu Lama
    • Posts 1
    • Points 5

    Re: Query Result ke JSON ???

     Wow hebat!!! Keren

     Pengen banget belajar java tapi kayaknya susah ya??  Di sini ada yang share e-book or panduan buat belajar java ga ya??

     Big Smile

    Saya adalah seorang mahasiswa dari Politeknik Piksi Ganesha angkatan 2008.
    • Post Points: 5
Page 1 of 1 (3 items)