Posts

Showing posts from August, 2011

MSSQL - show data per page

- This statement will return record 1 to 20. SELECT * FROM ( SELECT row_number() OVER (ORDER BY id) AS rownum, * FROM example_table_a ) AS A WHERE A.rownum BETWEEN (1) AND (20) - If you want the next 20, your where criteria should be: WHERE A.rownum BETWEEN (21) AND (40) - Finally, SQL statement in your C# code will be: public String CreateSQL(Int32 pageNo, Int32 pageSize) {      StringBuilder _sbSQL = new StringBuilder();      Int32 _offset = 1+ ((pageNo-1) * pageSize);      _sbSQL.Append(" SELECT * FROM ");      _sbSQL.Append(" ( ");      _sbSQL.Append(" SELECT row_number() OVER (ORDER BY id) AS rownum, * ");      _sbSQL.Append(" FROM example_table_a ");      _sbSQL.Append(" ) AS A ");      _sbSQL.Append(" WHERE A.rownum BETWEEN (" + _offset +") AND (" + (_offse...
Read more

MSSQL - Integer Type

- bigint Integer (whole number) data from -2^63 (-9,223,372,036,854,775,808) through 2^63-1 (9,223,372,036,854,775,807). Storage size is 8 bytes. - int Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647). Storage size is 4 bytes. The SQL-92 synonym for int is integer. - smallint Integer data from -2^15 (-32,768) through 2^15 - 1 (32,767). Storage size is 2 bytes. - tinyint Integer data from 0 through 255. Storage size is 1 byte. Remarks The bigint data type is supported where integer values are supported. However, bigint is intended for special cases where the integer values may exceed the range supported by the int data type. The int data type remains the primary integer data type in SQL Server. bigint fits between smallmoney and int in the data type precedence chart. Functions will return bigint only if the parameter expression is a bigint data type. SQL Server will not automatically promote other integer data types (tinyint, smal...
Read more

PHP - Fatal error: Call to undefined function curl_init()

Fatal error : Call to undefined function curl_init() Solution of this problem is we need open "curl function" first. We can open this function in "php.ini" in "C:\windows\php.ini" step 1: open "c:\windows\php.ini" step 2: find ";extension=php_curl.dll" and change to "extension=php_curl.dll" step 3: go to "dir: \AppServ\php5" step 4: find     -libeay32.dll     -ssleay32.dll step 5: copy those files to "C:\windows\system32"; step 6 (last step): restart apache or restart appserv server. Website reference:  moshikub.com
Read more

PHP - MD5

string md5 ( string $str [, bool $raw_output = false ] ) output of md5 function will returns the hash as a 32-character hexadecimal number. But if you set $raw_output = true , output will return in binary format with a length of 16. Example #1: $str = 'tmvh:partner01:12345'; $output_md5 = md5($str); echo $output_md5; //output is "3d5e420dc4eaaef230409fad5662e825" Example #2 : $str = 'tmvh:partner01:12345'; $output_md5 = md5($str,true); //$output_md5 contain binary format //Convert $md5_output binary format to BASE64 $output_base64 = base64_encode($output_md5); echo $output_base64; //output is "PV5CDcTqrvIwQJ+tVmLoJQ=="
Read more

HTML - ToolTip

Step1. Add "htmltooltip.js" into <head> tag in your HTML See "htmltooltip.js" source code here Step2. Insert this stylesheet script in <head> tag in your HTML <style type="text/css">      div.htmltooltip {      position: absolute; /*leave this and next 3 values alone*/      z-index: 1000;      left: -1000px;      top: -1000px;      background: #EEEEEE;      border: 2px solid black;      color: black;      padding: 3px;      width: 250px; /*width of tooltip*/      } </style> In <body> tag. Add your tooltips text to <div class="htmltooltip"></div>. Example. <a href="#" rel="htmltooltip"> Displaying My tooltip text </a> <div class="htmlt...
Read more

PHP - cURL (post by XML)

<?php //this url return result in xml format $url = " http://www.exmple.com/fakeResponse.aspx "; $xml_request = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>  <note>  <to>Tove</to>  <from>Jani</from>  <heading>Reminder</heading>  <body>Don't forget me this weekend!</body>  </note>"; $response = curl_xml($url, $xml_request); /* ------- Response  -------*/ //header for response result in xml format header('Content-type: text/xml'); echo $response; /* ------- CURL_XML -------*/ function curl_xml($_url, $_xmlRequest) {     $header = array("content-type: text/xml");     // initialize curl handle     $c = curl_init();     // set url to post to     curl_setopt($c, CURLOPT_URL, $_url);     //include header as needed     curl_setopt($c, CURLOPT_HTTPHEADER, $header)...
Read more

PHP - cURL (post by parameter)

<?php //this url return result in xml format $url = http://www.example.com/receiveRequest.php ; $parameter = "name=henry"; $response = curl_xml($url, $parameter); /* ------- Response -------*/ //header for response result in xml format header('Content-type: text/xml'); echo $response; /* ------- CURL_XML -------*/ function curl_xml($_url, $_xmlRequest) {     $header = array("content-type: application/x-www-form-urlencoded");     // initialize curl handle     $c = curl_init();     // set url to post to     curl_setopt($c, CURLOPT_URL, $_url);     //include header as needed     curl_setopt($c, CURLOPT_HTTPHEADER, $header);     //not include the header in th output     curl_setopt($c, CURLOPT_HEADER, 0);     // set post method in request otherwise curl will do a GET request     curl_setopt($c, CURLO...
Read more

PHP - HTTP Post

function curl_xml($_url, $_xmlRequest) {     $header = array("content-type: text/xml");     $c = curl_init();// initialize curl handle     curl_setopt($c, CURLOPT_URL, $_url);// set url to post to     curl_setopt($c, CURLOPT_HTTPHEADER, $header);//include header as needed     curl_setopt($c, CURLOPT_HEADER, 0);//not include the header in th output     curl_setopt($c, CURLOPT_FOLLOWLOCATION, 1); //set follow redirect send by the server     curl_setopt($c, CURLOPT_MAXREDIR, 5); // Limit redirections to four     curl_setopt($c, CURLOPT_POST, 1);// set post method in request otherwise curl will do a GET request     curl_setopt($c, CURLOPT_POSTFIELDS, $_xmlRequest);// add POST fields     curl_setopt($c, CURLOPT_RETURNTRANSFER, 1);// return into a variable     curl_setopt($c, CURLOPT_TIMEOUT, 8); // times out after 8s ...
Read more

C# - Encoding & Decoding Text

Example for Convert Encoding from "ISO-8859-11" to UTF8 String _outputString = this.ConvertToUTF8("test 123", "ISO-8859-11"); or convert from "ISO-8859-11" to "windows-874" or another encoding String _outputString = this.ConvertString("test 123", "ISO-8859-11", "windows-874"); public String ConvertToUTF8(String inputString, String inputEncoding) {      String _output = null;      Byte[] _byteArray = System.Text.Encoding.GetEncoding(inputEncoding).GetBytes(inputString);      _output = System.Text.Encoding.UTF8.GetString(_byteArray);      return _output; } public String ConvertToString(String inputString, String inputEncoding, String outputEncoding) {      String _output = null;      Byte[] _byteArray = System.Text.Encoding.GetEncoding(inputEncoding).GetBytes(inputString);      _output = System.Te...
Read more

C# - Random Example

If you need to random number between 1 to 10. You can use "Random.Next(minimumValue,maximumValue)". Remark that if maximum equal 10, the random number can be 0-9. If you want 10 in your random list, you have to set the maximum number is 11. Random _random = new Random(); Int32 _iRandom = _random.Next(1, _maximumValue + 1); //_iRandom can be 1-10. Example. Unique random number private String RandomList(Int32 totalLuckyWinner, Int32 totalRecord) {      #region [ variable ]      String _strRandom = null;      #endregion      #region [ random number ]      if (totalRecord > 0)      {           Random _random = new Random();           Int32 _iRandom = 0;           Int32...
Read more

C# - String to BASE64 and vise versa

public String StringToBASE64(String message) {      String _strBASE64 = null;      Byte[] _byteArray = System.Text.Encoding.UTF8.GetBytes(message);      _strBASE64 = Convert.ToBase64String(_byteArray);      return _strBASE64; } public String BASE64ToString(String message) {      String _strResult = null;      Byte[] _byteArray = Convert.FromBase64String(message); javascript:void(0)      _strResult = System.Text.Encoding.UTF8.GetString(_byteArray);      return _strResult; }
Read more

javascript - htmltooltip.js

//Inline HTML Tooltip script: By JavaScript Kit: http://www.javascriptkit.com //Created: July 10th, 08' var htmltooltip={      tipclass: 'htmltooltip',      fadeeffect: [true, 500],      anchors: [],      tooltips: [], //array to contain references to all tooltip DIVs on the page      positiontip:function($, tipindex, e){           var anchor=this.anchors[tipindex]           var tooltip=this.tooltips[tipindex]           var scrollLeft=window.pageXOffset? window.pageXOffset : this.iebody.scrollLeft           var scrollTop=window.pageYOffset? window.pageYOffset : this.iebody.scrollTop           var docwidth...
Read more

javascript - AJAX

function loadAJAX(url) {      try {         var xmlhttp;         if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari            xmlhttp = new XMLHttpRequest();         }         else {// code for IE6, IE5            xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");         }         xmlhttp.onreadystatechange = function() {            if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {               alert(xmlhttp.responseText);    ...
Read more

javascript - isNumeric

function isNumeric(n) {      var _isNumeric = !isNaN(parseFloat(n)) && isFinite(n);      if (_isNumeric)         return true;      else         return false; }
Read more

C# - Hex To String

public String HexToString(String hexString) {      int value;      string stringValue = null;      char charValue;      string _strOutput = null;      string hexValues = hexString;      string _leftPosition = null;      Int32 _subLength = 0;      string _tmp = null;      string[] hexValuesSplit;      for (Int32 _i = 0; _i < hexValues.Length; _i=(_i+_subLength))      {         _leftPosition = hexValues.Substring(_i, 1);         switch (_leftPosition.ToUpper())         {            case "E":      ...
Read more

C# - String To Hex

public String StringToHex(String input) {      string hexOutput = null;      int value;      char[] values = input.ToCharArray();      foreach (char letter in values)      {         // Get the integral value of the character.         value = Convert.ToInt32(letter);         // Convert the decimal value to a hexadecimal value in string form.         hexOutput += String.Format("{0:X}", value);         //Console.WriteLine("Hexadecimal value of {0} is {1}", letter, hexOutput);      }      return hexOutput; }
Read more

C# - MD5 in BASE64

public String encriptStringByMD5(String input) {      String output;      //The encoder class used to convert strPlainText to an array of bytes      Encoding enc = Encoding.GetEncoding("windows-874");      //Create an instance of the MD5CryptoServiceProvider class      MD5CryptoServiceProvider md5Hasher = new MD5CryptoServiceProvider();      //Call ComputeHash, passing in the plain-text string as an array of bytes      //The return value is the encrypted value, as an array of bytes      Byte[] hashedDataBytes = md5Hasher.ComputeHash(enc.GetBytes(input));      output = Convert.ToBase64String(hashedDataBytes,0,hashedDataBytes.Length );      //output = BitConverter.ToString(hashedDataBytes);      return o...
Read more

C# - BASE64 to Image

public void ConvertBase64ToImage(String strBASE64) {      String _outputFile = @"c:\temp\test.jpg";      try      {         Byte[] _imageBytes = Convert.FromBase64String(strBASE64);         MemoryStream ms = new MemoryStream(_imageBytes, 0, _imageBytes.Length);         // Convert byte[] to Image         ms.Write(_imageBytes, 0, _imageBytes.Length);         Image _image = Image.FromStream(ms, true);         _image.Save(_outputFile);         MessageBox.Show("save image success");      }      catch (Exception ex)      {      ...
Read more