https://www.infopathdev.com:443/forums/45.aspxenCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/14351.aspxFri, 21 Jul 2006 19:03:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:14351sdecou0https://www.infopathdev.com:443/forums/thread/14351.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=14351Could 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.<br /><br />Dim MySysID As Integer<br />Dim myADOAdapter As ADOAdapterObject = thisXDocument.DataAdapters.Item(5)<br /> <br />MySysID = <br />thisXDocument.DOM.selectSingleNode("/dfs:myFields/dfs:queryFields/q:OvertimeLog/@SysID").text<br /> <br />myADOAdapter.Command = "execute dbo.sp_Overtime_Return " + MySysID<br />myADOAdapter.Query()https://www.infopathdev.com:443/forums/thread/14350.aspxFri, 03 Mar 2006 10:03:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:14350K.Ramana Reddy0https://www.infopathdev.com:443/forums/thread/14350.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=14350Hi,<br /><br />Check this link, You can get required infomation,<br /><br /<a target="_blank" href=http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconusingstoredprocedureswithcommand.asp>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconusingstoredprocedureswithcommand.asp</a><br /><br />Thanks.https://www.infopathdev.com:443/forums/thread/12797.aspxWed, 01 Mar 2006 18:59:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:12797pjlasl0https://www.infopathdev.com:443/forums/thread/12797.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=12797I am at my wits end trying to execute a stored procedure from vs.net.<br />I am successfull in executing from jscript, but vs.net syntax is different. can someone please help!!<br /><br />Thanks!