<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>General</title><link>https://www.infopathdev.com:443/forums/41.aspx</link><description>If you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>infopath 2007 + sql 2005 - Run query</title><link>https://www.infopathdev.com:443/forums/thread/103906.aspx</link><pubDate>Fri, 11 Sep 2015 08:11:53 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:103906</guid><dc:creator>sasyregak</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/103906.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=103906</wfw:commentRss><description>Hi

I am fetching the records from sql server tables in a a repeating control. On click of the key value.  The Run Query (Default one) fetches data in data controls only for that record. However this is not happening for all the records displayed  . But i am sure the database holds the records, as i am able to fetch them in the repeating table. The problem is in viewing the details in the data controls for editing/updating.The Data fields (combo,text,dropdown all controls) appears disabled and blank. Please throw some light on what could be the issue(snapshot of the code which fetches the details) 


var nCount = eventObj.Source.selectNodes(&amp;quot;preceding-sibling::d:SEARCH_FILE_RESULTS&amp;quot;).length + 1;
//XDocument.UI.Alert(nCount);
	
var objectvariable = eventObj.Source.selectSingleNode(&amp;quot;/dfs:myFields/dfs:dataFields/d:SEARCH_FILE_RESULTS[&amp;quot; +nCount+ &amp;quot;]/@File_Ref_No&amp;quot;).text;
//XDocument.UI.Alert(objectvariable);
	
XDocument.DOM.setProperty(&amp;quot;SelectionNamespaces&amp;quot;, &amp;#39;xmlns:xsi=&amp;quot;http://www.w3.org/2001/XMLSchema-instance&amp;quot; xmlns:q=&amp;quot;http://schemas.microsoft.com/office/infopath/2003/ado/queryFields&amp;quot; xmlns:d=&amp;quot;http://schemas.microsoft.com/office/infopath/2003/ado/dataFields&amp;quot; xmlns:dfs=&amp;quot;http://schemas.microsoft.com/office/infopath/2003/dataFormSolution&amp;quot; xmlns:xdado=&amp;quot;http://schemas.microsoft.com/office/infopath/2003/adomapping&amp;quot; xmlns:my=&amp;quot;http://schemas.microsoft.com/office/infopath/2003/myXSD/2009-05-24T09:30:49&amp;quot; xmlns:xd=&amp;quot;http://schemas.microsoft.com/office/infopath/2003&amp;quot;&amp;#39;);
XDocument.DOM.selectSingleNode(&amp;quot;/dfs:myFields/dfs:queryFields/q:VNJ_FileGeneralInfo/@File_Ref_No&amp;quot;).text = objectvariable;
XDocument.Query();</description></item></channel></rss>