Get all services C#

C# > ServiceProcess > Service Controller

It is a Windows service that allows you to connect to a service.

You can manipulate it or get information about it.

Example:

Get list of all services

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.ServiceProcess;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace WindowsFormsApplication1

{

    public class clsService

    {

        public string Name { get; set; }

        public string Type { get; set; }

        public string Status { get; set; }

    }

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        private void Form1_Load(object sender, EventArgs e)

        {

            ServiceController[] scServices;

            scServices = ServiceController.GetServices();

            List<clsService> lcs = new List<clsService>();

            foreach (ServiceController sc in scServices)

            {

                clsService cs = new clsService();

                cs.Name = sc.ServiceName;

                cs.Type = sc.ServiceType.ToString();

                cs.Status = sc.Status.ToString();

               

                lcs.Add(cs);

            }

            dgv.DataSource =lcs ;

        }

    }

}

Linq to SQL equivalent to TOP

C# > LINQ > Take

Take returns the first specified number of elements.

Example

Linq to SQL equivalent to TOP

var query = from q in dc.Queries.OrderBy(f => f.name).Take(10)

Oracle DBMS_SCHEDULER

Oracle >  SYS.DBMS_SCHEDULER 

The DBMS_SCHEDULER package provides a collection of scheduling functions and procedures.

• Create job

Oracle create job example

Oracle >  SYS.DBMS_SCHEDULER > CREATE_JOB

The CREATE_JOB procedure creates a single job. You can create multiple jobs using the CREATE_JOBS procedure.

Example:

Oracle create job example

BEGIN

    SYS.DBMS_SCHEDULER.CREATE_JOB (

            job_name => '"db"."job"',

            job_type => 'PLSQL_BLOCK',

            job_action => 'delete from item',

            number_of_arguments => 0,

            start_date => TO_TIMESTAMP('19-FEB-14 04.51.50.316000000 PM', 'DD-MON-RR HH.MI.SS.FF AM'),

            repeat_interval => 'FREQ=DAILY;BYHOUR=3',

            end_date => NULL,

            job_class => 'DEFAULT_JOB_CLASS',

            enabled => false,

            auto_drop => true,

            comments => NULL);

END;

sys.schemas SQL Server example

SQL Server > Catalog Views > sys.schemas

Gets information about database schema.

Example:

select * from sys.schemas

Result

Timestamp to date Oracle

Oracle > Timestamp > To Date

select * from your_table
where
TO_DATE (TO_CHAR (timestamp_date, 'YYYY-MON-DD'),'YYYY-MON-DD') = '18-FEB-2014'
 

sys.data_spaces SQL Server

SQL Server > Catalog Views > sys.data_spaces

Return info for each data space.

Example

select * from sys.data_spaces

Add Image Column to Telerik Radgrid

Telerik > RadGridView > GridViewImageColumn

GridViewImageColumn displays read-only images for database columns of image data





GridViewImageColumn imageColumn = new GridViewImageColumn();
imageColumn.Name = "imgCol";
imageColumn.FieldName = "dbPhoto";
imageColumn.HeaderText = "Picture";
imageColumn.ImageLayout = ImageLayout.Zoom; // Zoom - Image is zoomed but the aspect ratio is preserved:
radGridView1.MasterTemplate.Columns.Insert(3, imageColumn);

Using Joins SQL Server Examples

SQL SERVER > QUERY > JOIN

Using joins you can retrieve data from two or more tables based on logical relationships between the tables.

create table #category(name varchar(20), description  varchar(20))

insert into #category(name,description)
values('cat 1','cat 1 description')
insert into #category(name,description)
values('cat 2','cat 2 description')
insert into #category(name,description)
values('cat 3','cat 3 description')

create table #product(id int, name varchar(20), category varchar(20))

insert into #product(id,name,category)

values(1,'product 1','cat 1')
insert into #product(id,name,category)
values(2,'product 2','cat 2')
insert into #product(id,name,category)
values(2,'product 3',null)

INNER JOIN  returns all the columns in both tables, and returns only the rows for which there is an equal value in the join column. 

select p.id, p.name, c.description as category

from #product p
inner join #category c
       on p.category = c.name

LEFT OUTER JOIN includes all rows in the a table  whether or not there is a match on the another table.

select p.id, p.name, c.description as category

from #product p
left  join #category c
       on p.category = c.name

RIGHT OUTER JOIN indicates all rows in the second table are to be included in the results, regardless of whether there is matching data in the first table.

select p.id, p.name, c.description as category

from #product p
right  join #category c
       on p.category = c.name

FULL OUTER JOIN includes all rows from both tables, regardless of whether or not the other table has a matching value.

select p.id, p.name, c.description as category

from #product p
full  join #category c
       on p.category = c.name

CROSS JOIN produces the Cartesian product of the tables involved in the join.

 select p.id, p.name, c.description as category
from #product p
cross join #category c

      

drop table #product

drop table #category

ABS SQL Server Example

SQL Server > Built-in Functions > ABS

Returns the absolute positive value of a numeric expression.

Example

DECLARE @i int;
SET @i = -333;
SELECT ABS(@i);

Result:
333


  

Power SQL Server Example

SQL Server > Built-in Functions > POWER

Returns the value of a number to the specified power.

Example:

select power(2,4)

Result:

16  

ORA_ROWSCN Oracle example

Oracle

ORA_ROWSCN returns the conservative upper bound system change number (SCN) of the most recent change to the row. This is useful for determining approximately when a row was last updated.

Example

Get the system change number of the last operation on the items table

SELECT ORA_ROWSCN, item_name FROM items WHERE item_id = 10;

Convert binary data to MemoryStream C#

C# > IO > MemoryStream

Creates a stream whose backing store is memory.

Example:

Convert binary data to MemoryStream

public MemoryStream GetMemoryFile(System.Data.Linq.Binary image)
{   
   return new MemoryStream(image.ToArray());
}

SPACE SQL Server Example

SQL Server > Built-in Functions > SPACE

Returns a string of repeated spaces.

Example:

declare

@str nvarchar(max),
@str1 nvarchar(max)

set @str='SQL'
set @str1='SERVER'

select @str + SPACE(5) + @str1


Result:
SQL     SERVER  

RIGHT function SQL Server Example

SQL Server > Built-in Functions > RIGHT

Returns the right part of a string with the specified number of characters.

Example:

declare @str nvarchar(max)
set @str='SQL Server'
select right(@str,6)

Result:
Server