c# Insert boolean value into database

Question

I have problem inserting boolean value into database. I have simple structure:

struct
{
   string name;
   bool isStudent;
}

and I want to insert it into data base like this:

 dbCommand.CommandText = "INSERT INTO People (name, isStudent) VALUES ('" + people1.name + "', " + people1.isStudent + ")";
 dbCommand.ExecuteNonQuery();

but i throws exception:

SQLite error no such column: True

Answer 1

Try using:

dbCommand.CommandText = "INSERT INTO People (name, isStudent) VALUES ('" + people1.name + "', '" + people1.isStudent + "')";

Note that 'true' or 'false' will be quoted this way.

Or:

int val = isStudent ? 1 : 0;
dbCommand.CommandText = "INSERT INTO People (name, isStudent) VALUES ('" + people1.name + "', " + val + ")";

1 will be used for true values and 0 for false values.