如何从数据库中检索日期并将其绑定到日期选择器

本文关键字：日期 绑定 选择器 数据库 检索 | 更新日期: 2023-09-27 18:36:43

我正在使用SQL server 2005，我想检索存储在数据库中的特定记录的日期，并希望将该日期设置为日期选择器。我该怎么做？

如何从数据库中检索日期并将其绑定到日期选择器

using (SqlConnection connection= new SqlConnection("CONNECTIONSTRING");
using (SqlCommand command = new SqlCommand("SELECT-QUERY", connection))
{
    //set parameters if you need them
    //command.Parameters.AddWithValue("@paramName", paramValue);
    connection.Open();
    SqlDataReader reader = command.ExecuteReader();
    if(reader.Read())
    {
         object date = reader["COLUMNNAME"];
         //Do something with the date...
    }
}

System.Windows.Forms.DateTimePicker dateTimePicker1 = new System.Windows.Forms.DateTimePicker();            
dateTimePicker1.Name = "dateTimePicker1";
dateTimePicker1.Size = new System.Drawing.Size(200, 20);            
SqlConnection connection= new SqlConnection(@"Data Source=DATASOURCE;Initial Catalog=DBNAME;Persist Security Info=True;User ID=USERNAME;Password=PASSWORD"); 
using (SqlCommand command = new SqlCommand("SELECT Top 1 colDate From tblTemp", connection)) 
{     
    connection.Open();
    SqlDataReader reader = command.ExecuteReader();     
    if (reader.Read())     
    {          
        DateTime dt=new DateTime();
        dt=DateTime.Now;
        bool b=DateTime.TryParse(reader["CreatedAt"].ToString(),out dt);
        dateTimePicker1.Value = dt;
    }
    connection.Close();

怎么样

mytextbox.Text = Result_returned_from_Execute_Scalar();
相关文章：