Re: Insert Infopath repeating section data into database using C#

Hilary Stoupa — Wed, 02 Feb 2011 17:25:51 GMT

Does your stored procedure require any paramaters? Where does it get the data it is supposed to be inserting into the database?

Insert Infopath repeating section data into database using C#

Alok Singla — Wed, 02 Feb 2011 11:27:09 GMT

Hi,

I am new to infopath and trying to insert some data from infopath to sql server 2005 using c-sharpe. After looking into number of posts, i have found some sample code and tried.

For this, i have created a new Data connection in Form with Receiving Data Option and created a stored procedure with only a insert statement. I am using below sample of code.

AdoQueryConnection connection = (AdoQueryConnection)DataConnections["FolderScan"];

string originalCommand = connection.Command;

connection.Command = "EXECUTE procFolderScan";

connection.Execute();

But above code is not inserting anything in the database. but if i execute my stored procedure from Sql Server management studio with same credentials, it executed the procedure.

Please suggest me, what is wrong in the above code.

Thanks.

Code

Re: Insert Infopath repeating section data into database using C#

Insert Infopath repeating section data into database using C#