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