c# - Ms Access. System.Data.OleDb.OleDbException: No value given for one or more required parameters -

i create selectcommand way:

oledbcommand selectcommand = new oledbcommand(     "select * tablename date between dt_begin = ? , dt_end = ?", connection);  selectcommand.parameters.add("dt_begin", oledbtype.date).value = new datetime(2015, 6, 1); selectcommand.parameters.add("dt_end", oledbtype.date).value = new datetime(2015, 6, 31); 

after execution of command error:

system.data.oledb.oledbexception (0x80040e10): no value given 1 or more required parameters.

first parameter gets 01.06.2015. second - 30.06.2015. not sure in date format, if it's wrong, corresponding error. date column name.

so, can wrong? mean, here 2 parameters , both defined.

try this:

"select * tablename date between ? , ?"