[2.0] date formatting...

[bnathvbdotnet]

DateTime dt = DateTime.Now;
string dt1 = dt.ToShortDateString();

so far my sql statement is at this stage

"SELECT * FROM CMCHOLIDAYS WHERE COUNTRY = 'US' AND HOLIDAYDATE = '07/07/2006'"

I need to convert 07/07/06 which is dt1 variable to '07-Jul-2006' format.