Alok Notes

//Page Load Event UltraWebTree1.Nodes.Clear(); Infragistics.WebUI.UltraWebNavigator.Node node1 = new Infragistics.WebUI.UltraWebNavigator.Node(); //=new Infragistics.WebUI.UltraWebNavigator.Node("ASP.NetSearchDNN"); node1.Text = "Agencies"; UltraWebTree1.Nodes.Add(node1); //TreeNode tNode = new TreeNode(); Infragistics.WebUI.UltraWebNavigator.Nodes tNode; tNode = UltraWebTree1.Nodes[0].Nodes; PopulateTreeView("0", tNode); UltraWebTree1.ExpandAll(); //Recursive function public void PopulateTreeView(string iparentId, Infragistics.WebUI.UltraWebNavigator.Nodes inTreeNode) { DataSet DSNASPSearch = new DataSet(); string strquery = ""; if (iparentId == "0") { strquery = "select ID ,OrganizationName,ParentId from tblAgencies where ParentId is null"; } else { strquery = "select ID ,OrganizationName,ParentId from tblAgencies where ParentId= " + iparentId; } SqlDataAdapter da = new SqlDataAdapter(strquery, con); da.Fill(DSNASP

//Reading Reocord from open XML in Temp Table SELECT * into #TempData160 FROM OPENXML (@idoc, '/ROOT/tblHHA160',1) WITH ( ROW_NO INT, HHA_REC_ID VARCHAR(2),REC_TYPE VARCHAR(2),LOCK_DATE varchar(20),CORRECTION_NUM varchar(2),ACY_DOC_CD VARCHAR(8), VERSION_CD1 VARCHAR (12),VERSION_CD2 VARCHAR(5),SFTW_ID VARCHAR(9),SFT_VER VARCHAR(5),HHA_HHA_AGENCY_ID VARCHAR(16), PAT_ID VARCHAR(14),ST_CODE VARCHAR (2),ST_ERR_CNT VARCHAR(4),ST_COR CHAR (1),ST_PMT_COR CHAR (1),ST_KEY_COR CHAR (1), ST_DELETE CHAR (1) ,MC_COR CHAR (1),MC_PMT_COR CHAR (1),MC_KEY_COR CHAR (1),MASK_VERSION_CD VARCHAR (20),CNT_FILLER VARCHAR (7), M0010_MEDICARE_ID VARCHAR (6),M0012_MEDICAID_ID VARCHAR (15),M0014_BRANCH_STATE VARCHAR (2),M0016_BRANCH_ID VARCHAR (10), M0020_PAT_ID VARCHAR (20),M0030_START_CARE_DT varchar(20) ) //Check exists function if(exists(SELECT tblHHA160.M0010_MEDICARE_ID,tblHHA160.M0020_PAT_ID,tblHHA160.M0030_START_CARE_DT,tblHHA160.M0100_ASSMT_REASON FROM tblHHA160 INNER JOIN #TempData160 AS tblHHA