I am getting the error An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or  are not allowed. Add a name or single space as the alias name.
Unclosed quotation mark after the character string ''.
the below code gives me the error
cmd.CommandText = "select * from Holidays where Username =@amorpm and Date < '" & enddate.AddDays(1).ToShortDateString & "' and Date > '" & startdate.AddDays(-1).ToShortDateString & "' "
i have tried cmd.CommandText = "select * from Holidays where Username =@amorpm
and this works fine so the error seems to lie within the date.
The dates are stored as dd/mm/yyyy 00:00:00 and are all filled