dotConnect for DB2 Documentation
Devart.Data.DB2 Namespace / DB2DataReader Class / GetGuid Method / GetGuid(Int32) Method
Example

GetGuid(Int32) Method
Gets the value of the specified column as a globally-unique identifier (GUID).
Syntax
'Declaration
 
Public Overloads Overrides Function GetGuid( _
   ByVal i As Integer _
) As Guid
 

Parameters

i

Return Value

The value of the specified column.
Example
static void GetMyGuid(DB2Connection myConnection) {
  DB2Command cmd = new DB2Command("SELECT * FROM AllTypes");
  cmd.Connection = myConnection;
  myConnection.Open();
  try {
    DB2DataReader reader = cmd.ExecuteReader();
    reader.Read();
    Guid recievedGuid = reader.GetGuid(reader.GetOrdinal("GuidCol"));
    reader.Close();
  }
  finally {
    myConnection.Close();
  }
}
Shared Sub GetMyGuid(ByVal myConnection As DB2Connection)
  Dim cmd As New DB2Command("SELECT * FROM AllTypes")
  cmd.Connection = myConnection
  myConnection.Open()
  Try
    Dim reader As DB2DataReader = cmd.ExecuteReader
    reader.Read()
    Dim recievedGuid As Guid = reader.GetGuid(reader.GetOrdinal("GuidCol"))
    reader.Close()
  Finally
    myConnection.Close()
  End Try
End Sub
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also