Skip to main content

Posts

How to create WCF service

WCF -Upload and Download file

WCF Tutorial

WCF -Upload and Download file

How to send data from nodejs tcp client to c# socket server

How to create a simple Http Server in NodeJs

Node.js is an open source, cross-platform runtime environment for server-side and networking applications. Node.js applications are written in JavaScript and can be run within the Node.js runtime on OS X, Microsoft Windows, Linux.Node.js uses the Google V8 JavaScript engine to execute code, and a large percentage of the basic modules are written in JavaScript. Node.js contains a built-in library to allow applications to act as a Web server without software such as Apache HTTP Server or IIS.
In this post I will show you how to create a simple Http Server using node.js Before diving into code let us first install node.js from following link.https://nodejs.org/Once the node.js installed.Open the terminal window and type following command.node –versionIf you see similar output then node.js is installed on your machine.Open any text editor and paste following code into it and save it as Sever.js.var http = require("http"); function requestHandler(req, res) { res.writeHead(200, …

Convert colum to row without using unpivot operator

In this post I will show you how to convert column to row in SQL.For this post I am going to use following table which have three colum stu_name,sibject and marks.SELECT stu_name, MAX(CASE WHEN subject = 'ECO' THEN marks ELSE 0 END) ECO, MAX(CASE WHEN subject = 'HIS' THEN marks ELSE 0 END) HIS, MAX(CASE WHEN subject = 'MAT' THEN marks ELSE 0 END) MAT, MAX(CASE WHEN subject = 'GEO' THEN marks ELSE 0 END) GEO, MAX(CASE WHEN subject = 'SCI' THEN marks ELSE 0 END) SCI FROM col_to_rows GROUP BY stu_name