read datetime from SQL Server to C#

[yosef]

Hello everybody

How to read/write 'datetime' type from SQL Server to C#


Thanks

[aniskhan]

Sample
SqlClient.SqlConnection conn = new SqlClient.SqlConnection("Server=CHEETAH;Database=test;Trusted_Connection=True;");

SqlClient.SqlCommand cmd = new SqlClient.SqlCommand("SELECT DatColumn FROM MyTable WHERE name='anis'", conn);

conn.Open();
System.DateTime d = System.DateTime.Parse(cmd.ExecuteScalar);
conn.Close();