如何在ASP.Net Web forms中将SQL Server时间值绑定到下拉列表？

<asp:DropDownList ID="ddlTime" runat="server"></asp:DropDownList>

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        // 连接到SQL Server数据库
        string connectionString = "Your SQL Server Connection String";
        SqlConnection connection = new SqlConnection(connectionString);

        // 执行SQL查询语句
        string query = "SELECT DISTINCT TimeColumn FROM YourTable";
        SqlCommand command = new SqlCommand(query, connection);
        connection.Open();
        SqlDataReader reader = command.ExecuteReader();

        // 将查询结果绑定到下拉列表
        ddlTime.DataSource = reader;
        ddlTime.DataTextField = "TimeColumn";
        ddlTime.DataValueField = "TimeColumn";
        ddlTime.DataBind();

        // 关闭数据库连接
        reader.Close();
        connection.Close();
    }
}