Populate List of DateTime objects from Database using C#

Hi kankon,

Please refer below sample for binding list of DateTime from database.

Database

For this example I have used of Northwind database that you can download using the link given below.

Download Northwind Database

Code

private List<DateTime> GetDateTime()
{  
    List<DateTime> dateTimes = new List<DateTime>();      
    using (SqlConnection conn = new SqlConnection())
    {
        conn.ConnectionString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        using (SqlCommand cmd = new SqlCommand())
        {
            cmd.CommandText = "select BirthDate from Employees";
            cmd.Connection = conn;
            conn.Open();
            using (SqlDataReader sdr = cmd.ExecuteReader())
            {
                while (sdr.Read())
                {
                    dateTimes.Add(Convert.ToDateTime(sdr["BirthDate"])); 
                }
            }
            conn.Close();
        }
    }

    return dateTime;        
}