InfoPath Dev

Hello...

I'm trying to work with a stored procedure (from SQl 2005) in my Infopath 2007.

I found this Microsoft article: http://msdn.microsoft.com/en-us/kb/kb00827007.aspx but I have problems with this simple code:

XDocument.QueryAdapter.Command = "execute mysp 'This is a test' ";
XDocument.Query();

First I received that the XDocument doesnt exits in the actual context.

After search in Google I found as solution to add the reference: Microsoft.Office.Interop.InfoPath.SemiTrust.

    using Microsoft.Office.InfoPath;
    using Microsoft.Office.Interop.InfoPath.SemiTrust;  <<< NEW LINE
    using System;
    using System.Windows.Forms;
    using System.Xml;
    using System.Xml.XPath;
    using mshtml;

But when added this dll I get another error. InfoPath is not getting XDocument.QueryAdapter as a Static object and it needs a reference. Also that XDocument.QueryAdapter doen't have a definition for 'Command'.

Can someone help me what it's going on with the Microsoft example? Or maybe if you can tell me another page with a parameterized stored procedures and InfoPath 2007.

Thanks a lot of.

Hi

you should add namespace using System.Data.SqlClient;

XDocument.QueryAdapter.Command  = string.Format("execute dbo.mysp '" + text1 + "' ");

dbo.mysp is the name of you sproc and text1 is the value of the parameter that needs to be passed to execute the sproc.

Hello Madhuri...

I still have the same problem.. The Error is about a reference 'Microsoft.Office.Interop.InfoPath.SemiTrust._XDocument2.QueryAdapter.get'.

Also that the 'object' has no definitions for 'Command'.

This is my code:

using Microsoft.Office.Interop.InfoPath.SemiTrust;

using System.Windows.Forms;

using System.Xml.XPath;

using System.Data.SqlClient;

public partial class FormCode

I dont know if its important, but you must know that the SQL Server is other server... Its different from my machine.

An in my machine I have the InfoPath form!

I have found something more:

I cannot access the XDocument members.

After a . (dot) in XDocument the intellisense show only two methods: Equals and ReferenceEquals.

My InfoPath is in Spanish.

Someone can help me?