InfoPath Dev

You can use this book : "Designing Forms for Microsoft Office Infopath and Forms Services 2007" -Scott Roberts ,Hagen Green. Chapter 8 in this book talks about submitting data from an Infopath form. For submitting data to SQL server database through a web service you would need to create a ADO.NET dataset submit , also mentioned in ...

Hi, I am trying to submit to a table in Access 2007 database using an Infopath form. First a particular student record is pulled out using a query and then submission is made. I have created the Infopath form in such a way that after one submission is made for a student the values in the form can be cleared and data for another student can be ...

My scenario : I have a Microsoft Access 2007 database foobar.accdb with two tables Student(ID|FirstName|LastName) and Scores(ID|ScoreA|SCoreB) which has a primary-foreign key relation on the field 'ID'. I want to create an Infopath form that can submit new students to the 'Student' table and also be able to retreive information ...

Clay, Thanks for your response! As you mentioned, I have the URL for the Web Service and ran through the Data Connection wizard, to no luck. Let me elaborate: My objective is to Submit data to a MS SQL backend via Web Services using a Secondary Data Source. For the sake of conversation, the database has one table with 2 columns - id(int), ...

   Can any one  please list the steps to be followed to enable submitting a form through a secondary data connection. i.e creating a submit connection after I created the  layout of the form.   Thanks, Swetha

 Can any one  please list the steps to be followed to enable submitting a form through a secondary data connection. i.e creating a submit connection after I created the  layout of the form.   Thanks, Swetha 

 Hi, I am trying to submit to a SQL server database using a secondary data connection via a web service . When I hit submit I do get the "Form submitted successfully" dialogue but the data does not commit to the database. Can anyone please tell me how to fix this.. The webmethod for the Submit looks like this , where ...

Hello,  I found the problem to be with the field Service_count, which failed to convert the boolean values to a number. I retained the datatype for the 3 services in the SQL database as "bit"  and service_count as "int"  and in the form I have the 3 services inserted  as " boolean" fields, and ...

 Hi, I have a problem when trying to submit an Infopath  form.The scenario is as follows: I have an infopath form which talks to SQL server via a webservice to query and submit data.  I have SQL server 2005 database which has a table for services provided  for a given studentID. Fileds and the data types of the table are : ...

Hi, I had  a simlilar problem,which I was able to fix without using Qdabra. I created a main data connection to 'submit' to the database and then created a different connection (secondary) to  receive or query the data.This solved the problem. Cheers, Swetha