InfoPath Dev

Hello

I'm using InfoPath 2007 and my code is developped with C#

My form is connected to a SQL Server where I get list of network Path from an SQL view "qry_InfoPath_NetworkStructure".

The query return ID & Path columns.

I have created a drop down list connected to this data source to make sure I can get the value from the server.

this work fine and I can see and select Path

Then I have created a button "Create folder" in my form that should create folders using Paths get from the view.

and add the below sentence but I didn't get anything :

IXMLDOMNodeList folderList = thisXDocument.DOM.selectNodes("/dfs:myFields/dfs:dataFields/d:qry_InfoPath_NetworkStructure/@Path");

Now I stack on how to get these Path list.

I'm missing something ?

 Any help will be welcomed

Thanks

 I finally get some information on the net and the following link help me a lot:

http://blogs.msdn.com/timpash/archive/2006/06/12/CSharp-And-Secondary-Datasources.aspx

 below is what I did:

FolderList.setProperty("SelectionNamespaces", "xmlns:dfs='http://schemas.microsoft.com/office/infopath/2003/dataFormSolution'" + " xmlns:d='http://schemas.microsoft.com/office/infopath/2003/ado/dataFields'");
           
 //Loop on each Network Settings
 foreach (IXMLDOMNode Folder in FolderList.selectNodes("/dfs:myFields/dfs:dataFields/d:qry_InfoPath_NetworkStructure/@Path"))
{
      if (!Directory.Exists(Folder.text))
           Directory.CreateDirectory(Folder.text);
}

Hope that will help Infopath beginner like me