There are two option for doing this task
1. take varchar datatype of your table
2. take date datatype of your table
when you throw query from css than
string date=DateTime.now.tostring("here your date format like dd/MM/yyyy");
when you retrieving date from your database than
convert(date,your columnname,103)
where 103 is format of date
for more formats view
http://www.sql-server-helper.com/tips/date-formats.aspx[
^]