MySql.Data.MySqlClient.MySqlDataReader.GetInt32 C# (CSharp) Method

GetInt32() public method

public GetInt32 ( int i ) : Int32
i int
return System.Int32
    public override Int32 GetInt32(int i)
    {
      IMySqlValue v = GetFieldValue(i, true);
      if (v is MySqlInt32)
        return ((MySqlInt32)v).Value;

      return (Int32)ChangeType(v, i, typeof(Int32));
    }

Same methods

MySqlDataReader::GetInt32 ( string column ) : Int32

Usage Example

Ejemplo n.º 1
0
        public Values getValues(int id)
        {
            Values v = new Values();

            MySql.Data.MySqlClient.MySqlDataReader mySQLReader = null;
            string sqlString = $"SELECT * FROM Products WHERE id ={id}";

            MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sqlString, conn);
            mySQLReader = cmd.ExecuteReader();

            if (mySQLReader.Read())
            {
                v.id             = mySQLReader.GetInt32(0);
                v.product_name   = mySQLReader.GetString(1);
                v.stock_quantity = mySQLReader.GetInt32(2);
                v.des_box        = mySQLReader.GetString(3);
                v.URL            = mySQLReader.GetString(4);
                v.categories     = mySQLReader.GetString(5);
                return(v);
            }
            else
            {
                return(null);
            }
        }
All Usage Examples Of MySql.Data.MySqlClient.MySqlDataReader::GetInt32