c# reading integer fields from database

Posted by arnoldino on Stack Overflow See other posts from Stack Overflow or by arnoldino
Published on 2010-05-16T13:29:27Z Indexed on 2010/05/16 13:40 UTC
Read the original article Hit count: 239

Filed under:
|
|
|
|

what is wrong with this code?

try
{
    if (cmd == null) getConnection();
    cmd.CommandText = "Select id from HMonthInventary where machine_id=37";
    SQLiteDataReader reader = cmd.ExecuteReader();
    if (reader.HasRows==true)
    {
        reader.Read();
        string s = reader[0].ToString(); // return first element
        reader.Close();
        return s;
    }
    reader.Close();
    return null;
}
catch (Exception e)
{
    MessageBox.Show("Caught exception: " + e.Message+"|"+cmd.CommandText);
    return null;
}

I checked the sql statement, it turns the right value. why can't I read it? the returnvalue is "".

© Stack Overflow or respective owner

Related posts about c#

Related posts about database