String formatting date - C # or VB.NET

Question

Date of exit from the database, must be formatted as "mm / dd / yy"

For Each dr as DataRow in ds.Tables(0).Rows

Response.Write(dr("CreateDate"))

Next

Answer 1

string.Format( "{0:MM/dd/yy}", dr("CreateDate") )

Edit: If dr ("CreateDate") is DBNull, this returns "".

Answer 2

Convert.ToDateTime (dg ("CreateDate")). ToShortDate ()

See MSDN docs for other functions available from the DateTime data type, including custom formats available through the ToString function.

Answer 3

Response.Write(DateTime.Parse(dr("CreateDate").ToString()).ToString("MM/dd/yyyy"))

Answer 4

:

((DateTime)dr["CreateDate"]).ToString("MM/dd/yyyy")

// , dbnull, ,

if (! DBNull.Value.Equals(dr["CreateDate"])) // blah blah