InfoPath Dev

Hilary, Yes that worked...you are a genius...Thank you so much....

HIlary, Part two is not working...after selecting an Id number from the first repeating table, then I want them to select a file number from that list using a select button. Once I have the filenumber then I feed it into another sp, which writes some more data to a second repeating table. I have used this code below, the SSMS profiler shows that ...

Hilary ,The sp was calling a view, but I changed that to a table and it now works...does a view cause this issue. Next is to feed this ID into another sp, that writes to a table. Thanks

Yes, I ran the profiler and it says:  EventClass                       TextData SP:StmtCompleted           SELECT  *   FROM   dbo.vRequest_Test where id = ...

Hi Hilary, Nothing Happens, when I hit the Search button, the code does not bring back any rows back to the repeating table. Not sure what the issue is. The Data Connection named Request_Test is a secondary connection in the form. I am just trying to bring back the rows of data based on what the user selects as an Id on a clicked button. ...

I am trying to execute a stored procedure from my Infopath 2010 two ways . And I get the errors pointed with arrows below. What am I doing wrong.  using Microsoft.Office.InfoPath; using System; using System.Windows.Forms; using System.Xml; using System.Xml.XPath; using mshtml; using System.Data; using ...