
Hi all,
Through my app i am storing users information in Sqlite database.In database table i have one field which datatype is "Date". while updating Fields in table i am getting following error
"SQL logic error or missing database Insufficient parameters supplied to the command"
below in code which i am using.
mySQLiteCommand.CommandText = "Update Users set LastDate = @LastDate ,Status = @Status Where Name = '" + item.Key + "'and LastName = '" + item1.Key + "'";
mySQLiteCommand.Parameters.Add(new SQLiteParameter("@LastDate ",object)item.Value));
mySQLiteCommand.Parameters.Add(new SQLiteParameter("@Status", (object)status));
mySQLiteCommand.ExecuteNonQuery();
SQLConnection.Instance.Close();
Please help me
Thanks
3 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Suthish NairPosted Jun 13, 2013, 1:46 PM
refer blog :- #stopdebugging
Suthish NairPosted Jun 15, 2013, 1:50 AM
Sumit KumawatPosted Jun 13, 2013, 11:32 PM
Thanks a lott for your help.
i have another bug also i am using SQlite database in my app. sometime while executing insert/update query using ExecuteANonQuery i am getting below error.
"database is locked"
Error code 5.
Note: In my app i am using multi threading.