Assuming your column is the SQL type "int", I'd suggest the following:
As you're stepping through your code, execute reader[3] and
reader[3].GetType() inside the watch window, to verify what the actual
value and its type is - just to make sure you're even looking at the
right column.
On Nov 10, 6:56 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
wrote:
> I'm currently trying my hand at constructing an online game. In my
> system, the attacks a character can execute are themselves objects,
> and their info is stored within the db. Unfortunately, I'm having a
> problem retrieving attack info from the db. Specifically, I'm getting
> an InvalidCastException when trying to retrieve an integer value.
>
> My table is pretty straight forward:
>
> hackerAttacksId - int identity primary key
> level - int
> name - string
> tpCost - int
> dmgModifier - float
> hitPenalty - float
>
> My code, which is in the constructor for my HackerAttacks registry
> object:
>
> public class HackerAttacks : Attacks
> {
> public HackerAttacks()
> {
> SqlConnection conn = new
> SqlConnection(ConfigurationManager.ConnectionStrings["GitSConnectionString1"].ConnectionString);
> SqlCommand cmd;
> SqlDataReader reader;
>
> string query = "Select * from DBHackerAttacks";
>
> cmd = new SqlCommand(query, conn);
> conn.Open();
>
> reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
>
> while (reader.Read())
> {
> HackerAttack hackerAttack = new
> HackerAttack(reader.GetInt32(1), reader.GetString(2),
> reader.GetInt32(3), reader.GetFloat(4), reader.GetFloat(5));
> this.attacks.Add(hackerAttack.Level, hackerAttack);
> }
> }
>
> /* ... */
>
> }
>
> The problem occurs with the 'reader.GetInt32(3)' argument. I'm not
> sure why there's an InvalidCastException being thrown there, as column
> 3 in the database is the tpCost column, which is simply an int.
>
> My db, at the moment, only has one row of data. The data leads me to
> believe that the GetInt32 method has an issue with retrieving a 0 as a
> value. I say this because I use the same method on column 1 (level),
> which has a value of 1, and no exception is thrown.
>
> Am I missing something obvious here?
