How to exclude time from date column

Question

Hello Guys :) I have this little problem regarding C# syntax. this is my code

 listView1.Items.Add(new ListViewItem(new string[] {dr["Date"].ToString() }));

This is the Output

And This Output is what i want where Time is not included

I tried this

lisView1.Items.Add(new ListviewItem(new string[] {dr["Date"].ToString("YYYY-MM-DD")}));`
lisView1.Items.Add(new ListviewItem(new string[] {dr["Date"].ToString("yyyy-mm-dd")}));`

Answer 1

Since dr["Date"] returns object which you cannot use overload ToString method of DateTime, so convert to DateTime first by using Field<T> then use correct DateTime format M/d/yyyy in ToString method:

dr.Field<DateTime>("Date").ToString("M/d/yyyy");

You also can refer DateTime format in C# in here.