Alok Notes

Breaking Changes for ASP.NET 2.0 applications running in Integrated mode on IIS 7.0 ASP.NET 2.0 applications on IIS 7.0 are hosted using the ASP.NET Integrated mode by default. This new mode enables a myriad of exciting scenarios including using super-valuable ASP.NET features like Forms Authentication for your entire Web site, and developing new ASP.NET modules to do things like URL rewriting, authorization, logging, and more at the IIS level. For more information about the ASP.NET Integration in IIS 7.0, see: ASP.NET Integration with IIS7. As you know, with great power comes great responsibility. Similarly, with making ASP.NET applications more powerful in IIS 7.0 comes the responsibility of making sure that existing ASP.NET applications continue to work. This has been a major challenge for us as we re-architected the entire core engine of ASP.NET, and in the end we were highly successful in meeting it. As a result, most ASP.NET applications should work without change. This post l...

at ASPX page put this add this in title tag and Page Load Event pagename.aspx.cs if (!Page.IsPostBack) { if (Request.Browser.Browser == "IE" && Request.Browser.Version == "7.0") //&& Request.Browser.Version = "7") { lnkcss.Attributes.Add("href", "style/styleIE7.css"); } else { lnkcss.Attributes.Add("href", "style/style1.css"); } }

protected void Page_Load(object sender, EventArgs e) { HtmlMeta objhtmlmeta=new HtmlMeta(); objhtmlmeta.Content = ""; objhtmlmeta.HttpEquiv = "refresh"; objhtmlmeta.Content = "10;URL=http://www.Xyzdfsdfsdfsdf.com/personal/1/searchResults.do?per=mrmls&la=EN&shcu=&cust(mtype)=res&xml=1&minprice=" + Session["MinPrice"] + "&maxprice=" + Session["MaxPrice"] + "&cu=USD&minsurface=&maxsurface=&minbedroom=" + Session["MinBedrooms"] + "&cust(garage)=&minbathroom=" + Session["MinBathrooms"] + "&minlsurface=&maxlsurface=&c_city=&cust1(d)=&cust(zipcode)=" + Session["Zip"] + "&cust(year-built)=" + Session["YearBuilt"] + "&cust(type)=&c_n_area=681&rpp=5&B1=Search"; Header.Controls.Add(objhtmlmeta); }

Error in SQL SERVER 200 :-ole db provider 'openxml' reported an error. the provider did not give any information about the error. ole db error trace [ole/db provider 'openxml' irowset::restartposition returned 0x80004005 This exception generates when you are using openxml and select record directly from xml input file or text .It comes only on SQL SERVER 2000 but not on SQL SERVER 2005. for resolving such issue you have to first create a temp table in sql server with open xml and select record directly from there temp table instead of selecting direclty from openxml. like this Correct :- if(exists(select tblHHA160_HEADER.FED_ID from tblHHA160_HEADER inner join #TempDataHeader on tblHHA160_HEADER.FED_ID=#TempDataHeader.FED_ID)) InCorrect :---if(exists(SELECT FED_ID FROM OPENXML (@idoc, '/ROOT/tblHeader',1) WITH (FED_ID varchar(6)) where FED_ID in (Select FED_ID from tblHHA160_HEADER)))

//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...