Search This Blog

Tuesday, June 24, 2014

Public keyword C# Example

C# > Keywords > public

Public is the most permissive access level. 

It is no restrictions on accessing public members.






Example


using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication12
{
    public partial class Form1 : Form
    {
        public class Person
        {
            public string Name;
            public int Age;
        }

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            Person p = new Person();
            p.Name = "John";
            p.Age = 35;
        }
    }
}




Wednesday, June 18, 2014

Implement Strings Enum in C#

C# > Types > Enum > String Enum


Implement Strings Enum in C#









using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace EnumString
{
    public partial class Form1 : Form
    {
        public enum Cars
        {
            [Description("Audi")] Audi,   
            [Description("Bmw")] Bmw,   
            [Description("Land Rover")] LandRover
        }
        public static string GetCarDescription(Enum car)
        {
            FieldInfo fi = car.GetType().GetField(car.ToString());
            DescriptionAttribute[] da = (DescriptionAttribute[])fi.GetCustomAttributes(typeof(DescriptionAttribute), false);
            if (da != null && da.Length > 0)       
                return da[0].Description;
            else      
                return da.ToString();
        }
        public static IEnumerable EnumToList()
        {   
            Type type = typeof(T);   
            Array vals = Enum.GetValues(type);   
            List valList = new List(vals.Length);   
            foreach (int val in vals)   
            {
                valList.Add((T)Enum.Parse(type, val.ToString()));   
            }
            return valList;
        }
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            foreach (Cars car in EnumToList<Cars>())
            {
                comboBox1.Items.Add(GetCarDescription(car));
            }
        }
    }
}





Friday, June 13, 2014

Format SQL Server Example

SQL Server > Built-in Functions > FORMAT

Formats a values to specific format.






Example:

A.
DECLARE @d DATETIME = '10/17/2014';
SELECT FORMAT ( @d, 'd', 'en-US' ) AS 'US English Result'
      ,FORMAT ( @d, 'd', 'de-de' ) AS 'German Result'

      ,FORMAT ( @d, 'd', 'ro-ro' ) AS 'Romanian Result';

Result

US English Result German Result Romanian Result
10/17/2014         17.10.2014 17.10.2014

B.
DECLARE @d DATETIME = GETDATE();
SELECT FORMAT( @d, 'dd/MM/yyyy')

Result
(No column name)
13/06/2014

C.
SELECT FORMAT(100, 'N', 'en-us') AS 'Number Format',FORMAT(200, 'C', 'en-us') AS 'Currency Format'

Result
Number Format Currency Format
100.00         $200.00