can't select by time in C# Windows FormApp

Question

I'm having problem with my C# Windows Form Application I need to select data by time period Here's my code:

string queryAll = "SELECT * FROM EX_SUM WHERE YEAR 
BETWEEN '"+ from + "' AND '" + to + "'";

I have textboxes from and to But it not working. But when i'm write this code:

string queryAll = "SELECT * FROM EX_SUM WHERE YEAR BETWEEN '05.05.2010' and '05.05.2015' ";

it works correctly

please post the content of `from` and `to`. Preferably directly from the Debugger — Mong Zhu, Aug 24 '18 at 10:42
if you want data by `year` then only pass year in query. dont pass full date — er-sho, Aug 24 '18 at 10:44
@Mong Zhu String from = textBox1.Text; String to = textBox2.Text; — badahboom, Aug 24 '18 at 10:46
I was talking about the actual values of these variables. "Preferably directly from the Debugger". You can also post a screenshot — Mong Zhu, Aug 24 '18 at 10:53
Possible duplicate of [What are good ways to prevent SQL injection?](https://stackoverflow.com/questions/14376473/what-are-good-ways-to-prevent-sql-injection) — mjwills, Aug 24 '18 at 11:22

score -1 · Answer 1 · edited Aug 24 '18 at 11:33

-1

If you are using a multi line string, you need to add " in the end.

string queryAll = "SELECT * FROM EX_SUM WHERE YEAR " +

"BETWEEN '"+ from + "' AND '" + to + "'";

edited Aug 24 '18 at 11:33

Hossein

answered Aug 24 '18 at 10:47

Sam

1 Answers1