Hi, I am Arun Banik and Welcome to my blog.

Dynamically create UserForm controls and Save data in SQL Server database

In this tutorial, I’ll show you how to create and add ActiveX Controls dynamically in a UserForm and save all the data (extracted from the controls) in an SQL Server table.

How to create a simple autocomplete feature using JSON and pure JavaScript - No Widgets, No Libraries

The example here shows how to create a simple AutoComplete textbox feature using data from an Array and using the includes() method.

Dynamically create multiple textbox and other elements in Asp.Net and Save data in database using C# and VB

Here in this post I am going to show you how to create multiple textboxes dynamically in Asp.Net using the "HtmlGenericControl" class in C# and Vb and finally save the data in an SQL Server database table.

How to remove duplicates from an array quickly and efficiently without running a loop in JavaScript?

There two simple built-in methods that you can use together in JavaScript, to quickly and efficiently remove duplicates from an array without running a loop.

Windows Forms App - How to export data to an Excel worksheet with AutoFormat feature using C#

You must be aware of the AutoFormat feature in Excel: it allow users to format a worksheet (or a particular range) with various formatting options. Here in this article, I’ll show you how to export data to an Excel sheet in a Windows Forms application using C# and apply AutoFormat feature dynamically to the worksheet. In-addition, I’ll also show you how to populate a WinForms CheckedListBox control using data extracted from a database.

How to use ternary operator within the map() function - JavaScript

The ternary operator in JavaScript is a conditional operator. It is used as an alternative to if...else statement. But do you know you can use the ternary operator within the .map() function. Yes you can and I'll show you how.

SQL Server DATENAME() Function - Get the name of distinct Months in words from a date column

I have shared fews examples in this article showing how to get distinct months, in words, from a date column using DATENAME() function in SQL Server. The DATENAME() is an SQL Server built-in function that returns a specified part (a datepart) of a specified date.

How to show images from an array using JavaScript - The Easy Way

There are few simple methods in JavaScript that you can use to extract images from an array and display it. The method that I am going to share in this article uses the .map() function.

Web Scraping using Pure JavaScript - Two different methods

Web scraping (or known as Screen Scraping) is process of extracting data like HTML codes etc. from websites or web pages. The extracted data is often used for analysis or to simply display the extracted contents on other web pages. Here in this article I am going to show you two different web scraping methods using pure JavaScript.

What is Nullish coalescing operator "??" and how to use it effectively in JavaScript?

Nullish coalescing operator ?? is a logical operator that returns right-hand side value (operand) if left-hand side value (operand) is "null" or "undefined". Let's understand this operator with two simple examples.

How to get sum of array elements without using loops or recursion

One of the easiest way to get the sum of array values without looping is to use the .reduce() method. The method reduces array elements into a single value. Most importantly, it reduces the size of the script, since you don't need to loop through each element or do any recursion.

Python pow() function - Get Square of all numbers in an array without using loop

In my previous article I have explained how to use the power operator ** in python to get square of all numbers in an array using recursion. In this article I'll show you how to use Python's built-in pow() (power) function to get the square of all the values in an array, without using a loop.

Copilot Notebook - AI tool from Microsoft for longer text prompts

I recently came across this brand new AI tool from Microsoft called Copilot Notebook. Its a new feature of Copilot, the AI assistant we all have been using for some time now. I'll tell you why you should also try Notebook. You dont' want to miss the 2nd feature.

How to capture Image from Webcam and add it to a Table element

WebCam.js is a JavaScript library that provides easy to use functions to capture pictures from your webcam. It’s a browser based API, which means you can integrate the library with a webpage. So, if you are web developer it will be easy for you to use it in your web application.

So, in this article I am going to show you how to capture webcam picture and add it to an HTML table.

Extract text within parentheses in Excel using RegEx

In this article, I am going to show you how to use RegEx (regular expressions) in Excel to extract text within parentheses using a custom regular expression function in VBA.

How to check if word document has tables using C# and VB

The Office Interop object in .Net has features that can be used to access Ms-Office objects like Excel, Word etc. In this article I am going to show you how to check if an "Ms-Word" document has a table and if yes, then does the table has columns.

What is the formula in Excel to count how many times a particular word occured in a range?

You can use the COUNTIF() function in Excel to count number of occurrences of a particular word in a range.

Let us assume, I have a list of different types of birds in the 2nd column in my Excel worksheet. I want to know how many times a bird of type "Dove" or "Sparrow" is entered in the list. Check the formula.

How to open and read contents of a text file in Python

Python offer two built-in methods that you can use to read contents in a text file. The methods are read() and readline(). Python can handle different types of files like a .txt file, a csv file or Excel worksheets etc. But in this article I am going to show you how to "open" a .txt file in Python and read its content as it is.

Excel formula to remove first four characters

Let us assume, I have some data in my Excel worksheet. From one particular column, I want to extract values after removing the first four characters. I am going to show you three different formulas using three Excel built-in functions to do this.

Excel formula to filter out four letter words

I have shared two simple formulas in this article showing how to "filter out" four letter words in Excel.

You can use a combination of Excel's built-in functions to achive this. Though, the formula is for four letter words, you can extract "n-letters" (any number of letters) word from a cell.

How to use RegEx in Excel to filter out email addresses from Cell

Microsoft has recently announced new REGEX functions in Excel. It is still a Beta version and is available only for some Microsoft insiders (Microsoft Community) . The functions will soon be available in Office 365.

However, you can you can create a custom RegEx function using VBA. I'll show you how.