Loading

date n time picker

ta mu

i am using this code

SqlDataAdapter da = new SqlDataAdapter("Select * from addcustomer Where date=>" + dateTimePicker1.Value + "AND date=<" + dateTimePicker2.Value + " ", my);
da.Fill(dt);
dataGridView1.DataSource = dt.DefaultView;

getting error

Incorrect syntax near '>'.

whats wrong

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
There are three things wrong including the one Arpit picked up. Try:

SqlDataAdapter da = new SqlDataAdapter("Select * from addcustomer Where date <= '" + dateTimePicker1.Value + "' AND date <= '" + dateTimePicker2.Value + "'", my);
0
Arpit Jain13y ago
change this "=>" to ">=" .
0