In this post here, I’ll show you how to get the selected value in a SELECT dropdown list using plain old JavaScript. This is for the beginners. ...

In SQL Server, you can use PIVOT to convert multiple rows into columns to show a summarized result. I’ll show how using this method you can easily save the rows to columns converted data into a table ...

Let us assume, I have two ranges of values in my Excel worksheet. Each range has two columns each (region and sales). Now, both the ranges have some common regions. How do you find the matching record ...

In SQL Server, you can use the DATENAME() function to get the week day for a given date. I’ll show you how to use this function to get first and last day of a given month or date in SQL Server. ...

Let us assume, your web page has a DIV element and you want to auto-refresh its contents every few seconds. You can easily do this using jQuery or any other library. I’ll show how to auto-refresh a ...

A cascading dropdown list or a dependent dropdown list gets data from a data source based on a value selected from another dropdown list. I’ll show you how to create a cascading SELECT dropdown list ...

Let us assume, you receive sales data (or any data) from different regions or zones in multiple Excel files, via email or any other source. Now, you want to merge all the Excel files into one single ...

You can use the .appendChild() method in JavaScript to add or append an element to the body section of the document or the web page. Lets find out how. ...

In Asp.Net, you can use the FileInfo class in both C# and VB, to get the file size. It provides the necessary methods and properties to deal with files. Here in this post, I have shared ...

Ajax, as you know stands for Asynchronous JavaScript and XML, which allows web applications (client side) to send and receive data from a server, asynchronously. Ajax can be used with any framework or ...