Results 1 to 7 of 7

Thread: OMG - I can't believe I can do this with a WEB SERVICE!!

Threaded View

  1. #1

    Thread Starter
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Lightbulb OMG - I can't believe I can do this with a WEB SERVICE!!

    I have died and gone to heaven.

    Look at this web service declaration!

    Code:
        <WebMethod()> _
        <ScriptMethod(ResponseFormat:=ResponseFormat.Json, UseHttpGet:=False)> _
        Public Function SaveService(ByVal toddtype As String, ByVal fromddtype As String
                                  , ByVal fromwho As String, ByVal VisitId As Integer
                                  , ByVal objReturn As Dictionary(Of String, String)) As String
    Guess what objReturn is!!!!

    It's the original JSON recordset retained as an object in javascript simply passed back and it's now a pair'd up dictionary object for me to bind to my update sproc in a loop!!
    Attached Images Attached Images  

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width