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.