You searched for the word(s): userid:610817

More Search Options

RSS Available

• how to convert line breaks (\r\n) to excel - alt+enter after exporting from mssql to excel/csv

  I am trying to export an mssql table data to .csv file which is working with the code given below. But after exporting the column data which includes line breaks the data is being displayed on a different line rather than breaking up in a single cell (as we key-in alt+enter). Is it possible to implement this in anyway? Is there anyway I can modify the below code to achieve this? I googled alot but didn't get anywhere unfortunately. Any advice or suggestion will be of great help. Thanks in Advance

  Posted to Getting Started (Forum) by savvy on 8/7/2009

• Re: TreeView: trying to hide childnode but parentnode is always null?

  This particular post by Amanda Wang solved my problem as required. So I used code shown below protected void TreeView1_TreeNodeDataBound( object sender, TreeNodeEventArgs e) { System.Web.UI.WebControls.TreeView tree = (System.Web.UI.WebControls.TreeView)sender; SiteMapNode mapNode = (SiteMapNode)e.Node.DataItem; System.Web.UI.WebControls.TreeNode itemToRemove = tree.FindNode(mapNode.Title); if (mapNode.Title == "Home" ) { System.Web.UI.WebControls.TreeNode parent = e.Node.Parent; if (parent

  Posted to Master Pages, Themes and Navigation Controls (Forum) by savvy on 2/18/2009

• TreeView: trying to hide childnode but parentnode is always null?

  I am trying to hide a child node(which has a parent) using the code as shown below but the parent node is alwasy returning NULL, so I am not able to proceed further.I dont know where I am going wrong. protected void tmsMenu_TreeNodeDataBound( object sender, TreeNodeEventArgs e) { SiteMapNode node = (SiteMapNode)e.Node.DataItem; // e.Node.PopulateOnDemand = true; if (Request.Url.PathAndQuery == e.Node.NavigateUrl) e.Node.ExpandAll(); else e.Node.CollapseAll(); if (node.HasChildNodes) { foreach (SiteMapNode

  Posted to Master Pages, Themes and Navigation Controls (Forum) by savvy on 2/18/2009

• Re: Spaces ( ) problem with ListBox, cannot append spaces to listbox options

  Thats works like a charm, I tried using HtmlDecode at some other places in the code but not over here as shown above. Thank you very very much for your help. I really appreciate that.

  Posted to Web Forms (Forum) by savvy on 10/15/2008

• Spaces ( ) problem with ListBox, cannot append spaces to listbox options

  Spaces ( ) problem with ListBox, cannot append spaces to listbox options I am trying to populate a ListBox using a SortedList Collection as shown below. I wanted to include indents (spaces) before the locations. SortedList slLocations = new SortedList(); slLocations.Add( "1887" , "  Channel Islands" ); slLocations.Add( "1888" , "  Alderney" ); slLocations.Add( "1889" , "  Jersey" ); slLocations.Add( "1890"

  Posted to Web Forms (Forum) by savvy on 10/15/2008

• Re: How to search text in a word document ?

  I did not store the CV on the WebServer to start with, they were stored in SQL Database as a binary type and I used Full Text Indexing to search for keywords in the CVs. If you got few CVs then I would suggest to use this approach.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by savvy on 8/10/2008

• Re: Problem of duplicate records with a simple Insert statement !

  Sorry Dhimant, your reply came when I was typing previous reply. So, that rules out any chance of transaction error. Thats perfect for my situation, I will use the above SP Thank you very very much for your help and time

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by savvy on 10/11/2007

• Re: Problem of duplicate records with a simple Insert statement !

  Thanks ca8msm for your reply, Yes thats true, actual member can add his credits and Admin can add the member credits. As long as its not a locking problem or some transaction problem, I am happy. So, I am assuming for now it must been a mistake on the Admin people or maybe the problem of @@IDENTITY, I will immediately change it to Scope_identity(). hope this situation never comes up again.. Thank you very much for your help and time

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by savvy on 10/11/2007

• Problem of duplicate records with a simple Insert statement !

  I am using a simple stored proc shown below which inserts a record and updates the same record field called SortID with the Primary Key Column data of the same record. Everything was working fine until few days back. The site has been deployed 2 years back and was LIVE ever since. We have got thousands of records in this Credits table. The table field called SortID is used for moving the credits up and down. My problem is now after 2 years of deploying the table has got duplicate records, suprisingly

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by savvy on 10/11/2007

• Re: Problem while subtracting two dates?

  Thanks for your reply and time Brian The above code will work because the DateTime.Now will be always greater than dt1 (I suppose), in atleast in terms of seconds, but my problem is precisely with the seconds because when a user has been given an option of select a start time and end time, he can choose it any order thats the problem in seconds , therefore i removed seconds from my calculation as shown in the code below private void CalcActualDuration() { if (ndtpImplemActualEnd.Value != null &&

  Posted to Getting Started (Forum) by savvy on 8/22/2007