Saturday, November 22, 2014

Best VPN in Pakistan



Strong VPN is most suitable and Best VPN for users in Pakistan and it's speed also good and you get it $25-$30 for 3 month . I've used it and found it the best VPN for changing IP and I was able to open YouTube by using Strong VPN without any issue. Moreover Strong VPN guarantees that there  will be no monitor, record or store logs for any single customers VPN activity. They also support live chat 24x7 . They do not store web traffic data, including websites visited, files downloaded, etc

I would recommend you to use strong VPN for at least  few days and if you don't like it you can get  a full refund and they offer a 7 day money back guarantee for any reason .

Wednesday, September 19, 2012

Get Number of tables in a database in SQL Server


Here is the query to find total number of tables in a specific database in SQL Server.

USE DBName

SELECT COUNT(*) FROM information_schema.tables WHERE table_type = 'BASE TABLE'



OR

SELECT COUNT(*) FROM sysobjects WHERE xtype = 'U'

DBName is the name of your database in which you want to find the total number of tables.

Saturday, November 12, 2011

Uninstall Internet Explorer (IE) 9 from windows 7

  1. Click the Start button Picture of the Start button, type Programs and Features in the search box, and then click View installed updates in the left pane.
  2. Under Uninstall an update, scroll down to the Microsoft Windows section.
  3. Right-click Windows Internet Explorer 9, click Uninstall, and then, when prompted, click Yes.
  4. Click one of the following:
    • Restart now (to finish the process of uninstalling Internet Explorer 9 and restore the previous version of Internet Explorer).
    • Restart later

Monday, October 24, 2011

format-number with 0 in xslt using dot net

I was using the following code in my xslt to format number and then used to apply this xslt on xml in dot net.
<xsl:value-of select="format-number(number,'#.#####')" />
And it was showing result as required but when number value become 0 , it returns the empty as I tried to hard code number value with 0.
<xsl:value-of select="format-number(0,'#.#####')" />
and it was giving outuput 0 but  when I used the same code in simple xslt and simple xml (and linked xslt with xml file in note pad ) and runs this in browser , It gave me the correct result in form of 0.
I was surprised why this is not working in dot net code and working in browser with simple xslt file and xml file without using dot net code.

Then I found a solution regarding dot net as
<xsl:value-of select="format-number(0,'#0.#####')" />
But still I am not be able to understand why this is working in simple browser and not working in dot net code?