shanawazway wrote:
string sql = "select projName from tbl_Project";
Change your sql query to
select projName, convert(varchar,dateField,101) from tbl_Project
(where dateField is your date field in the database).
101 will return your date in mm/dd/yyyy format but there are other formats available as well (check out the Convert keyword on msdn for other formats).