GetMySqlDecimal(String) Method

In This Topic

Gets the value of the specified column as a MySqlDecimal object.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function GetMySqlDecimal( _
   ByVal name As String _
) As MySqlDecimal

public MySqlDecimal GetMySqlDecimal( 
   string name
)

Parameters

name: The name of the column to get value of.

Return Value

The value of the specified column as a MySqlDecimal object.

Example

csharp

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();
  }
}

Visual Basic

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

Reference

MySqlDataReader Class
MySqlDataReader Members
Overload List

Send Feedback