How to pass vals to webservice funciton RSS

• • Reply
  ayyappan.CNN

  Member

  326 Points

  462 Posts

  How to pass vals to webservice funciton

  Feb 26, 2020 04:45 AM|ayyappan.CNN|LINK

  Hi, 

  I want to pass two variables from aspx page to a function in webservice, then need to get return string, if string having content show (alert) else not required to show, please refer my code here, 

  This is my Aspx code, when the client change the date then, I want to pass parameters viz., Lbl_empid, txt_ResignDate to the following function (ref my below-mentioned webservice code)

  <asp:TextBox ID="txt_ResignDate" runat="server" CssClass="normalText2" MaxLength="10" Width="70px" ></asp:TextBox>
  <asp:Label ID="Lbl_empid" runat="server" ForeColor="Gray"></asp:Label>
  
  AutoComplete.asmx code: <%@ WebService Language="VB" CodeBehind="~/App_Code/MyEngine.vb" Class="Vali_HoliDates" %>
  
  MyEngine.vb
  
   <WebMethod()> Public Function Get_ValiHoliDays(ByVal ip_empid As Integer,_
  ByVal ip_date As Date, ByVal op_val As String) As String()
  
          Dim sCon As New SqlConnection(DBConnectionString)
          Dim param As SqlParameter
          Dim sCmd As New SqlCommand(selectSQL, sCon)
          
          Try
              sCon.Open()
              sCmd.CommandType = CommandType.StoredProcedure
              sCmd.CommandText = "HRMSP_Validate_OffHoliday_Dates"
              sCmd.Parameters.Clear()
              sCmd.Parameters.Add(New SqlParameter("@i_SP_AttribuId", SqlDbType.Int)).Value = 1
              sCmd.Parameters.Add(New SqlParameter("@i_EmployeeID", SqlDbType.Int)).Value = ip_empid
              sCmd.Parameters.Add(New SqlParameter("@i_ValiDate", SqlDbType.Date)).Value = ip_date
              param = New SqlParameter("@o_ErrorStatus", SqlDbType.Int) With {
                  .Direction = ParameterDirection.Output
              }
              sCmd.Parameters.Add(param)
              adapter.Fill(dsDataset)
              If sCmd.Parameters("@o_ErrorStatus").Value = 1 Then
                  op_val = (dsDataset.Tables(0).Rows(0).Item(0).ToString)
              ElseIf sCmd.Parameters("@o_ErrorStatus").Value = 2 Then
                  op_val = ""
              End If
          Finally
              sCon.Close()
          End Try
      End Function
  
  
  Thanks in advance

  Ayyappan.cn,
  Dept of ICT.
  
  Mark post(s) as "Answer" that helped you
• • Reply
  yij sun

  Participant

  1190 Points

  532 Posts

  Re: How to pass vals to webservice funciton

  Feb 27, 2020 05:50 AM|yij sun|LINK

  Hi ayyappan.CNN,

  Accroding to your description,I suggest you could create ajax to call the webservice function.And in the webmethod,you need to return the data.

  More details,you could refer to below article:

  https://www.encodedna.com/2013/05/pass-multiple-para-to-webmethod.htm

  https://www.codeproject.com/Questions/1103159/Asp-net-pass-multiple-parameters-to-jquery-ajax-ca

  Best regards,

  Yijing Sun

  MSDN Community Support
  Please remember to click "Mark as Answer" the responses that resolved your issue.
  If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.