Union SQL Server

SQL Server > Operators > Union

Union combines the results of queries into a single result set.

The number of the columns must be the same in all queries.
The data types must be compatible.

All incorporates all rows into the results and includes duplicates. If not specified, duplicate rows are removed.

Example

create table #t(name varchar(50))

insert into #t(name) values ('1')
insert into #t(name) values ('2')
insert into #t(name) values ('3')

create table #t1(name varchar(50))

insert into #t1(name) values ('1')
insert into #t1(name) values ('4')
insert into #t1(name) values ('5')

select * from #t

union
select * from #t1

Result:
name
1
2
3
4
5

select * from #t

union all

select * from #t1

Result:

name

1
2
3
1
4
5

 

How to format datetime and date in Sql Server

SQL Server > Built-in Functions > CONVERT

Examples to display date/time data in different formats.

SELECT convert(varchar, getdate(), 100) -- mon dd yyyy hh:miAM (or PM)

SELECT convert(varchar, getdate(), 101) -- mm/dd/yy
SELECT convert(varchar, getdate(), 102) -- yy.mm.dd
SELECT convert(varchar, getdate(), 103) -- dd/mm/yy
SELECT convert(varchar, getdate(), 104) -- dd.mm.yyyy
SELECT convert(varchar, getdate(), 105) -- dd-mm-yyyy
SELECT convert(varchar, getdate(), 106) -- dd mon yyyy
SELECT convert(varchar, getdate(), 107) -- mon dd, yyyy
SELECT convert(varchar, getdate(), 108) -- hh:mm:ss
SELECT convert(varchar, getdate(), 109) -- mon dd yyyy hh:mm:ss:mmmAM (or PM)
SELECT convert(varchar, getdate(), 110) -- mm-dd-yyyy
SELECT convert(varchar, getdate(), 111) -- yyyy/mm/dd
SELECT convert(varchar, getdate(), 112) -- yyyymmdd
SELECT convert(varchar, getdate(), 113) -- dd mon yyyy hh:mm:ss:mmm
SELECT convert(varchar, getdate(), 114) -- hh:mm:ss:mmm
SELECT convert(varchar, getdate(), 120) -- yyyy-mm-dd hh:mm:ss
SELECT convert(varchar, getdate(), 121) -- yyyy-mm-dd hh:mm:ss.mmm
SELECT convert(varchar, getdate(), 126) -- yyyy-mm-ddThh:mm:ss.mmm

Open Excel file C#

C# > Diagnostics > Process > Start


Starts a process resource.

Example

using System.Diagnostics;

Process.Start("Excel.exe", @"C:\MyExcelfile.xlsx");

Populating a DataSet and table from a DataAdapter C#

C# > Data >  Populating DataSet and DataTable

SQL Adapter to executes the SQL statement or stored procedure referenced in its SelectCommand and put the results into a table in the dataset.
Than you call data adapter's Fill method.  
If the dataset contains multiple tables, you should have separate data adapters for each table and must therefore fill each table separately.

Example:

SqlConnection con = new SqlConnection("connString");

SqlCommand com = new SqlCommand("exec your_stored_procedure", con);
com.CommandTimeout = 30;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = com;
con.Open();
DataSet ds = new DataSet();
da.Fill(ds, "Data");
DataTable dt = ds.Tables[0];
con.Close();

           

Set minimum and maximum value to GridViewDecimalColumn Telerik RadGridView

Telerik > Windows Forms > RadGridView > GridViewDecimalColumn

GridViewDecimalColumn allows decimal data to be displayed and edited and can be bound to fields of any numeric type.

Examples:

1. Add GridViewDecimalColumn in runtime

GridViewDecimalColumn decimalColumn = new GridViewDecimalColumn();
decimalColumn.Name = "Price";
decimalColumn.HeaderText = "Price";
decimalColumn.FieldName = "Price";
decimalColumn.DecimalPlaces = 2;
radGridView1.MasterTemplate.Columns.Add(decimalColumn);

2. Set minimum and maximum value to GridViewDecimalColumn Telerik RadGridView

GridViewDecimalColumn decimalColumn = (GridViewDecimalColumn)this.radGridView1.Columns[0];

decimalColumn.Minimum = 1;
decimalColumn.Maximum = 100;

How to limit the text length in RadGridView cell

void radGridView1_CellEditorInitialized(object sender, GridViewCellEventArgs e)

{

if (e.ColumnIndex == 1)

{

if (e.Column is GridViewTextBoxColumn)

{

((RadTextBoxEditorElement)((RadTextBoxEditor)this.radGridView1.ActiveEditor).EditorElement).MaxLength = 100;

}

}

}

 

Interface C#

C# > Types > Interface

An interface contains only the signatures of properties and methods.

The implementation of the methods is done in the class that implements the interface.

Interfaces can contain:

• methods
• properties
• events
• indexers

An interface can't contain:

• constants
• fields
• operators
• instance constructors
• destructors
• types

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 WindowsFormsApplicationCS

{
    interface IAnimal
    {
        string Name { get; set; }
        string Type { get; set; }
    }
    class Dog : IAnimal, IComparable
    {
        private string strName;
        private string strType;

        public Dog(string name)
        {
            this.Name = name;
        }

        public string Name
        {
            get { return strName; }
            set { strName = value; }
        }

        public string Type
        {
            get { return strType; }
            set { strType = value; }
        }

        public int CompareTo(object obj)
        {
            if (obj is IAnimal)
                return this.Name.CompareTo((obj as IAnimal).Name);
            return 0;
        }
    }

    public partial class Form1 : Form

    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)

        {
            Dog dog1 = new Dog("Dog1");
            dog1.Type = "Carnivore";

            Dog dog2 = new Dog("Dog2");

            dog2.Type = "Carnivore";

            Dog dog3 = new Dog("Dog3");

            dog3.Type = "Carnivore";

            int x = dog1.CompareTo(dog2);  // reurn -1

            int y = dog1.CompareTo(dog3);  // reurn 0
        }
    }
}