XmlHttp

XMLHttpRequest (XHR) is an API available in web browser scripting languages such as JavaScript. It is used to send HTTP or HTTPS requests directly to a web server and load the server response data directly back into the script. The data might be received from the server as XML text or as plain text. Data from the response can be…

Continue Reading

Ajax

AJAX = Asynchronous JavaScript and XML. AJAX is not a new programming language, but a new way to use existing standards. AJAX is the art of exchanging data with a server, and update parts of a web page – without reloading the whole page. Using JavaScript technology, an HTML page can asynchronously make calls to the server from which it…

Continue Reading

MongoDB with .Net and C#

MongoDB MongoDB is an open-source document database and leading NoSQL database. MongoDB is written in c++.  MongoDB is a cross-platform, document-oriented database that provides, high performance, high availability, and easy scalability. MongoDB works on the concept of collection and document. The database is a physical container for collections. Each database gets its own set of files on the file system.…

Continue Reading

Split Comma Separated List Without Using a Function

There is lots way to get the table from comma separate data by using the function to return table but I found the other way using XML path and using this you get better performance than another way while there are lots of data in a table. Even you get more time using function while to join with other tables…

Continue Reading

Generate CSV (Comma Saparated Values) from table columns

The best way to get CSV data from table by using xml path and it is the best solution for performance and easy way. For example as below: Table: Employee Column: EmployeeType Data EmployeeType ——————– HR Clerk Developers QA Option 1: You can use xml to create CSV as below: Option 2: You can use COALESCE function as below: Option…

Continue Reading