Error to make SQLite command in C# using variables?

Question

I have problem in C# to make a SQLite command. I've trying to use code like this:

SQLiteCommand komenda = new SQLiteCommand("SELECT cena FROM dniowka WHERE (model = '@Name' AND element = '@Name2')", cnn);

but it doesn't work... :( before i used LIKE statement:

SQLiteCommand komenda = new SQLiteCommand("SELECT cena FROM dniowka WHERE model LIKE @Name AND element LIKE @Name2", cnn);

it works. But I have a little problem. When I have a few records that contain "AL" for example, "1AL, 2AL, AL ...". I do not know how to do to get the only one record "AL" (@ Name2 = AL).

Does anyone have any idea?

[P. S. sorry for my english ..]

mikey · Accepted Answer · 2013-06-16 12:01:15Z

2

instead of LIKE you can use =

e.g.

"SELECT cena FROM dniowka WHERE model = @Name AND element = @Name2"

Note that I didn't include single quotes:

'@Name' <-- BAD

@Name <-- GOOD

answered Jun 16, 2013 at 12:01

mikey

5,1603 gold badges26 silver badges28 bronze badges

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

Comments

Soner Gönül · Accepted Answer · 2013-06-16 13:28:59Z

1

Because you don't need to use apostrof when you using parameterized queries.

Use parameters in your query like model = @Name not model = '@Name'

The right usage of this;

SQLiteCommand komenda = new SQLiteCommand("SELECT cena FROM dniowka 
                            WHERE model = @Name 
                            AND element = @Name2", cnn);

komenda.Parameters.AddWithValue("@Name", Name);
komenda.Parameters.AddWithValue("@Name2", Name2);

edited Jun 16, 2013 at 13:28

answered Jun 16, 2013 at 12:02

Soner Gönül

99.1k103 gold badges224 silver badges375 bronze badges

Collectives™ on Stack Overflow

Error to make SQLite command in C# using variables?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related