dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlDataReader Class / GetMySqlGuid Method / GetMySqlGuid(Int32) Method
The zero-based column ordinal.
Example

In This Topic
    GetMySqlGuid(Int32) Method
    In This Topic
    Gets the value of the specified column as a MySqlGuid object.
    Syntax
    'Declaration
     
    Public Overloads Function GetMySqlGuid( _
       ByVal i As Integer _
    ) As MySqlGuid
    public MySqlGuid GetMySqlGuid( 
       int i
    )

    Parameters

    i
    The zero-based column ordinal.

    Return Value

    The value of the specified column as a MySqlGuid object.
    Example
    static void GetMySqlDecimal(MySqlConnection myConnection) {
    
      MySqlCommand cmd = new MySqlCommand("SELECT * FROM Test.AllTypes");
      cmd.Connection = myConnection;
      myConnection.Open();
      try {
        MySqlDataReader reader = cmd.ExecuteReader();
        reader.Read();
        MySqlDecimal recievedDecimal = reader.GetMySqlDecimal(reader.GetOrdinal("MySqlDecCol"));
        reader.Close();
      }
      finally {
        myConnection.Close();
      }
    }
    Shared Sub GetMySqlDecimal(ByVal myConnection As MySqlConnection)
      Dim cmd As New MySqlCommand("SELECT * FROM Test.AllTypes")
      cmd.Connection = myConnection
      myConnection.Open()
      Try
        Dim reader As MySqlDataReader = cmd.ExecuteReader
        reader.Read()
        Dim recievedDecimal As MySqlDecimal = reader.GetMySqlDecimal(reader.GetOrdinal("MySqlDecCol"))
        reader.Close()
      Finally
        myConnection.Close()
      End Try
    End Sub
    See Also