Recent content by rico14d

Thanks guys, all 3 solutions worked and have given me some good ideas for problems i had in the past. I couldn't see any performance difference for any of the 3 queries, they all were timed at 1 second using SQL Management Studio. If you know how i can test the performance more accurately let...

Hi, im trying to report on 2 tables like the following tblMain MainId Name 1 a 2 b 3 c tblSub Id MainID Status 1 1 1 2 1 1 3 2 1 3 2 2 basically i want to show all the rows from the main table...

Hi, I am trying to use a SiteMapPath item in my page which works fine for most of my pages. However a number of URLs in the web.sitemap incorporate URL rewriting i.e. '/Products/ID=5/ipod.html' and the SiteMapPath wont seem to resolve it and display the correct node. Is there any way i can...

Thanks for your comments, i think i will start to use it instead of a label all the time. Rich

Hi, What do people think of using the literal control instead of a label control? Im thinking of just using the literal control as i've had a lot of grief from a customer regarding SEO and the amount of redundant HTML code that is produced in ASP.Net. With the label control you might...

Borislav, That would work for the example above, but my scenario is much more complicated than that. For your example i have to repeat the initial query in code twice, i really wanted something cleaner that could just remove the contents of the buffer. Thanks for your help, Rich

Hi, Is there anyway i can clear what is returned from a stored procedure? Basically i only want to only return 1 table from the example below, instead of 1 empty table then a table of results. select * from Product where name = 'test' if @@RowCount = 0 begin -- I would want to 'clear'...

Hi, I am trying to add NT authentication to a sub folder of my site but am struggling to do so. Is it possible to achieve this without making any IIS changes, the reason I ask is because when publishing a site, all sub-folders are deleted and therefore the IIS settings are lost. I thought I...

Hi, How do i create a virtual directory in asp.Net 2.0? Im doing this so i can add an image folder to a project which isnt published to the live server. Thanks, Rich.

Hi, Does anybody know if there is a free-hand measure tool? Ive got a map and i wanted to trace my route and then work out the distance to scale. Thanks, Rich.

Hi, I have a datatable which i need to order numerically. However, even though the column contains numeric data, it is a string datatype. Can i use a convert() in the order parameter? Ive tried the below code but it didnt work. drChildMenus = dtMenus.Select("Menu = 1"...

Hi, I'm trying to convert a number to its hex value which i can do with- System.Convert.ToInt32(12323) However, the number im trying to convert is much bigger (a MD5 hash result - 975415459309518814222848482335161230234) and the function errors. Any ideas anyone. Rich.

Thanks for all your replies people! We've managed to solve the problem rather simply. My friend had access to an extra machine and tried to use it with his mouse/key etc and it got the same error, just with a different processor speed showing. I told him to remove everything from the computer...

Hi, On a friends computer i recently installed office XP. On the next reboot the processor speed is shown at the top of the screen and at the bottom it shows Press DEL to enter setup and it just hangs there. Pressing DEL does not do anything and none of the 'lock' lights work. I tried...

Try this System.Web.HttpContext.Current.Response.write Rich