Call Stored Procedure from vs.net 2005 - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Call Stored Procedure from vs.net 2005

Last post 07-21-2006 12:03 PM by sdecou. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 03-01-2006 10:59 AM

    • pjlasl
    • Not Ranked
    • Joined on 03-01-2006
    • Posts 1

    Call Stored Procedure from vs.net 2005

    Reply Contact
    I am at my wits end trying to execute a stored procedure from vs.net.
    I am successfull in executing from jscript, but vs.net syntax is different. can someone please help!!

    Thanks!

  • 03-03-2006 02:03 AM In reply to

    Re: Call Stored Procedure from vs.net 2005

    Mark as Answer
    Reply Contact
    Hi,

    Check this link, You can get required infomation,

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconusingstoredprocedureswithcommand.asp

    Thanks.
    K.Ramana Reddy / http://www.ggktech.com
    India.

  • 07-21-2006 12:03 PM In reply to

    • sdecou
    • Not Ranked
    • Joined on 06-06-2006
    • USA
    • Posts 2

    Re: Call Stored Procedure from vs.net 2005

    Mark as Answer
    Reply Contact
    Could someone please email me back with the correct syntax for running this code using Visual Studio.NET in Infopath. I cannot find any help on this and I am receiving an error.

    Dim MySysID As Integer
    Dim myADOAdapter As ADOAdapterObject = thisXDocument.DataAdapters.Item(5)

    MySysID =
    thisXDocument.DOM.selectSingleNode("/dfs:myFields/dfs:queryFields/q:OvertimeLog/@SysID").text

    myADOAdapter.Command = "execute dbo.sp_Overtime_Return " + MySysID
    myADOAdapter.Query()
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.