Ociuz | Best Software Development & Training Company in Thrissur, Kerala

Rank - Make ranking structure using SQL tool                If we have collection of data and we want to make it an well structure by reduce duplication and make view based on ranking; we have a simple and easy option to do this operation.It is called Rank. For example we have data such like,   Name        Sales John           10 Jennifer      15 Stella          20 Sophia       40 Greg          50 Jeff            20 The general idea to display rank in SQL is to do a  self-join , then list out the results in order, and finally do a count on the number of records that's listed ahead of (and including) the record of interest. So, we coming back to discussion. we have to make this data in ranking based order.so lets start with the query, SELECT a1.Name, a1.Sales, COUNT (a2.Sales) Sales_Rank  FROM Total_Sales a1, Total_Sales a2  WHERE a1.Sales <= a2.Sales OR (a1.Sales=a2.Sales AND a1.Name = a2.Name)  GROUP BY a1.Name, a1.Sales  ORDER BY a1.Sales DES

Simple Pagination Using Jquery With PHP                    In PHP pagination helps to make a standard view of data. It divide collection of data in page wise view. It helps to make arrange unordered data into ordered bunch. Here we are going to discuss about , how we can make an pagination of data in PHP using Jquery. a Jquery file called jquery.min.js is needed to use jquery methods. Source     PHP code file named load_data.php   <?php if($_POST['page']) { $page = $_POST['page']; $cur_page = $page; $page -= 1; $per_page = 6; $previous_btn = true; $next_btn = true; $first_btn = true; $last_btn = true; $start = $page * $per_page; include"db.php"; $query_pag_data = "SELECT msg_id,message from messages LIMIT $start, $per_page"; $result_pag_data = mysql_query($query_pag_data) or die('MySql Error' . mysql_error()); $msg = ""; while ($row = mysql_fetch_array($result_pag_data)) { $ht

Conditional statement in SQL           W e have an if condition in programming sector to handle the conditional operation. Like that in SQL conditional operation done by using CASE statement. A sample example of CASE statement in sql is given below,        syntax,       SELECT CASE ("column_name")      WHEN "value1" THEN "result1"     WHEN "value2" THEN "result2"         ...        [ELSE "resultN"]      END     FROM "table_name";     eg:           SELECT Store_Name, CASE Store_Name           WHEN 'Los Angeles' THEN Sales * 2           WHEN 'San Diego' THEN Sales * 1.5           ELSE Sales           END           "New Sales",           Txn_Date           FROM Store_Information; By Varun K.R Ociuz Technologies

Image upload in C#(windows application) In windows application file upload operation is not much easy just like web application.But we can implement this in windows application using other way.  Needed Controls : Openfiledialog,Button,TextBox Coding part : using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.IO; namespace DemoWindowsApplication {     public partial class FileUpload : Form     {         public FileUpload()         {             InitializeComponent();         }         private void button1_Click(object sender, EventArgs e)         {             DialogResult result = openFileDialog1.ShowDialog();             if (result == DialogResult.OK) // Test result.             {                 textBox1.Text = openFileDialog1.FileName;             }         }    

MVC - The architecture for modern web concept                                         Here we are introducing a new technology called MVC(Model View Controller) which is widely  using architecture in modern web world. Its bring us to new way or concept of web development . MVC project structure is entirely different from other project types. It mostly used for web development. It is very lightweight and well structure which user can easily handle it. But one thing is that, if we are new for this architecture there is little bit of tough to understand its flow of development. If we try to make familiar with it , we can easily handle MVC projects.                                           MVC is an pure html based page creating which makes it fast performance and lightweight process. We know many of sites take more time to load and tolerate us to waste our time , here MVC solve that situation  in modern world.  There is three layers which defines, The business la

How to reduce an image size while upload to the server         M ost of users wants to fast uploading process when they are browsing. there are several method to file encryption and decryption , compress file technology is widely used. Here we are going to discuss how to reduce the file in upload process using PHP. Given below code will be help to solve this problem. Code: <?php $name = ''; $type = ''; $size = ''; $error = ''; function compress_image($source_url, $destination_url, $quality) { $info = getimagesize($source_url);     if ($info['mime'] == 'image/jpeg')         $image = imagecreatefromjpeg($source_url);     elseif ($info['mime'] == 'image/gif')         $image = imagecreatefromgif($source_url);     elseif ($info['mime'] == 'image/png')         $image = imagecreatefrompng($source_url);     imagejpeg($image, $destination_url, $quality); return $

JQuery Mobile -A smart technology for smartest generation      Jquery . this name is very familiar in this web world. today jquery override other all web designing concepts and technologies. User-friendly and fast process is the quality of jquery. if we discuss about jquery, there is lots of variety and latest designing and animated techniques can found . animate , fade and slide effects, rotate and scale effects, 3D effects can implement in our website using this technology.     Here introduce the new technology from jquery is Jquery Mobile. using this we can add effect in mobile websites. Its  an amazing thing which can help to make interactive design for our website. there are lots of sites are available in internet which provide latest releases and tutorial of jquery mobile technology such likes www.jquerymobile.com , www.jqueryui.com etc . By Varun K.R Ociuz Technologies

Invoke Method From String [using Reflection] For Calling a function/method from a string we can use Reflection in C#. Wikipedia says that "In computer science, reflection is the process by which a computer program can observe and modify its own structure and behavior". This is exactly how Reflection in C# works. Uses of Reflection Reflection has the following uses: It allows view attribute information at runtime. It allows examining various types in an assembly and instantiate these types. It allows late binding to methods and properties It allows creating new types at runtime and then performs some tasks using those types.  A Sample code is given below: using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Reflection; namespace InvokeMethodFromString {     class Program     {         static void Main( string [] args)         {             Type type = typeof (MyReflectionClass);             MethodIn