Winan,

I'm not sure what error you'd be getting but if I may make a suggestion on how I'd write it:

Dim mFromDate As Date = C1DateEdit2.Text
Dim mToDate As Date = C1DateEdit2.Text

Dim mPrintDaily As String = "SELECT * FROM Daily WHERE UDate Between '" & _
mFromDate & "' and '" & mToDate & "'"

This way I would not have to setup the parameters of the command object. To be honest I haven't played arount with the data reader object yet, so if this will apply with how the command object is used I can't really say...

Martin