InfoPath Dev

Hi,   I have designed an infopath form which has repeating table and a button "Insert Data" button. Insert Data button has a rule "Submit using  a data connection" which used a Webservice to insert data into SQL Server. But this works for first row in repeating table. If there are multiple rows in ...

Hi, I am using Infopath 2007, SQL Server 2005 and Visual Studio 2005. I have designed an infopath form where data is submitted to SQL Server using  Webservice. Everything works great for one row.  Now when i add one more row to the repeating table, fills the data and click on button to post data to SQL Server, only first row is ...

Hi Clay,   Can you please email me the examples. I want to use the value of a field (Product Name) in infopath form, in a SQL query. For Example If the value of Product Name is "WebApp", i want to execute  Select productID from Product  where productName='WebApp' And then i want to use the ...

Hi Hilary, Thanks a lot for the reply. Assume i have a simle Table in database emptable with "EmpName", "TaskName" and "Hours" Column. When i design a form i add a drop down list and enter values manually into this drop down list ( e.g. "John", "Mark" etc). Then i select datasource, right click ...

Hi Frederik, Thanks a lot for replying. But i want to save this data into database. What i want is user opens this form. Select his/her name from EmpName drop down list. And in the repeating table add a row, fill Task and Hours. Insert one more row and fill Task and Hours and then hit submit ...

Hi, I am using Infopath2003 still taking baby steps to get familiar with Infopath and i have mixed success.    DataSource Details: SQL Server Table1 have empid and empname  Table2 have empname, task, hours. These two tables have relationshiop on empname column. The issue that i am facing is that i want to create a time ...

Thanks a lot for replying. I got it done. I created a form and then opened Tools-->Forms Options-->Open and Save. I added a rule to query database. Thanks a lot again.

Hi All, I am new to Infopath (spent last 2 days to create few forms) and struggling to create a new form where i can display all the information from a SQL Server Database. I have already created  a submit form where user can enter information and save it in database. My objective it to create a form which when opened by any user ...