Professional Web Applications Themes

Perameterized Query on webservice? - ASP.NET Web Services

I've created the following distributed application: Solution EDSQLWSVC EDEmployerWinClient Project3 Web Service winform app asp.net web app My web services are fine....and I can get data in, out etc. My problem is this: I want to use the data adaptors in the web services for the windows client application. Only problem is...when i want to run a parameterized query in the client application...I get errors flagging the SQL Statement and the Parameterization. Big ones. SO...How do I parameterize the query? I've done it in the Data Adaptor's SQL Statement in the web service, and on the windows form, I've tried: ...

  1. #1

    Default Perameterized Query on webservice?

    I've created the following distributed application:

    Solution

    EDSQLWSVC EDEmployerWinClient Project3
    Web Service winform app asp.net web app


    My web services are fine....and I can get data in, out etc. My problem is
    this:
    I want to use the data adaptors in the web services for the windows client
    application. Only problem is...when i want to run a parameterized query in
    the client application...I get errors flagging the SQL Statement and the
    Parameterization. Big ones. SO...How do I parameterize the query? I've done
    it in the Data Adaptor's SQL Statement in the web service, and on the
    windows form, I've tried:


    Private Sub GetRecs_Click(ByVal sender As System.Object, ByVal e As
    System.EventArgs) Handles GetRecs.Click
    Dim ws As New EDEmployerWinClient.EDEmployerService.EmpService
    ws.Credentials = System.Net.CredentialCache.DefaultCredentials
    EmpRecData.SelectCommand.Parameters("Param1").Valu e = Textbox1.Text
    EmpRecsDa1.Clear()
    EmpRecsDa1.Fill(EmpRecsData)
    EmpRecsData.Merge(ws.GetRecs())
    End Sub


    EDEmployerService is the web reference, and EmpService is the Web Service

    All I want it to do is to Select only the records based on the Parameter. In
    my SQL Statement, I have "SELECT Tbl_One.* FROM Tbl_One WHERE Email =
    Param1"


    This is my first time trying to parameterize a SQL Statement through web
    services..so I'm a bit lost. Any ideas where someone's done something
    similar?


    Steve Nihan Guest

  2. #2

    Default Re: Perameterized Query on webservice?

    Hi,
    Assuming, EmpRecData is your dataset, the following code will not work
    because,
    > EmpRecData.SelectCommand.Parameters("Param1").Valu e = Textbox1.Text
    SelectCommand is a property of DataAdapter and it must be set on a
    DataAdapter like

    EmpRecsDA1.SelectCommand.Parameters("Param1").Valu e = Textbox1.Text


    Regards
    Akila
    [MVP|MCAD]



    Saurabh Nandu Guest

Similar Threads

  1. My webservice won't accept a query
    By Don Vaillancourt in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: May 13th, 01:06 AM
  2. Query of Queries on query New type query
    By david_h in forum Coldfusion Database Access
    Replies: 2
    Last Post: May 6th, 08:55 PM
  3. CAML Query: Multiple Query Fields Issue
    By Jon F. in forum ASP.NET Web Services
    Replies: 0
    Last Post: May 12th, 08:19 PM
  4. Webservice calling a webservice.....Error
    By Peter Nordström in forum ASP.NET Web Services
    Replies: 0
    Last Post: October 21st, 12:02 PM
  5. Replies: 1
    Last Post: July 2nd, 09:09 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139