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("preceding-sibling::d:SEARCH_FILE_RESULTS").length + 1;
//XDocument.UI.Alert(nCount);
var objectvariable = eventObj.Source.selectSingleNode("/dfs:myFields/dfs:dataFields/d:SEARCH_FILE_RESULTS[" +nCount+ "]/@File_Ref_No").text;
//XDocument.UI.Alert(objectvariable);
XDocument.DOM.setProperty("SelectionNamespaces", 'xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:q="http://schemas.microsoft.com/office/infopath/2003/ado/queryFields" xmlns:d="http://schemas.microsoft.com/office/infopath/2003/ado/dataFields" xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution" xmlns:xdado="http://schemas.microsoft.com/office/infopath/2003/adomapping" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2009-05-24T09:30:49" xmlns:xd="http://schemas.microsoft.com/office/infopath/2003"');
XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:queryFields/q:VNJ_FileGeneralInfo/@File_Ref_No").text = objectvariable;
XDocument.Query();