DateTime should change to date in dataset

Question

Dataset value Convert DateTime to Date

   foreach (DataRow dr in dataSet.Tables[0].Rows)
   {
      dr["JoinDate"] = DateTime.Parse((dr["JoinDate"].ToString())).ToShortDateString();
      dataSet.Tables[0].Rows[0]["JoinDate"] = dr["JoinDate"];
   }

Add few lines of your questions too. We cant predict what you want from your question. :) — backtrack, Dec 23 '14 at 05:45

score 0 · Answer 1 · edited May 23 '17 at 11:53

I assume that you want to get the Date part alone form Datetime from your question (datetime is should change to only date in dataset)

foreach (DataRow dr in dataSet.Tables[0].Rows)
            {
                dr["JoinDate"] = DateTime.Parse((dr["JoinDate"].ToString())).Date
                dataSet.Tables[0].Rows[0]["JoinDate"] = dr["JoinDate"];
            }

Datetime.Date will give you the date value.

refer this : How to remove time portion of date in C# in DateTime object only?

score 0 · Answer 2 · answered Dec 23 '14 at 08:59

0

Try this

foreach (DataRow dr in dataSet.Tables[0].Rows)
{
  dr["JoinDate"] = dr["JoinDate"].ToString("dd/MM/yyyy");
  dataSet.Tables[0].Rows[0]["JoinDate"] = dr["JoinDate"];
}

answered Dec 23 '14 at 08:59

Ajay

6,233
15
62
122

DateTime should change to date in dataset

2 Answers2