Date format appear in awkward way

Emmmanuel FIADUFE

2y797C#

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();
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Prasad Raveendran2y ago

Accepted answer

try this

public void LoadVisitors()
{
    dataGridView5.Rows.Clear();
    int i = 0;
    cn.Open();
    cm = new SqlCommand("SELECT * FROM tblFirstTimers WHERE FName LIKE @FName + '%'", cn);
    cm.Parameters.AddWithValue("@FName", txtSearchF.Text);
    dr = cm.ExecuteReader();
    while (dr.Read())
    {
        i++;
        // Parse the FDate column as a DateTime object
        DateTime fDate = Convert.ToDateTime(dr["FDate"]);
        // Format the date as dd/MM/yyyy
        string formattedFDate = fDate.ToString("dd/MM/yyyy");
        dataGridView5.Rows.Add(i, dr["id"].ToString(), formattedFDate, 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();
}

Emmmanuel FIADUFE2y ago
Thank you Prasad

Prasad Raveendran2y ago

there is a SQL alternative solution as well you ca try.

cm = new SqlCommand("SELECT id, CONVERT(varchar, FDate, 103) AS FDate, FName, LName, FGender, FDOB, FLocation, FPhoneNo, FInvitedBy, Staying, InviteesNo, FPrayerRequest FROM tblFirstTimers WHERE FName LIKE @FName + '%'", cn);
cm.Parameters.AddWithValue("@FName", txtSearchF.Text);