Posts

How to Implement Dynamic CSS File in ASP.NET

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"); } }
Post a Comment
Read more

how to add meta tag elements dynamic in ASP.NET

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); }
Post a Comment
Read more

ole/db provider 'openxml' irowset::restartposition returned 0x80004005

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)))
Post a Comment
Read more

Bind Treeview control Recursivley

//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...
Post a Comment
Read more

Deletion of Muliple record through Openxml on composite key

//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...
Post a Comment
Read more