What is StringBuilder in C# and How to Use it

StringBuilder in C# with Examples This tutorial describes what StringBuilder is in C# and how to use it. A StringBuilder is a class that presents a mutable string of characters. More C# tutorials: How to write to file in C# How to read text from a file in C# StringBuilder Initialization You can initialize a … Read more

C# Read Text File with StreamReader

How to Read Text from A File with StreamReader This tutorial describes how to read text from a file with StreamReader in C#. StreamReader provides various methods to read text from a file. Related tutorial: How to write to a file in C# with StreamWriter ReadToEnd Method You can write a program to read text from a … Read more

C# Write to File with the File Class and StreamWriter

How to Write Strings and Text to File in C# This tutorial describes how to write strings and text to a file with the File class and StreamWriter in C#. Related tutorial: How to read text from a file with StreamReader 1. Writing text to a file with the File class WriteAllText Method To write text to a … Read more

C# switch case Statements with Examples

How to Use switch case Statements in C# This tutorial describes how to use switch case statements in C#.  The switch statement chooses one of the blocks of code, which matches the switch expression to execute. We often use the switch-case statements when we test a single expression against three or more conditions. You can use if-else if there are only a few … Read more

C# if-else Statements with Examples

How to Use the if-else Statements in C# This tutorial describes how to use the if-else statement in C# programming language. An if statement decides which block of code to execute based on a specified condition. If the specified condition evaluates to true, then code inside the if statement block runs. If the specified condition is false, code inside the else statement block … Read more

C# while Loop Statement with Examples

How to use a while Loop Statement in C# This tutorial describes how to use a while loop statement in C#. A while loop is a control flow statement to execute a block of code while a specified condition evaluates to true. A while loop can execute zero or more times.  If you need to break out the loop, … Read more

C# for Loop Statement with Examples

How to Use the for Loop Statement in C# This tutorial describes how to use the C# for loop statement.A for loop is a control flow statement that you allow you to execute a block of code repeatedly. Related C# tutorials: C# foreach loop statement C# while loop statement The for Loop Syntax The syntax … Read more

Excel ROUNDUP Function with Examples

How to Use the ROUNDUP Function in Excel In this tutorial, you’ll learn how to use the Excel ROUNDUP function.  ROUNDUP is a function to round a number up away from 0. ROUNDUP Syntax The syntax of the ROUNDUP() function is as follows: =ROUNDUP(number, num_digits) Return value A rounded number Arguments number: the number that you want … Read more

Excel MIN Function with Examples

How to Use the MIN Function in Excel In this tutorial, you’ll learn how to use the Excel MIN function.  MIN is a function to get the smallest value in a set of values. MIN Syntax The syntax of the MIN() function is as follows: =MIN(value1, [value2], …) Arguments value1: The first argument value2: [Optional]. The second … Read more

Excel COUNTA Function – Count Non-Blank Cells in Excel

How to Use the COUNTA Function to Count Non-Blank Cells in Excel In this tutorial, you’ll learn how to use the Excel COUNTA function to count non-blank cells. You want to count the number of cells that are not blank, including both numbers and strings. In such a case, you can use the COUNTA function. COUNTA is … Read more

MySQL SUBSTRING_INDEX Function with Examples

How to Use the MySQL SUBSTRING_INDEX() Function In this tutorial, you’ll learn how to use the MySQL SUBSTRING_INDEX() function.  SUBSTRING_INDEX() returns a substring of a given string before a specified number of occurrences of delimiter. MySQL SUBSTRING_INDEX() Syntax The syntax of the SUBSTRING_INDEX() function is as follows: SUBSTRING_INDEX(string, delimiter, count) Arguments String: Required. The text from which you … Read more

MySQL EXISTS Operator with Examples

How to Use The MySQL EXISTS Operator In this tutorial, you’ll learn how to use the MySQL EXISTS operator. The EXISTS operator is used in a subquery to test for the existence of any record in the subquery. If the subquery returns one or more records, the EXISTS operator returns true, otherwise, returns false. MySQL EXISTS Syntax The syntax of the … Read more

MySQL ROW_NUMBER Function with Examples

How to Use the ROW_NUMBER Function in MySQL In this tutorial, you’ll learn how to use the MySQL ROW_NUMBER function. ROW_NUMBER returns the number of the current record within its partition of a result set. MySQL ROW_NUMBER() Syntax The syntax of the ROW_NUMBER() function is as follows: ROW_NUMBER() OVER( PARTITION BY expression [, expression], … ORDER BY expression [ASC | DESC], [, expression], … Read more

MySQL CONCAT() Function with Examples

How to Use the MySQL CONCAT() Function In this tutorial, you’ll learn to use the MySQL CONCAT() function. CONCAT() is a function to add two or more expressions together. MySQL CONCAT() Syntax CONCAT(expression1, expression2,…, expressionN) Remarks The first expression is required CONCAT returns NULL if any expression NULL Examples Combining Several Strings The following illustrates an example of using  CONCAT() to combine … Read more

MySQL IN Operator with Examples

How to Use the MySQL IN Operator In this tutorial, you’ll learn how to use the MySQL IN operator. The IN operator is used to check if a value is within a set of values. MySQL IN Syntax The following is the syntax of the IN operator: SELECT column_name1, column_name2, …, column_nameN FROM table_name WHERE column_name IN (value1, value2, … Read more

Excel SUMIFS Function – Multiple Criteria

How to Use the SUMIFS Function in Excel In this tutorial, you’ll learn how to use the Excel SUMIFS function to sum cells that match multiple criteria. When aggregating in Excel, you may want to calculate the sum of numerical values that satisfy multiple conditions.The SUMIFS function allows you to find the sum of numbers that … Read more

Excel COUNTIFS Function with Examples

How to Use​ the COUNTIFS Function in Excel In this tutorial, you’ll learn how to use the Excel COUNTIFS function.  COUNTIFS() is a function to count the number of cells in a range that meet multiple criteria.  You can use COUNTIFS() to count cells that contain dates, numbers, or references containing numbers. COUNTIFS() Syntax The syntax of the COUNTIFS() function … Read more