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 ...
I have previously shared few examples here on my blog that explained how to add or override the !important property dynamically in JavaScript. Now, I’ll show you how to add the CSS !important property ...
Its very common for Excel users to send emails to a list of contacts. Here in this post, I’ll show you how easily you can send emails to multiple recipients from your Excel workbook with the click ...