You should try and use Parameterised queries instead of concatenating strings. To compare between dates you can use the SQL Between functoin like this
ss = "SELECT * FROM tablename WHERE expiredate BETWEEN @StartDate and @EndDate"
yourCOmmand.Parameters.AddWithValue("@StartDate", DateTimePicker1.Value.Date);
yourCOmmand.Parameters.AddWithValue("@EndDate", DateTimePicker2.Value.Date);
If you are using Access database (you don't say) you might need to use the "?" parameter type instead of named paramters.
Hope this helps