Object Type C# Example

C# > Types > object

 You can assign values of any type to variables of type object. 

Example

object obj;

obj = 1; 

string type =  obj.GetType().Name; //Int32

   

obj = "string";

type = obj.GetType().Name; //String

Dns Get Host By Name C# Example

C# > System.Net > Dns

Retrieves information about a specific host from the Internet Domain Name System (DNS).

Example

  IPHostEntry hostInfo = Dns.GetHostByName("www.microsoft.com");

  string hostName = hostInfo.HostName;

  IPAddress[] addressList = hostInfo.AddressList;

  foreach (IPAddress ipAddress in addressList)

  {

              

  }

C# System.Net

C# > System.Net

Provides  programming interface for:

• network protocols
• cache policies
• e-mail
• network traffic data and network address information
• networking functionality

Classes:

• Dns

Namespaces

• NetworkInformation

STR SQL Server Example

SQL Server > Built-in Functions > STR

Converts number to varchar.

STR ( expression , length , decimal )

Example:

SELECT STR(123.45, 6, 1);

GO

result
 123.5

Assembly Class C# Example

C# > System > Reflection > Assembly

Assembly class:

• load assemblies
• explore the metadata 
• find the types contained in assemblies and to create instances of those types.

Example

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 WindowsFormsApplication27

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        private void Form1_Load(object sender, EventArgs e)

        {

            Assembly a = typeof(Form1).Assembly;

            MessageBox.Show(a.FullName);

        }

    }

}

Reflection C#

C# > System > Reflection

Reflection provides objects that encapsulate assemblies, modules and types.
With reflection you can read metadata for finding assemblies, modules and types information at runtime. 
These objects also can be used to manipulate instances of loaded types.

• Asembly class

Func C# Example

C# > System > Func

Func is a parameterized type. 

• accepts any number and kinds of input parameters
• one type of the return value T
• stores anonymous methods 

Example

1. Func<T, TResult>

Func<int, int> power = p => p * p;

int[] numbers = { 1, 2, 3 };

IEnumerable<int> powers = numbers.Select(power);

foreach (int p in powers)

     Console.WriteLine(p);

Dynamic Language Runtime C#

C# > System > Dynamic

Dynamic Language Runtime.

• DynamicObject

Dynamic Object Runtime C# Example

C# > Sytem.Dynamic > DynamicObject

DynamicObject specifies dynamic behavior at run time.






Example:

Create dynamic object in runtime.

Dynamically Add C# Properties at Runtime.

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Dynamic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace WindowsFormsApplication26

{

    public class MyDynamicObject : DynamicObject

    {

        Dictionary<string, object> dictionary = new Dictionary<string, object>();

        public object this[string propertyName]

        {

            get

            {

                return dictionary[propertyName];

            }

            set

            {

                dictionary[propertyName] = value;

            }

        }

        public override bool TryGetMember(

            GetMemberBinder binder, out object result)

        {

            return dictionary.TryGetValue(binder.Name, out result);

        }

        public override bool TrySetMember(

            SetMemberBinder binder, object value)

        {

            dictionary[binder.Name] = value;

            return true;

        }

      

        public override bool TrySetIndex(

            SetIndexBinder binder, object[] indexes, object value)

        {

            int index = (int)indexes[0];

            if (dictionary.ContainsKey("Property" + index))

                dictionary["Property" + index] = value;

            else

                dictionary.Add("Property" + index, value);

            return true;

        }

    }

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        private void Form1_Load(object sender, EventArgs e)

        {

            dynamic obj = new MyDynamicObject();

            obj["column1"] = 1;

            obj.column2 = 2;

            var v1 = obj["column1"];

            var v2 = obj.column2;

        }

    }

}

Telerik RadTimePicker Get Selected Time

Telerik > RadTimePicker > Get Time

Get selected time from RadTimePicker c#.

DateTime dt = radTimePicker.SelectedDate.Value;
string time = dt.ToString("HH:mm:ss");

Call one constructor from another c#

C > Keywords > This > Call one constructor from another 

      public Constructor1()

      {

      }

      public Constructor2(string writer) : this()

      {

      }

Lambda Expressions in a Query C#

C# > Operators > Lambda > Query

We use  lambda expressions in method calls not directly in query syntax.

Simple Example

     int[] wages = { 1000, 1200, 1500, 1800, 2000, 2500 };
    int highWagesCount = wages.Where(n => n >= 2000).Count(); 

DataGridView Windows Forms Control

Windows Forms >  DataGridView Control

You can use a DataGridView control to display data with or without an underlying data source. 
DataGridView contains cells, rows, columns, and borders.
Without specifying a data source, you can create columns and rows that contain data and add them directly to the DataGridView using the Rows and Columns properties. 

• DataGridViewLinkCell
• RowFilter
• Numeric Column
• DataGridViewButtonColumn
• Scroll to selected index

HyperLink ASP.NET Example

ASP.NET > System.Web > Web Controls > HyperLink

Displays a link to another Web page.

Events

• onClick

Example

<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/WebForm1.aspx">HyperLink</asp:HyperLink>

Web Controls ASP.NET

ASP.NET > System.Web > Web Controls

Web server controls run on the server.

• HyperLink

ASP.NET Hyperlink OnClick Code Behind

ASP.NET > System.Web > Web Controls > > onClick

Script

<script br="" gt="" language="javascript" type="text/javascript">

function onClick(obj) {

}
lgt;/script>

C# Code behind

HyperLink1.Attributes.Add("onclick", "return onClick(this)");

Transact-SQL SQL Server

SQL Server > Transact-SQL

Transact-SQL is Microsoft's proprietary extension to SQL (Structured Query Language).
All applications that communicate with SQL Server use Transact-SQL to send statements to the server, regardless of the user interface of the application.

SET Statements

• NOCOUNT
• XACT_ABORT

Mnagements Commands

• Kill

Code Collaborator Add Changes To Review Number

Code Collaborator > Add changes to review

addhgdiffs - Uploads diffs generated by hg diff command

Example

Upload from Mercurial

3883 is the review number

-r difference from revision 0 to 1

ccollab addhgdiffs 3883 -r 0 -r 1

-c specific revision id

ccollab addhgdiffs codereviewid -c revisionid

PARSE SQL Server Example

SQL Server > Built-in Functions > PARSE

Translates an expression to the requested data type.

Example

SELECT PARSE('3-11-2014' AS datetime USING 'en-US') AS Result_En

Result_En

2014-03-11 00:00:00.000

SELECT PARSE('3-11-2014' AS datetime USING 'de-DE') AS Result_De

Result_De

2014-11-03 00:00:00.000

Telerik Reporting Binding C# Example

Telerik > Reporting > ObjectDataSource

ObjectDataSource component represents the middle-tier object and provides data retrieval capabilities. 
Example

var ods = new Telerik.Reporting.ObjectDataSource();

ods.DataSource = GetData();

ods.DataMember = "Products"; //table to bind to        

Telerik.Reporting.Report report = new Telerik.Reporting.Report();

report.DataSource = ods;

Telerik.Reporting.InstanceReportSource reportSource = new Telerik.Reporting.InstanceReportSource();

reportSource.ReportDocument = report;

reportViewer1.ReportSource = reportSource;

reportViewer1.RefreshReport();

Get Computer Name C#

C#  > System > Environment Class > MachineName

Returns the computer's name. This is established at system start up when the name is read from the registry. 

Example

   string _name = Environment.MachineName;

ADO.NET LINQ to SQL

ADO.NET >  LINQ to SQL

Is a component for managing relational data as objects. 

• the data model of a relational database is mapped to an object model  
• translates into SQL the language-integrated queries in the object model and sends them to the database for execution
• translates database result  back to objects 

Methods

• DeleteOnSubmit