Datatype mismatch when trying to insert data into SQLite Database

Question

I am trying to insert a record into a table in C#, but when I get to the line of code to execute the query to insert the record into the table, it just comes up with this error:

An exception of type 'System.Data.SQLite.SQLiteException' occurred in System.Data.SQLite.dll but was not handled in user code

Additional information: datatype mismatch

The code that I have to insert the data into the database is as follows:

string stmt = string.Format("INSERT INTO quotes (id, user, quote, date) VALUES ('', '{0}', '{1}', '{2}')", person, quote, date);

SQLiteCommand cmd = new SQLiteCommand(stmt, connection);

int rowsAffected = cmd.ExecuteNonQuery();

person, quote and date are all strings and the structure of the database is as follows:

id = INTEGER PRIMARY KEY, user = STRING(255), quote = STRING(255) and date = STRING(255)

It looks like you're trying to insert a string (the first element in the values clause) into an integer (id). — Dave D
– Dave D, Commented Dec 4, 2016 at 17:46
I do not know about missmatch problem but you can write query like that too string stmt = string.Format("INSERT INTO quotes (user, quote, date) VALUES ('{0}', '{1}', '{2}')", person, quote, date); if id is autoincremented. — t.m.
– t.m., Commented Dec 4, 2016 at 17:46
Start by using SQL PArameters. If the text includes something like O'Toole it will crash; they will also assure the right type is passed — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented Dec 4, 2016 at 17:47
Look at this answer on how to do your task stackoverflow.com/questions/12785780/… — Steve
– Steve, Commented Dec 4, 2016 at 17:48

t.m. · Accepted Answer · 2016-12-04 17:48:53Z

3

If id is autoincremented, you can insert data with this query

stmt = string.Format("INSERT INTO quotes (user, quote, date) VALUES ('{0}', '{1}', '{2}')", person, quote, date);

answered Dec 4, 2016 at 17:48

t.m.

1,48017 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

John Over a year ago

I will as soon as it lets me

Collectives™ on Stack Overflow

Datatype mismatch when trying to insert data into SQLite Database

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related