I am reading some values out of a SQLite database like so:
List<String> choctypusValsForUPCCode = new List<string>();
. . .
using (SQLiteDataReader rdr = cmd.ExecuteReader())
{
choctypusValsForUPCCode.Add(rdr.GetInt32(0).ToString()); // Line_id (int32)
choctypusValsForUPCCode.Add(rdr.GetString(1)); // Description (String)
choctypusValsForUPCCode.Add(rdr.GetString(2)); // Department (String)
choctypusValsForUPCCode.Add(rdr.GetString(3)); // Vendor_id (String)
choctypusValsForUPCCode.Add(rdr.GetInt32(4).ToString()); // Upc_pack_size (int32)
choctypusValsForUPCCode.Add(rdr.GetInt32(5).ToString()); // Pack_size (int32)
choctypusValsForUPCCode.Add(rdr.GetFloat(6).ToString()); // Unit_cost (single) // GetDouble? GetDecimal?
choctypusValsForUPCCode.Add(rdr.GetFloat(7).ToString()); // Unit_list (single) " "
choctypusValsForUPCCode.Add(rdr.GetFloat(8).ToString()); // Unit_qty (single) " "
}
When the data type of the underlying column is Single, which "Get" method of SQLiteDataReader should I use (there is no "GetSingle")? Is GetFloat, GetDouble, or GetDecimal the preferred method?
Aucun commentaire:
Enregistrer un commentaire