DateTime myDT = DateTime.Now.Date;
That will give you just the date!
EDIT: Also remember, if your field in SQL is a DateTime field, it will always save a time, even if you dont supply one. If you want just the date, change the column to be a Date column.
When you get the data back in C#, if you want to just get the string of the date, just use:
DateTime myDT = DateTime.Now;
myDT.ToShortDateString();