Hello Team,
In my window application which my date data type is date for this column FDate appears in an awkward way for me because I am expecting the date appear like 22/01/2024 but has hadded time to it as listed below
20/01/2024 12:00:00 am 21/01/2024 12:00:00 am 22/01/2024 12:00:00 am 23/01/2024 12:00:00 am 24/01/2024 12:00:00 am 25/01/2024 12:00:00 am
and this is my query
public void LoadVisitors() { dataGridView5.Rows.Clear(); int i = 0; cn.Open(); cm = new SqlCommand("select * from tblFirstTimers where FName like '" + txtSearchF.Text + "%'", cn); dr = cm.ExecuteReader(); while (dr.Read()) { i++; dataGridView5.Rows.Add(i, dr["id"].ToString(), dr["FDate"].ToString(), dr["FName"].ToString(), dr["LName"].ToString(), dr["FGender"].ToString(), dr["FDOB"].ToString(), dr["FLocation"].ToString(), dr["FPhoneNo"].ToString(), dr["FInvitedBy"].ToString(), dr["Staying"].ToString(), dr["InviteesNo"].ToString(), dr["FPrayerRequest"].ToString()); } dr.Close(); cn.Close(); }