UPDATE query example
//----- DO QUERY -----
Command1 = new System.Data.SQLite.SQLiteCommand(Connection1);
Command1.CommandText = @"UPDATE tblBookLanguages SET
LanguageText = @LanguageText,
LanguageImage = @LanguageImage
WHERE LanguageId = @LanguageId";
Command1.Parameters.AddWithValue("@LanguageText", LanguageText);
if (LanguageImage.Length > 0)
Command1.Parameters.AddWithValue("@LanguageImage", LanguageImage);
else
Command1.Parameters.AddWithValue("@LanguageImage", DBNull.Value);
Command1.Parameters.AddWithValue("@LanguageId", LanguageId);
Command1.ExecuteNonQuery();
