#Region Directive Visual Basic Example

Visual Basic > Directives > #Region

Collapses and hides sections of code.

Example:

Public Class Form1

#Region "Person"

    Public Class Person

    End Class

#End Region

    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load

    End Sub

End Class

Read XMLTYPE Oracle C#

C# > Oracle.DataAccess > Read XMLTYPE 

An OracleXmlType object represents an Oracle XMLType instance.

Example:

OracleConnection con = new OracleConnection() ;

con.ConnectionString = "Data Source=sid; User ID=xx; Password=xx; enlist=false; ";

con.Open();

OracleCommand xmlCmd = new OracleCommand();

xmlCmd.CommandText = "select xml from table ";

xmlCmd.Connection = con;

OracleDataReader poReader = xmlCmd.ExecuteReader();

OracleXmlType poXml;

while (poReader.Read())

{

     poXml = poReader.GetOracleXmlType(0);    

}

con.Close();

c# GuidAttribute Example

C# > InteropServices >  GuidAttribute 

Supplies an explicit Guid when an automatic GUID is undesirable.

When you write an application to be used as COM you have 
to give a unique name. In this case you need to apply GUID attribute.

Example

Class that is exported to COM with a fixed GUID

[GuidAttribute("bd2d60fa-8e40-4d06-ad6f-8760983efe33")]

public class ExposedToComClass

{

          

}

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;