MySqlDecimal Structure

In This Topic

Represents MySQL type DECIMAL.

Syntax

Visual Basic
C#


'Declaration Public Structure MySqlDecimal Inherits System.ValueType Implements System.Data.SqlTypes.INullable, System.IComparable, System.IConvertible, System.IFormattable, System.Xml.Serialization.IXmlSerializable

'Declaration
 
Public Structure MySqlDecimal 
   Inherits System.ValueType
   Implements System.Data.SqlTypes.INullable, System.IComparable, System.IConvertible, System.IFormattable, System.Xml.Serialization.IXmlSerializable


public struct MySqlDecimal : System.ValueType, System.Data.SqlTypes.INullable, System.IComparable, System.IConvertible, System.IFormattable, System.Xml.Serialization.IXmlSerializable

Remarks

This structure was created because the System.Decimal type cannot handle all MySQL DECIMAL values. Like MySQL Server, the MySqlDecimal structure internally stores its value as a string, which allows working with huge numbers.

Example

The following example demonstrates how to insert to and fetch from a table some MySqlDecimal values.

csharp


MySqlCommand insertCommand = new MySqlCommand("INSERT INTO decimal_test (f_decimal) VALUES (:p1)", connection); insertCommand.Parameters.Add("p1", MySqlDecimal.MaxValue); insertCommand.ExecuteNonQuery(); MySqlCommand selectCommand = new MySqlCommand("SELECT f_decimal FROM decimal_test", connection); using (MySqlDataReader reader = selectCommand.ExecuteReader()) while (reader.Read()) for (int i = 0; i < reader.FieldCount; ++i) Console.WriteLine(reader.GetProviderSpecificValue(i));

MySqlCommand insertCommand = new MySqlCommand("INSERT INTO decimal_test (f_decimal) VALUES (:p1)", connection);

 insertCommand.Parameters.Add("p1", MySqlDecimal.MaxValue);
 insertCommand.ExecuteNonQuery();

 MySqlCommand selectCommand = new MySqlCommand("SELECT f_decimal FROM decimal_test", connection);

 using (MySqlDataReader reader = selectCommand.ExecuteReader())
   while (reader.Read())
     for (int i = 0; i < reader.FieldCount; ++i)
       Console.WriteLine(reader.GetProviderSpecificValue(i));

Inheritance Hierarchy

System.Object
System.ValueType
Devart.Data.MySql.MySqlDecimal

Reference

MySqlDecimal Members
Devart.Data.MySql Namespace

Send Feedback