HOME

Friday, August 17, 2012

double or float convert to currency format C#


double amount=1234;
amount.ToString("#,##0.00");
Then resulting string is 1,234.00

Call a URL and save the response C# ASP.NET


string url = "http://69.50.198.112/send.php?usr=24129&pwd=123456&ph=9030102460&text=fromApp";

               WebRequest request = HttpWebRequest.Create(url);

                WebResponse response = request.GetResponse();

                StreamReader reader = new StreamReader(response.GetResponseStream());

                string urlText = reader.ReadToEnd();

Monday, August 13, 2012

Run application Shortcut from Command Prompt or batch file


Start Call  "C:\Program Files (x86)\TECHNOARCHIVE\MailCityCinemas\CityCinemas.exe"  

OR 

start "" "C:\Program Files (x86)\TECHNOARCHIVE\MailCityCinemas\CityCinemas.exe"   

Monday, August 6, 2012

KNOWING SQL SERVER 2005 PERFOMANCE AND STATISTICS



SELECT *
FROM sys.dm_exec_query_stats AS qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) st ORDER BY total_logical_reads DESC;

Saturday, July 14, 2012

How to host WCF Service in IIS

The maximum array length quota (16384) has been exceeded while reading XML data.


    <bindings>
      <basicHttpBinding>
        <binding maxBufferSize="2147483647" maxReceivedMessageSize="2147483647">
          <readerQuotas maxDepth="32" maxStringContentLength="5242880" maxArrayLength="2147483646" maxBytesPerRead="4096" maxNameTableCharCount="5242880"/>        
        </binding>          
      </basicHttpBinding>    
    </bindings>

how find SQL SERVER 2005 statistics and perfomance


SELECT *
FROM sys.dm_exec_query_stats AS qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) st ORDER BY total_logical_reads DESC;