c# - 如何在标签中显示日期

Question

    using (SqlConnection conn = conMgr.GetDatabaseConnection())
    {
        using (SqlCommand cmd = new SqlCommand("getEdit", conn))
        {


            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add(new SqlParameter("@id", id));
            cmd.Connection = conn;
            using (SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)) 
            { 
                  while (rdr.Read()) 
                     {
                        TextBox1.Text = rdr.GetInt32(rdr.GetOrdinal("id")).ToString(); 
                        TextBox2.Text = rdr.GetString(rdr.GetOrdinal("name"));
                        DropDownList4.SelectedValue = rdr.GetString(rdr.GetOrdinal("country"));
                        string dt = rdr.GetString(rdr.GetOrdinal("dob"));
                        Label14.Text = dt;




                     }  
                rdr.Close();
            }
        }

dob is datetime type. so pleae tell me how can i display it using lable. how do i convert date time object to srting type.

Answer 1

您需要使用 GetDateTime , 那么你可以使用 ToShortDateString以 dd/mm/yyyy 的格式获取它:

string dt = rdr.GetDateTime(rdr.GetOrdinal("dob")).ToShortDateString();
Label14.Text = dt;