my statement[] returns "null"?

Sep 9, 2014 at 3:37 AM
Edited Sep 9, 2014 at 9:40 AM
Here is my code:
using (var database = new SQLiteConnection("data.db"))
     string sql="SELECT id, name FROM foods WHERE id = 13"
     using (var statement = database.Prepare(sql))
          var rr = statement.Step();
          if (SQLiteResult.DONE == rr)
                string ID = (string)statement["id"];
                string Name = (string)statement["name"];

but the statement["id"] or statement["name"] always return "null"?
I fix this by copy the database to the localfolder.
Thx to everyone anyway
Marked as answer by marianosz on 11/26/2014 at 6:23 AM
Sep 9, 2014 at 8:09 AM
Edited Sep 9, 2014 at 8:09 AM
I read that if it's a query statement the Step() would return ROW, and if it's not a query statement the method would return DONE.
But I wrote a query statement it returned DONE, Im sure there is a valid row in that db, so it's wrong of the sql string? then how to correct it?