OneAnanda (Code Center)

C# Shortcuts for quick programming   C# comes with full of surprises when you are doing the coding, here is the short list of commands that you can use it to generate the C# code automatically and quickly Enter prop and press tab 2 times (prop tab tab) Generate a property public int MyProperty { get ; set ; } class tab tab Generates a empty class         class MyClass         {                     } Ctor tab tab (inside the class) Generates a parameter less constructor             public MyClass()             {               } For tab tab Generates an empty for loop             for ( int i = 0; i < length; i++)             {                             } Foreach tab tab Generates an empty foreach loop               foreach ( var item in collection)             {                             } Do tab tab   Generates an empty do while loop               do              {                             } while

Beginners Level: C# Program to convert the list of string to CSV with quotes  There may be the situation where we need to build any dynamic SQL queries to fetch the data programmatically, Example: SELECT * FROM ORDERS WHERE DELIVERY_LOCATION IN ('Sydney', 'Singapore', 'Tokyo', 'Jakarta'); For this we need to have  // Program to convert the list of string to CSV with quotes static void Main( string [] args) {   List < string > LstCities = new List < string >();   LstCities .Add( " Sydney "); LstCities .Add( " Singapore "); LstCities .Add( " Tokyo "); LstCities .Add( " Jakarta ");     string InClause = string .Format( "'{0}'" , string .Join( "','" , LstCities )); Console .WriteLine( InClause ); Console .ReadLine(); } This will print 4 city names in the following format  ' Sydney ', ' Singapore ', ' Tokyo ', ' Jakarta '

Let's Start by Converting int to long  Example 1:       int  IntValue = 10; long  LongValue; // Converting int to long is easy LongValue = IntValue; // The above code will work as we are converting from small memory size to bigger one Example 2: int IntValue = 10; long LongValue = 1000; // Converting int to long is NOT easy possible IntValue = LongValue; // The above code will NOT work as we are converting from bigger memory size to smaller one, // Even though we are assigning the values to int that is capable of holding Compiler Error: Cannot implicitly convert type 'long' to 'int'. An explicit conversion exists (are you missing a cast?) So how do we convert? here comes the explicit conversion technique, Example 3: int IntValue = 10; long LongValue = 1000; IntValue = ( int )LongValue; This will perfectly work  but explicit conversion has some dangers, we will see what