while displaying data in gridview date column display time with date. how make date column display date only. and datatype of AdmissionDate is date
SqlConnection con = new SqlConnection(strcon);
SqlCommand cmd = new SqlCommand("Select studentID,Name,AdmissionDate from date where Status!='student'", con);
SqlDataAdapter daGrid = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
daGrid.Fill(ds);
gvstudent.DataSource = ds.Tables[0];
  ...
Go to the complete details ...