SerialPort Class Example

C# > IO  > Ports > SerialPort

SerialPort controls a serial port file resource. 

Example

1. Gets all serial port names for the current computer.

List<String> serialPorts = new List<String>();

foreach (String portName in System.IO.Ports.SerialPort.GetPortNames())

{

  serialPorts.Add(portName);

}

System.IO.Ports Namespace C#

C# > IO  > Ports

System.IO.Ports contains classes for controlling serial port.

• SerialPort

CAST SQL Server Example

SQL Server > Built-in Functions > CAST

CAST converts an expression of one data type to another.

CAST ( expression AS data_type )

Examples

• String to number
• Number to date
• Date only - no time

ROWCOUNT SQL Server Example

SQL Server > Built-In Functions > @@ROWCOUNT

Returns the number of rows affected by the last statement.

Example:

UPDATE Person
SET Age = 31
WHERE Id = 1
IF @@ROWCOUNT = 0
    PRINT 'No rows were updated';