Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
To declare an array in C#, you can use the following syntax −datatype[ ] Name_of_array;Here, datatype is used to specify the type of elements in the array.[ ] specifies the size of the array.Name_of_array specifies the name of the array.The following is an example −double[ ] balance;Let us see an example in which an array is declared and values are added to it −Example Live Demousing System; namespace ArrayApplication { class MyArray { static void Main(string[] args) { int [ ] n = new int[10]; /* n is an array of 10 ... Read More
The Main method states what the class does when executed and instantiates other objects and variables.A main method is static since it is available to run when the C# program starts. It is the entry point of the program and runs without even creating an instance of the class.The following shows how to add a Main() method with static −Example Live Demousing System; namespace Demo { class HelloWorld { static void Main(string[] args) { Console.WriteLine("Bingo!"); Console.ReadKey(); } } }OutputBingo!As you can see in ... Read More
It can be understood with the help of an example in which two tables are having some values and we subtract the values with the help of LEFT JOIN. Here we are taking two tables having the following data −mysql> Select * from value_curdate; +----+----------+-------+ | Id | Product | Price | +----+----------+-------+ | 1 | Notebook | 100 | | 2 | Pen | 40 | | 3 | Pencil | 65 | +----+----------+-------+ 3 rows in set (0.00 sec) mysql> Select * from value_prevdate; +----+-----------+-------+ | Id | Product | ... Read More
Actually, INTERSECTION is just an inner join on all columns. We are taking a simple example of two tables, having the data as follows −mysql> Select * from value1; +------+------+ | i | j | +------+------+ | 1 | 1 | | 2 | 2 | +------+------+ 2 rows in set (0.00 sec) mysql> Select * from value2; +------+------+ | i | j | +------+------+ | 1 | 1 | | 3 | 3 | +------+------+ 2 rows in set (0.00 sec)Now, the following query will do the INTERSECTION between these tables −mysql> Select * from value1 join value2 using(i,j); +------+------+ | i | j | +------+------+ | 1 | 1 | +------+------+ 1 row in set (0.08 sec)
The DateTime class in C# is used to represent date and time in C#.The following are some of the properties of DateTime in C# −Sr.NoProperty & Description1DateGets the Date component2DayGets the day of the month3HourGets the hour of the month4MinuteGets the minute of the date5MonthGets the month of the dateLet us see an example to compare date in C#.To compare dates in C#, you need to first set two dates to be compared using the DateTime object. We will use the DateTime class in C# −Date 1DateTime date1 = new DateTime(2018, 07, 20); Console.WriteLine("Date 1 : {0}", date1);Date 2DateTime date2 ... Read More
We can get the differences between the tables by unioning exclusion joins from 1st table to 2nd table and from 2nd table to 1st table. To understand it, we are taking the example of following two tables −mysql> Select * from value1; +-----+-----+ | i | j | +-----+-----+ | 1 | 1 | | 2 | 2 | +-----+-----+ 2 rows in set (0.00 sec) mysql> Select * from value2; +------+------+ | i | j | +------+------+ | 1 | 1 | | 3 | 3 ... Read More
The maximum possible value of an integer is 2, 147, 483, 647.The following are the datatypes of C# with the maximum and minimum value −TypeRepresentsRangeDefault ValueboolBoolean valueTrue or FalseFalsebyte8-bit unsigned integer0 to 255char16-bit Unicode characterU +0000 to U +ffff'\0'decimal128-bit precise decimal values with 28-29 significant digits(-7.9 x 1028 to 7.9 x 1028) / 100to 280.0Mdouble64-bit double-precision floating point type(+/-)5.0 x 10-324 to (+/-)1.7 x 103080.0Dfloat32-bit single-precision floating point type-3.4 x 1038 to + 3.4 x 10380.0Fint32-bit signed integer type-2, 147, 483, 648 to 2, 147, 483, 6470long64-bit signed integer type-9, 223, 372, 036, 854, 775, 808 to 9, 223, 372, ... Read More
We can distinguish between MySQL CROSS JOIN and INNER JOIN only on the basis of join-predicate i.e. the condition specified. While writing the query for INNER JOIN we need to specify the condition but in contrast, we do not need to specify the condition while writing a query for CROSS JOIN. To understand it, we are taking the example of two tables named tbl_1 and tbl_2 which are having following data −mysql> Select * from tbl_1; +----+--------+ | Id | Name | +----+--------+ | 1 | Gaurav | | 2 | Rahul | | 3 | Raman | | 4 ... Read More
Count the number of elements in the BitArray class using the Count property.Let us first set our BitArray class −BitArray arr = new BitArray(10);Now use the Count property as shown below −Example Live Demousing System; using System.Collections; public class Demo { public static void Main() { BitArray arr = new BitArray(10); Console.WriteLine( "Count: {0}", arr.Count ); } }OutputCount: 10
To find the count of elements of Hashtable class, use the Count property. Firstly, set the Hashtable class with elements −Hashtable ht = new Hashtable(); ht.Add("One", "Tom"); ht.Add("Two", "Jack"); ht.Add("Three", "Peter"); ht.Add("Four", "Russel"); ht.Add("Five", "Brad"); ht.Add("Six", "Bradley"); ht.Add("Seven", "Steve"); ht.Add("Eight", "David");Now, count the number of elements using the Count property −ht.CountThe following is the complete example to learn about the usage of Hashtable Count property in C#.Example Live Demousing System; using System.Collections; namespace Demo { class Program { static void Main(string[] args) { Hashtable ht = new Hashtable(); ... Read More